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

University of Michigan

Using Databases with Python

University of Michigan via Coursera


Unlock Unlimited Opportunities: Get 50% Off Your First Month of Coursera Plus
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.


  • 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 OpenStreetMaps API to visualize our data.

Taught by

Charles Severance


4.7 rating, based on 4,633 Class Central reviews

4.8 rating at Coursera based on 21246 ratings

Start your review of Using Databases with Python

  • Anonymous
    This was my first online coding course of any kind. I graduated in the early 90s with a Mechanical Engineering degree, and as part of that curriculum had to take several programming classes. I remember turning to a friend and asking "Can you imagi…
  • Anonymous
    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…
  • "Having completed Using Databases with Python course, I can confidently say it was an excellent experience. The course was meticulously organized, making it easy to follow along and grasp even the most complex concepts. The instructors were knowledgeable and engaging, providing clear explanations and ample opportunities for hands-on practice. I particularly appreciated the structured approach to learning Python, which allowed me to build a solid foundation in programming. Overall, I highly recommend this course to anyone looking to delve into the world of Python programming."
  • Anonymous
    TL;dr. Another disappointed course in the specialization. Old-fashioned teaching style, poor material, useless assignments and too much filled material. Find another course to learn the basics of Python if you can. First things first: if you want t…
  • Anonymous
    Good foundational base for working with SQL in Python. You aren't going to exit this course as a database administrator-designer-superwiz, but you'll get your feet wet enough to make basic programs and go deeper into SQL -- if you so desire. Like ge…
  • This unit was very simple, mainly because it was more "complete the code" rather than writing code from scratch; which would've been extremely time-consuming and mainly unproductive. That said, it would've been a nice touch to explore some of these libraries and discuss in a bit more detail how they work internally (perhaps exploring their source code a little).
  • If you want to pursue a career in Python or just casually explore the field, this course is a fantastic introduction to SQL and a crucial component of learning Python. I thoroughly enjoyed every moment of it and Dr. Chuck is an absolutely fabulous instructor. Highly recommend!
  • It's a very informative course, and the dr. Chuck style of explaining all the details related to SQL is very good. I learned a lot from this course.
  • 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 accomplis…
  • Dr. Chuck is a marvel and a gift to humanity. The course is well explained and the materials are interesting.
  • It's a great course to begin the journey of database
  • Anonymous
    Certainly! However, it seems like there might be a typo in your request. Did you mean "database course" instead of "database course"? Assuming you meant "database course," here's a sample review: I recently completed the database course, and I mus…
  • Anonymous
    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 r…
  • Anonymous
    It is sufficient to say that the University of Michigan itself does not find the level of this course good enough. I have applied for the applied data science masters at the University of Michigan (got admitted), in the application process, you have…
  • a great introduction to databases and integrate python programming to access, create, modify and edit them. no dive deep into the database just explore the surface.
  • For me this was so difficult at the beggining, but I understand because the database management is difficult. After completing this course I'm not an expert but I have good bases and I can learn more SQL's aplications
  • I love this and all the other courses in the specialisation. The instructor inspires a relaxed yet committed approach to the subject. It has been a pleasure doing this course.
  • Dr. Chuck's course is overall commendable, featuring a brisk pace that keeps the material engaging. The assignments, while generally manageable, provide a solid opportunity for hands-on learning. The course strikes a balance between speed and comprehension, offering an efficient learning experience. Highly recommended for those seeking a swift yet enriching journey through the subject matter.
  • Everything appeared to be very relevant - up until but not including the geodata exercise.
    Chuck is doing a good job and the course is challenging and inspiring, for the most part.
    I appreciate chucks effort to prove an alternative to using the real live Google API though, while maintaining relevance and references.
  • Really enjoyed this course and all of the examples and walk-thrus. I only rated it 4 stars because it seems some of the code is no longer functioning for examples such as Twitter or the final assignment. Enjoy the instructor, his pace, and the detail in which he goes into everything.

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.