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

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

Taught by

Charles Severance

Reviews

4.7 rating, based on 4,521 Class Central reviews

4.8 rating at Coursera based on 21152 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
    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
    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."
  • 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.
  • 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.
  • This course is a great opportunity to learn Python for those who're interested.

    As you progress your way into the course it starts getting a little more of a learn-on-your-own sort of course than in the beginning.

    Buying Python for Everybody (the book) certainly helped.

  • 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!
  • 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…
  • 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.
  • 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 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…
  • 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
  • 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.
  • Dr. Chuck's Using Databases with Python course is amazing! The material is presented in a clear way, with plenty of examples and hands-on exercises. The emphasis on practical applications make this course a must-take for anyone interested in learning how to use databases in Python. Highly recommended!
  • Krasimir Vatchinsky
    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…

Never Stop Learning.

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