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

Reviews

4.7 rating, based on 2512 reviews

Start your review of Using Databases with Python

  • 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 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 J.

    Raymond 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 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 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

    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

    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 M.

    Victor 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.
  • Anonymous

    Anonymous completed this course.

    I enjoy the course as well all other 4 courses from the Python for Everybody Specialization from University of Michigan and Dr. Charles Severance.

    Under the expert lead of Dr. Charles Severance, the course present the much complicated and difficult to understand in a first sight coding in Python in a language that is so simple and easy to understand, that you not only learn how to start to code in Python, you also build a fundamendal understanding for coding and learn also not only Python, but SQL, and how to logically find solution for your problem at hand.

  • Anonymous

    Anonymous completed this course.

    The course is good as always with dr. Chuck. They are easy to follow, you learn a lot of new things in a short amount of time and you learn a bit of context as well. I did think this course was rather easy, the assignments where mostly copy-paste of code and the change of a detail. Also there was a topic on Object Oriented Programming. There was very little time spend on it, while I feel like they are an important thing in programming. Also there was no programming assignment attached to it, and it did no relate to the rest of the course.

Related Courses

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