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

Taught by

Charles Severance

Reviews

4.7 rating, based on 3,847 reviews

Start your review of Using Databases with Python

  • Patrick Jane
    A Great Course. Thank you Dr. Chuck! ‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎‎...
  • 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
    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 imagine...
  • 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 time...
  • 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 to...
  • 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
  • Anonymous
    I've loved parts 1, 2 and (some of) 3 of this Python course, but this one falls flat. (Part 3 showed many signs of being dated). The video tuition mostly covers database basics, with only a little time dedicated to Python's interaction with those databases....
  • Always love Dr. Chuck and his teaching. Great Great Great! This course was loaded with information that will be useful to anyone wanting to continue a python programming career path. I learned so much and am ready for the final course in the specialization. Thanks to Coursera and the University of Michigan. Thank you!
  • 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.
  • the working with twitter API and google geo location API was a good experience. and came to a full circle on how to use this technologies and gather data and process.
  • Hello Everyone,

    I have taken this course as part of the specialization which is Python for Everybody, and i found this course very helpful to learn about the databases and the logic behind it.

    Thanks coursera and Dr.Chuck.
  • 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...
  • This course is more about SQL syntax than simple phyton coding. But useful to know. how to create databases. I think it should be on separate course.
  • Amazing online course, good for those who are just starting. User friendly tools with highly interactive materials.
  • Anonymous
    Personally, the first two courses in this program I found to be a great introduction BUT they definitely lacked practical application of what we were learning. I would have liked to use what I was learning more than what the program offered in terms of...
  • 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....
  • Anonymous
    I honestly don't understand why these courses get such high praise - Dr. Chuck is great and all, funny guy, but doodling over powerpoint slides without writing any code doesn't really do much other than get you to sort of understand the theory behind...
  • Retook this view coursera a year after walking through the program directly on Py4E. Consistently builds on previous knowledge gained, but doesn't make you practice some of those key skills as frequently as you might want.

    Highly recommended.
  • Krasimir Vatchinsky

    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...
  • Excellent!! Dr Chuck is a great teacher

    His way of teaching excellent

    I would like to learn more courses from Dr Chuck

Never Stop Learning.

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