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

Related Courses

Reviews

4.7 rating, based on 3,547 reviews

Start your review of Using Databases with Python

  • Abhilash Vj completed this course.

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

    His way of teaching excellent

    I would like to learn more courses from Dr Chuck
  • 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
    This is the fourth course in the five-course Python For Everybody Specialization. I found this course fairly easy, similar in difficulty to the previous course Using Python to Access Web Data. The workload is light so you can get through this course in...
  • 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
    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...
  • 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
    На начало курса я уже немного знал как писать SQL-запросы , и поэтому казалось, что проходить курс будет легко. Однако, из курса я узнал достаточно много нового о структурах баз данных, это меня очень порадовало. Хотя, и осталось туманное представление о синтаксисе Python. Курс в итоге оказался легким, потому что практические задания были простым. Если на курсы 1-3 на практических заданиях тратилось иногда очень много времени, нужно было много думать, то в 4 курсе у вас практически готовое решение, нужно лишь слегка модифицировать его. Практическое задание недели 5 оказалось таким элементарным, что даже странно, что оно не объединено с неделей 4, которая также очень короткая и простая.
  • It is a very good course for a beginner to understand how databases work and how to integrate it with Python. The assignments are very easy which I hope is teaching us something. Thank you Dr.Chuck for making this wonderful course.
  • Kai
    1
    This course was a good introduction to the concept of: -'Objects', classes, methods in Python -SQLite -Refresher of basic SQL statements, JOINs, WHERE clause, ORDER BY, LIMIT -Basics of a good data model in a relational database, multi-table relations,...
  • Anonymous
    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...
  • 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...

Never Stop Learning!

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

Sign up for free