subject

Coursera: Using Databases with Python

 with  Charles Severance
Class Central Course Rank
#1 in Subjects > Programming > Databases

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.

716 Student
reviews
Cost Free Online Course (Audit)
Subject Databases
Provider Coursera
Language English
Certificates Paid Certificate Available
Calendar 5 weeks long
Sign up for free? Learn how

Disclosure: To support our site, Class Central may be compensated by some course providers.

+ Add to My Courses
FAQ View All
What are MOOCs?
MOOCs stand for Massive Open Online Courses. These are free online courses from universities around the world (eg. Stanford Harvard MIT) offered to anyone with an internet connection.
How do I register?
To register for a course, click on "Go to Class" button on the course page. This will take you to the providers website where you can register for the course.
How do these MOOCs or free online courses work?
MOOCs are designed for an online audience, teaching primarily through short (5-20 min.) pre recorded video lectures, that you watch on weekly schedule when convenient for you.  They also have student discussion forums, homework/assignments, and online quizzes or exams.

Reviews for Coursera's Using Databases with Python
4.8 Based on 716 reviews

  • 5 stars 84%
  • 4 stars 13%
  • 3 stars 2%
  • 2 stars 0%
  • 1 stars 0%

Did you take this course? Share your experience with other students.

Write a review
  • 1
5.0 a year ago
by 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 really want to learn coding, the fundament. essential basics you need so you actually start to understand all of the rest that is out there and try to teach you Python, this is the course.

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.

It is GREAT COURSE, GREAT PROFESSOR, Wish more were like him!
2 people found
this review helpful
Was this review helpful to you? Yes
3.0 a year ago
Raymond Jolly 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.
1 person found
this review helpful
Was this review helpful to you? Yes
5.0 2 years ago
by Jason Michael Cherry 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.
15 people found
this review helpful
Was this review helpful to you? Yes
1.0 3 months ago
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. However, the assignment in week 5 is incredibly confusing, requires what feels like a massive increase in complexity, and the instructions were confusing.

In the fifth week, the intent is to learn how to use google's API to search for locations and then visually map them out. However, since the instructions were created before Google made a major change to their API, which now requires a unique key, the assignment could no longer be completed as assigned. This required multiple work-arounds, which some mentors tried to address in the course discussion forum, but these discussions were very confusing and did not clearly identify how to solve the problem. The fifth week of this course needs to be remade, such as with new v
Read more
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. However, the assignment in week 5 is incredibly confusing, requires what feels like a massive increase in complexity, and the instructions were confusing.

In the fifth week, the intent is to learn how to use google's API to search for locations and then visually map them out. However, since the instructions were created before Google made a major change to their API, which now requires a unique key, the assignment could no longer be completed as assigned. This required multiple work-arounds, which some mentors tried to address in the course discussion forum, but these discussions were very confusing and did not clearly identify how to solve the problem. The fifth week of this course needs to be remade, such as with new videos from the professor and/or SPECIFIC DETAILED INSTRUCTIONS showing how to achieve the desired results.

I was disappointed by this course (the fourth in this five course specialization) because I had thoroughly enjoyed all the previous courses from this professor. Until this issue is addressed, I do not recommend this course.
Was this review helpful to you? Yes
5.0 a year ago
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 get my hands dirty, so to speak. The assignments are relatively straightforward and achievable within the time span of each week. The examples provided in the videos are relevant to the assignments, and being able to download them and watch them offline is a great help (the ability to rewind/replay helps a lot). Many of the later assignments involve tweaking existing code rather than building programs from scratch, but that helped me focus on the current topics. I plan to go through the course material to reinforce what I've learned so far.
1 person found
this review helpful
Was this review helpful to you? Yes
5.0 a year ago
Anonymous completed this course.
I just finished this course - the 4th course in the series. I did all of the courses in order, and I thought they were a great introduction to Python. Great instructor and interesting assignments throughout the series. Highly recommended. This last course got into quite a bit of complexity, but the assignments were more focused on "understanding" the complexity rather than creating complex programs from scratch. I think I'll take the Capstone project course for the challenge...
1 person found
this review helpful
Was this review helpful to you? Yes
4.0 a year ago
Anonymous completed this course.
This course covers a lot of material with clear examples.

The assignments are fairly easy as the framework for the assignment is given in the lecture.

The course provides the foundation for the student to develop functioning applications.

However, the class does not deal with validation of input and exception handling to the degree that real robust applications need. The basics are there. In the time available the instructors makes the material interesting and accessible.
1 person found
this review helpful
Was this review helpful to you? Yes
5.0 a year ago
Anonymous completed this course.
Excellent class! Dr Chuck does a great job explaining aspects of computing and programing for most people to understand. He also adds a bit of flair to keep it interesting. The exercises for this course were challenging but helped to solidify what was learned in the course. Just make sure you prepare to take some time to work the exercises as it was a bit frustrating when I was in a time crunch to get the assignments completed.
1 person found
this review helpful
Was this review helpful to you? Yes
5.0 a year ago
Anonymous is taking this course right now.
The entire 4 course buildup has been extremely good in learning python. I knew some programming before tarting the specialization, however combined with the book it will be quite easy for complete begginers to get into programming.

In respect to data bases, I've learned the basic concepts, which is quite enough to make my own simple database when needed.

Needless to say, the teacher si great!!!
Was this review helpful to you? Yes
5.0 a month ago
Anonymous audited this course.
A great course. The only caveat I have is that people auditing the class cannot engage in the exercises and practice, which in turn limits participation in the forums. Needless to say, it makes it an excellent refresher or starting point, but not good for all the goals suggested by the questions in the final survey.
Was this review helpful to you? Yes
5.0 a year ago
Anonymous audited this course.
This is the fourth course in the Coursera specialisation (and the last one you can audit for free). It's a great introduction to integrating databases with your Python code using SQLite, but it really is worth doing all the courses in the specialisation in sequence.
1 person found
this review helpful
Was this review helpful to you? Yes
4.0 12 months ago
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 the description on this website that says: "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.". You do use web crawlers and data gathering/visualization code in this course, but the teacher wrote all of it already, so it is not like you are actually going to write/build these things. Also, because this course is part of a multi-course specialization in Coursera, sometimes the teacher refers to earlier courses in which the students had to work with e.g. XML and JSON. I have never worked with those files, but was still able to complete this Database course, so it is possible to take it as a stand-alone course.

I
Read more
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 the description on this website that says: "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.". You do use web crawlers and data gathering/visualization code in this course, but the teacher wrote all of it already, so it is not like you are actually going to write/build these things. Also, because this course is part of a multi-course specialization in Coursera, sometimes the teacher refers to earlier courses in which the students had to work with e.g. XML and JSON. I have never worked with those files, but was still able to complete this Database course, so it is possible to take it as a stand-alone course.

I am going to look for other courses of the teacher - he makes the matter 'alive'. I also liked the bonus video material in which the teacher interviews some programming 'dinosaurs' which were very much involved or influential in the early computing space. Recommended!
Was this review helpful to you? Yes
4.0 11 months ago
Anonymous completed this course.
Overall I was very happy with the course. In general the material was explained on a level that a beginner could follow. I just wish Object Oriented Python would have explained more detailed in a different course and not just as a chapter in this course.

Also, there is not chapter on Object Oriented Python in the book so it was hard to get more information on this topic.

Besides that, I got confused in the very last lecture when the PageRank example was expained. I still don't fully understand how the PageRank code works which is a bit depressing and I think it's very important to be able to understand it because even in course number 5 when the PageRank is being talked about again, I still don't understand the fundamentals of it.

The PageRank wasn't explained in level detailed enough so one would actually understand (line by line). Also in some other examples new functions were introduced (e.g. buffer()) without explaining what they actually do
Read more
Overall I was very happy with the course. In general the material was explained on a level that a beginner could follow. I just wish Object Oriented Python would have explained more detailed in a different course and not just as a chapter in this course.

Also, there is not chapter on Object Oriented Python in the book so it was hard to get more information on this topic.

Besides that, I got confused in the very last lecture when the PageRank example was expained. I still don't fully understand how the PageRank code works which is a bit depressing and I think it's very important to be able to understand it because even in course number 5 when the PageRank is being talked about again, I still don't understand the fundamentals of it.

The PageRank wasn't explained in level detailed enough so one would actually understand (line by line). Also in some other examples new functions were introduced (e.g. buffer()) without explaining what they actually do and why it's necessary to use them. So while I was 100% satisfied with the first three courses of this specialization, this course sometimes lacks a bit of detailed explanation and I was only satisfied with like 90% of the topics covered.
Was this review helpful to you? Yes
5.0 9 months ago
Anonymous completed this course.
Great course, good for first-timers, as well as veteran programmers.

Good refresher in case you have not coded in a bit.
Was this review helpful to you? Yes
4.0 6 months ago
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 can generally be completed with 15-30 mins' effort (which is fine), but also don't leave you with a deep firsthand understanding of what's going on. i.e., you have to understand enough of the syntax you're seeing to adjust it - and that's good - but the really challenging part of writing programs or scripts is abstracted somewhat from that level: it's the thinking about design and process that matters far more than the syntax itself. And because the courses focus on showing nifty applications of the skills being taught, the demos used in the assignments tend to be too high-level for the target audience, which in turn means that for them to be 'fair' or 'accessible', they need to drastically scale back what the assignment expects of the st
Read more
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 can generally be completed with 15-30 mins' effort (which is fine), but also don't leave you with a deep firsthand understanding of what's going on. i.e., you have to understand enough of the syntax you're seeing to adjust it - and that's good - but the really challenging part of writing programs or scripts is abstracted somewhat from that level: it's the thinking about design and process that matters far more than the syntax itself. And because the courses focus on showing nifty applications of the skills being taught, the demos used in the assignments tend to be too high-level for the target audience, which in turn means that for them to be 'fair' or 'accessible', they need to drastically scale back what the assignment expects of the student.
Was this review helpful to you? Yes
5.0 3 weeks ago
by Bang103 Tunedin audited this course.
I audited the earlier courses in the Programming in Python also, but was familiar with the material so mostly studied from his book. However, for databases as well as the accessing the web with Python specializations, I felt the need for a 'teacher' and went through all the lecture videos. They are excellent!! Dr Chuck is an amazing teacher. I would also like mention the Bonus Interviews....it is fascinating to hear all stalwarts of the field talk about their work. I had not heard about many of them and these interviews brought the history of computing alive. Dr. Chuck's courses are all holistic, that is the best way I can describe them in one word. It is not just programming in Python(which he teaches amazingly well anyways), he talks about Industry standards and how they evolved, the history...learning from Dr. Chuck is a unique experience. I have taken up other programming courses on Coursera, so I can say that! I have only audited this course, as all others.
Was this review helpful to you? Yes
5.0 4 days ago
by Dominic Walters completed this course, spending 5 hours a week on it and found the course difficulty to be medium.
This was a great course. I started the Python for Everybody specialization in Coursera a few months ago. When I started, I knew almost nothing about computer programming and I certainly didn't know a bit of Python syntax. The first few courses were a bit difficult, but the material was presented in a straightforward manner. The later courses, including the course titled Using Databases with Python, built on the lessons learned during the earlier courses. While these later courses did not cover as much material (an therefore weren't as difficult) they did a great job showing how Python worked with other languages (SQL, XML, JSON). It also showed the scope of capabilities of the Python language. This course had great breadth but not much depth. I would NOT recommend this course without first taking the prerequisite courses in the Python for Everybody specialization. If you have taken those courses already, this is a GREAT continuation.
Was this review helpful to you? Yes
2.0 9 months ago
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 assignments, but aren't explained until later lessons. The videos are filled with comments like, "Oh, and by the way, my little guy returns None if there's nothing found," and, "I probably misused it, is this key I'm looking for, which is like the string name or whatever. I'm using the key twice. But, okay, whatever." I cringe to think how painful it must be for foreign students.

I definitely learned things from this class, but that learning could have been so much more, and could have been so much easier. This is not the best of online learning . . . and the University of Michigan shouldn't be offering anything less.
Was this review helpful to you? Yes
5.0 3 months ago
by Shah Moussavi completed this course, spending 2 hours a week on it and found the course difficulty to be medium.
Very good course for people in picking up the basics of the Python programming language. It also covers additional programming topics like data modelling, SQL and object oriented programming. The material is appropriate for the level. Had a lot of fun doing it and could not wait to go through the weeks.

Things I like about the course:

1. Materials are well presented with the proper context

2. Office hours and interviews were excellent as it provides perspective into other topics

Things I wish for the course:

1. A way to discuss coding style to do things better and more efficient. Cannot post code on the forum. So somewhat difficult to get feedback regarding the code

2. Last week of this course was way too easy and it did not provide an opportunity to code. It would have been nice if we had to do some coding instead of simply running a code.

Was this review helpful to you? Yes
3.0 a month ago
Anonymous completed this course.
It is a very useful course to begin with, the use of databases etc is well explained and I found this module possibly the easiest so far, that might be due to improved Python skills from previous courses and also because I've some knowledge of SQL from the day job. However what scuppers this course is week 5 - Python appears to go out the window and a stream of endlessly confusing instructions to basically chase Google API's about doesn't really teach you anything other than those Google API's are a pain to chase about. There are new readme files in the material you can download but nothing really showing which may or may not be the latest. The principal is OK at this point but the leading/teaching/execution of it leaves a lot of room for improvement. Worth doing but can be very frustrating.
Was this review helpful to you? Yes
  • 1

Class Central

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

Sign up for free