Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Online Course

Using Databases with Python

University of Michigan via Coursera

Overview

This course will introduce students to the basics of the Structured Query Language (SQL) as well as basic database design for storing data as part of a multi-step data gathering, analysis, and processing effort. The course will use SQLite3 as its database. We will also build web crawlers and multi-step data gathering and visualization processes. We will use the D3.js library to do basic data visualization. This course will cover Chapters 14-15 of the book “Python for Everybody”. To succeed in this course, you should be familiar with the material covered in Chapters 1-13 of the textbook and the first three courses in this specialization. This course covers Python 3.

Syllabus

Object Oriented Python
-To start this class out we cover the basics of Object Oriented Python. We won't be writing our own objects, but since many of the things we use like BeautifulSoup, strings, dictionaries, database connections all use Object Oriented (OO) patterns we should at least understand some of its patterns and terminology.

Basic Structured Query Language
-We learn the four core CRUD operations (Create, Read, Update, and Delete) to manage data stored in a database.

Data Models and Relational SQL
-In this section we learn about how data is stored across multiple tables in a database and how rows are linked (i.e., we establish relationships) in the database.

Many-to-Many Relationships in SQL
-In this section we explore how to model situations like students enrolling in courses where each course has many students and each student is enrolled in many courses.

Databases and Visualization
-In this section, we put it all together, retrieve and process some data and then use the Google Maps API to visualize our data.

Taught by

Charles Severance

Related Courses

Reviews

4.7 rating, based on 2660 reviews

Start your review of Using Databases with Python

  • Nikita Neganov completed this course, spending 1 hours a week on it and found the course difficulty to be easy.

    That's a great introductory course to using databases, it helps to deal with data and creates a little background to further data analysis. Though it almost doesn't add anything new to python, I found it's interesting and it also helped me to upgrade my previous program using DB instead of text files.

    In a nutshell, not very challenging course with pretty simple assignments which only require to review the sample code and alter it a little bit.

    4,5/5 because it was not challenging enough, though good.
  • Anonymous

    Anonymous completed this course.

    When this course was originally developed, at least 2 years, ago, it must have been a decent course for its intended audience, which,most likely, were people attending a live course. Unfortunately, the course has some serious structural flaws that time...
  • Anonymous

    Anonymous completed this course.

    This is described as a five week course, spending a couple hours each week. I found every week interesting and well organized EXCEPT for week 5. If this were a four week course and the fifth week material was deleted, I would give this a five star rating....
  • Krasimir Vatchinsky completed this course, spending 10 hours a week on it and found the course difficulty to be medium.

    I really enjoy the course as well all other 4 courses from the Python for Everybody Specialization from University of Michigan and Dr. Charles Severance. I did tried numerous times to learn Python till I found this course, and this is the ONE!! If you...
  • Profile image for Raymond Jolly
    Raymond Jolly

    Raymond Jolly is taking this course right now, spending 1 hours a week on it and found the course difficulty to be medium.

    Okay I have spent 20 years working with databases as an finance analyst and project manager but I never used them with an OOP language before. So the first segments of the course were VERY easy for me. However I like where Dr Chuck went with explaining to his students how large data sets need to be managed. The last 2 segments are actually very fun exercises but I wish that the last segment allowed the student to do more writing to of the code. For the Geocode segment I felt a let down. The exercise is useful and the code has some real world applications but I would have gotten more out of it if I was able to write some of the segments myself.
  • Charles Lenfest completed this course, spending 5 hours a week on it and found the course difficulty to be medium.

    I am in the process of completing the Python 5 course Specialization and I absolutely love these courses. Dr. Chuck and his team have put a tremendous amount of thought and technical planning into making this course something that you can accomplish...
  • Anonymous

    Anonymous completed this course.

    There's some great content here and I found myself wanting to rate it higher, but this course -- like the others in the series -- is obscured by sloppy production. There are things (like the use of triple quotes, and cur.executescript) that appear in...
  • Jason Michael Cherry completed this course, spending 3 hours a week on it and found the course difficulty to be medium.

    Outstanding class, like all its predecessors in the specialization! At the end the assignments do get a little more along the line of 'adjust my code' rather than 'write your own code', but the programs are very complex at this point, and the instructor does an excellent job of explaining what to do and how to do it.
  • Anonymous

    Anonymous completed this course.

    nice course nice course nice course nice course nice course nice course nice course nice course nice course nice course nice course nice course nice course nice course nice course nice course nice course nice course nice course nice course nice course...
  • Anonymous

    Anonymous completed this course.

    This was an informative course, and the teacher made it easy to listen to him because of his sometimes funny way of explaining. SQL basics are covered, and I learned how to work with SQLite in combination with Python. However, I don't fully agree with...
  • Anonymous
    This is the fourth course I do and I enjoyed it every single bit. However, I must confessed I found it a bit "weaker" than in the previous three. I had the impression they were two relatively easy assignments that took me particularly long due to lack...
  • Anonymous

    Anonymous completed this course.

    I took the specialization Python for Everybody. The 1st and 2nd courses are great, very friendly for beginners, and encourage you to write up a bit of code by yourselves. That's really a helpful practice. When I came to the course 3 & 4, I began to feel...
  • Anonymous

    Anonymous completed this course.

    The course (and its predecessors) is a helpful introduction to basic Python and SQL functionality. However, precisely because it is an introduction only, the assignments are largely of the "here's some code, please tweak it" variety. As a result, they...
  • Anonymous

    Anonymous completed this course.

    I did dis course as the 4th out of 5 courses from Python Specialization. I applied for the free course and I got it in two weeks. Dr Chuck is a very good professor, with a nice sense of humour and very experienced in the field, things that really matter...
  • Anonymous

    Anonymous completed this course.

    This has been a great introduction to Python. I've been around programmers for most of my career, but most of my exposure to coding has been through reading and reviewing what other people develop. This course is giving me a chance to get in there and...
  • Anonymous

    Anonymous completed this course.

    I have been with Charles Russell Severance since the very first course. From my first print ('hello world'). All the way to creating databases, parsing the web and creating visualizations with data. To be honest it makes me kind of sad knowing that...
  • Anonymous
    This course is excellent. As an online educator at another Big 10 University, I have to say that all of these courses are done well. The complaints about the fifth week of this course are accurate -- if you think that every final week of a course should...
  • Anonymous

    Anonymous completed this course.

    Took the course in August 2019. Like the other courses in this specialization the material is well organized and presented at a level that allows (I think) anyone who is willing to try to succeed. The course is advertised as 5 weeks but can be completed sooner if you have the time. The sample code works and the instructor is very personable. My only regret is not discovering this sooner. As a side, one key thing that I gained an appreciation for is open source (Python in this case) is being learned at scale internationally. I think that is a very good and exciting thing. It helps me better understand that coding or the ability to read code will be an essential skill in the next generation.
  • Anonymous

    Anonymous completed this course.

    I must confess this is the best course for you to learn Python and to at least start interacting with the database using Python.

    I have as seen others review, but I would say that the week 5 is aimed at making you think deeper and wider as the assignment was created some years back, attempting the assigment now only mean you might have to use the API key from Google, you will need to change some certain things in the code to connect to google itself which worked for me otherwise you use the already populated json on Py4e.

    However, the instructor has really tried and it has been such a wonderful time going through the course.

    Hoping to advance more.
  • Profile image for Victor Kalu Mba
    Victor Kalu Mba

    Victor Kalu Mba completed this course, spending 2 hours a week on it and found the course difficulty to be easy.

    This course: Using Databases with Python is the fourth(4th) course in the Python for Everybody specialization. I must confess that I enjoyed the course and learnt a good deal as well. The course started with an introduction to databases, spanned an interesting...
  • Anonymous

    Anonymous completed this course.

    Brilliant course for learners at the beginner and intermediate level.
    The course first covers concepts of Object-Oriented Programming in Python and then goes over to Relational Database Management Systems.
    It covers a wide variety of SQL Queries and integrates the same with python to make spiders which can dump data from an API and finally visualize it.

    Dr. Chuck Severance is a brilliant educator and he takes us from the very basics of the concepts and scales them to application levels. All of this is achieved without looking very difficult. I highly recommend this course.

Class Central

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free

Never stop learning Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free