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

  • Provider Coursera
  • Subject Databases
  • $ Cost Free Online Course (Audit)
  • Session Upcoming
  • Language English
  • Certificate Paid Certificate Available
  • Start Date
  • Duration 5 weeks long

Taken this course? Share your experience with other students. Write review

Sign up to Coursera courses for free Learn how

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.

Taught by

Charles Severance

Class Central Charts

Related Courses

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

  • 5 stars 83%
  • 4 stars 14%
  • 3 stars 2%
  • 2 stars 1%
  • 1 stars 0%

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

Write a review
  • 1
Anonymous
1.0 2 months ago
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 and the online media have exacerbated.

First of all, the course was originally built around python 2 and had to be ported to python 3.

As a consequence, there are often reminders of how this or that thing was changed from a version to the next, which is just a waste of students' time.

The ma…
Was this review helpful to you? Yes
Krasimir V
5.0 2 years ago
by 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 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
Raymond J
3.0 a year ago
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.
1 person found
this review helpful
Was this review helpful to you? Yes
Jason C
5.0 2 years ago
by 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.
15 people found
this review helpful
Was this review helpful to you? Yes
Anonymous
1.0 6 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 G…
Was this review helpful to you? Yes
Anonymous
4.0 9 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:…
Was this review helpful to you? Yes
Anonymous
2.0 a year 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
Anonymous
5.0 2 years 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
Anonymous
4.0 2 months ago
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.
Was this review helpful to you? Yes
Anonymous
5.0 2 years 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
Anonymous
4.0 2 years 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
Anonymous
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
Anonymous
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
Anonymous
5.0 4 months 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
Anonymous
5.0 2 years 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
Anonymous
4.0 a year 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 lik…
Was this review helpful to you? Yes
Anonymous
4.0 a year 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 ve…
Was this review helpful to you? Yes
Anonymous
5.0 a year 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
Brian T
5.0 4 weeks ago
Brian completed this course, spending 1 hours a week on it and found the course difficulty to be easy.
Thoroughly enjoyed the class. The class is largely a DB class, Dr Chuck is clear about that right up front. If you don't know anything about databases, the course takes you through the basics very quickly of good database design and how to get databases up and running in SQLite. If you naturally think in well formed data structures, the class will be relatively easy; if not, then you may want to plan to take more in-depth course with access to an instructor after finishing this course. Toward the last couple weeks of the class, you take a significant leap in database and code complexity to …
Was this review helpful to you? Yes
Костя Т
2.0 2 weeks ago
Костя completed this course, spending 4 hours a week on it and found the course difficulty to be very easy.
This is the fourth course in the Python for Everybody specialization.

And... actually, it more about SQL than python.

The first week about OOP, but there aren't any assessments, in order to learn it by heart, so, actually, you can just skip this week and read something in google.

The weeks from second to fourth about SQL and there is a bit about python. I would recommend to read about sqlite3 module in python docs and something about SQL(if you know nothing about) somewhere instead.

I quite confused about the last week, because it looks like …
Was this review helpful to you? Yes
  • 1

Class Central

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