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

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

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

Overview

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

Help Center

Most commonly asked questions about Coursera Coursera

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

  • 5 stars 81%
  • 4 stars 16%
  • 3 stars 2%
  • 2 stars 1%
  • 1 stars 1%

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

Write a review
  • 1
Anonymous
1.0 8 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
Anonymous
1.0 a year 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
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 2 years 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 3 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.
16 people found
this review helpful
Was this review helpful to you? Yes
Anonymous
4.0 a year 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 2 years 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 8 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 2 years 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
1.0 2 months ago
Anonymous completed this course.
It almost doesn't teach Python. Instead of teaching commands, comparing results and discussing different ways to solve problems, like the previous modules did, this one is mostly about SQLite - and that's NOT what I signed up for. A few pre-prepared codes are provided (the only real advantage of this course), you just need to change names of variables or add conditions. Talking about disappointment...!
Was this review helpful to you? Yes
Anonymous
5.0 2 years 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 11 months ago
Anonymous completed 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 completed 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
2.0 6 months ago
Anonymous completed this course.
Another disappointing course in the Python specialization offered by UMAA. The assignments are laughable. A mostly superficial course. The only reason I undertook the course is because I had already paid for the 5-course specialization. I wouldn't recommend.
Was this review helpful to you? Yes
Anonymous
4.0 6 months ago
Anonymous completed this course.
I had put a rating of 4 stars for all 3 of the other courses before this one in the specialization, because in each course there is things you are told to do but you don't know why you do them or how it works, you're told it just works with them.

This 4th one was for my part tougher, but I had learned a lot from previous courses and by myself on things not so well explained in the previous courses so I could understand everything done in this course.

As others said, the 5th week is disappointing, the 2 videos from the lectures are almost the same, and you don't lear…
Was this review helpful to you? Yes
Anonymous
4.0 2 years 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 2 years 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
  • 1

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.