Chevron Left
Back to Using Databases with Python

Learner Reviews & Feedback for Using Databases with Python by University of Michigan

4.8
stars
21,317 ratings

About the Course

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....
Highlights
High quality course material

(143 Reviews)

Top rated instructor

(176 Reviews)

Top reviews

MM

Mar 12, 2018

The course is great... You can definitely learn many things... Was kind of hard for me and i went many times back and forth through most of the lectures... However i think i learn many new things....

JL

Jun 22, 2017

Wonderful course! I learnt many useful SQL statements and know how to combine database operations into python program. Dr. Chuck's lectures are always comprehensible and clear. Thank you, professor.

Filter by:

2601 - 2625 of 3,216 Reviews for Using Databases with Python

By Aarya P

Sep 9, 2020

Helps you learn how to deal with database in python . SQLite is also taught and how to see into database.

How python programming can help you get the data using an API. How you can extract and clean data using

python. Not really for the beginners but the course was tried to make simple. The professor is awesome

i could say that. You do need help from outside for some of the topics like what is SQL? But a brief

about such topics is given too . Nice instructor and nice lectures too. A little tougher course and not for absolute beginner

By Thomas H

Aug 11, 2019

The introduction of databases and integration with Python introduces a real-world application to this programming introduction. The content was informative, practical, and I will rely heavily on this course's content in the future. I did, however, find this course directed students more toward relying on existing code and tweaking it rather than thinking through the process and developing it from scratch. For this reason, I found this course to be a little weaker on delivery than the previous ones in the specialization.

By Jason A

Oct 27, 2017

Great coverage of the material, however some of the sample scripts were nearly complete and required little, if any, modification to complete the assignments. They clearly tried to find the balance between providing challenging exercises and providing working packages of scripts so that students can accomplish more complicated tasks using additional tools that are, on their own, beyond the scope of the project. I just think they could have provided a bit less to make some of the later exercises a bit more challenging.

By Jonpaul W

Mar 2, 2016

Good initial overview to the topic. Most code is actually provided to the student, preventing deeper learning via trial & error. However, it is a tradeoff of making the course accessible to a large number of students versus being too challenging and preventing newcomers from enjoying the subject. Dr. Severance is excellent -- entertaining and clearly very knowledgable. For any novice programmers looking to understand how Python interacts with databases, this is the best place to start.

By Marin T

Mar 25, 2021

Nice general introduction to SQL. Useful examples with Google and Twitter APIs. Too bad they are getting harder to use due to limitations.

Might be worth considering using other API resources, perhapse closer to Open Source, like OSM's Nominatim or OpenWeatherMap instead

Some of the graded tasks are perhaps too assisted - with most of the code written and shared. The fact that actual Python code doesn't need to be shared doesn't encourage me to write in clean and well-commented manner

By William D

May 10, 2016

Short, but jam packed with stuff you need to know in order to get working with Databases. The ending lesson was a little disappointing as we weren't tested on how to do some of the suggested projects that the teacher was talking about and instead only had to download and run a program on our computer. However, this class equips you with the knowledge to get a start in Data Science and Database engineering, as well as good practice and better understanding of how to use Python.

By Jayven C

Jan 25, 2016

Dr. Chuck once again breaks down very complex subject matter into easily digestible chunks for us newbies. My only issue with this course is that the hardest parts of the assignments were already done and all that was required from us was some slight tweaking in existing code. That may or may not be intended and the real challenge lies with the Capstone Project.

Nonetheless, if you are curious about how databases work, there's lots to learn here. I know I did!

By Michael D

Mar 15, 2019

This course is great as a very high level - quick intro to relational data modeling and SQL. I would have like to have spent some more time in practice with writing to and reading from databases via Python as the jump from executing a script in SQLite/ database manager to creating a cursor and executing formatted scripts and fetching the results is a little wide.

As always, great materials, but could have done better with more practice.

By Udbhav J

Sep 16, 2017

Decent course but some of the assignments required a lot of initiative to go and search the web in order to fully understand them. Material is understandable and very clearly presented allowing for a natural progression from the previous courses in this specialization. I am glad that I understand more about how Python works although I am not sure I am confident enough to apply some of the higher order skills taught in this course.

By Justin G

Feb 15, 2016

The course is great in that I felt I gained alot of insight into how data mining is done but I don't feel I gained much skill in using databases with python. The assignments are making minuscule modifications to existing code. I think it would have been a better exercise to either write a new program for each assignment or have the student build out a single program throughout the course. But, as always, Dr. Chuck is the best.

By Bharat P

Aug 29, 2020

A great course. I loved reviewing the worked examples and working on the assignments. I understand that this course gave a taste of what is possible with databases and Python. I understand that. I suggest having more involved extra-credit assignments. For my part, I shall take some of Dr. Chuck's samples and line-by-line attempt to reproduce (or reverse-engineering his results) and to really grasp his nifty syntax.

By Joseph D

Aug 24, 2021

The concepts presented in this course were helpful in learning how python can be used to structure and architect databases. I would have like more exercises that required me to generate my own code. There is a large component of downloading and running code that is already written with very little editing and generally no debugging. I felt that the course was a little too easy towards the end because of that.

By Chao Z

Feb 18, 2016

This course gives very basic information about using python to retrieve web data in json and html format. It's helpful and makes the learners feel good. This course is that it prepares almost ready codes for every test and homework. This could be a good reference for people who want know how to do sth, but have no much time digging into the complex way. However, it may also reduce the strength of learning.

By Vicente G R

Apr 16, 2021

I believe the assignments tend be too easy and do not promote using the learned concepts in different ways. Also, I believe that some explanations were missing. In general, I think that including material as in the last assignment with script or code not covered in the course (javascript/html) is not a good idea because we end up using something without understanding fully how it works.

By Djamshid B

Dec 2, 2019

As usual Professor Charles Severance was too meticulous to make a course taker understand the fundamentals of database design and querying. However, as a certified database administrator I lacked the information on normal forms - the framework for any relational database architecture. However, maybe I am just requiring too much from the short course for beginners.

By KARTHIKEYAN B

Mar 21, 2020

Good course. However I think it would be better if the codes are not spoon fed. May be I could be wrong and that is how it needs to be taught - but when codes are mostly written, simple hacks can generate credits. But the hardwork of Mr Severance and his invisible colleagues is visible in every lecture and slides!!! Thanks to Mr Severance for wonderful experience

By Raffaele L

Oct 14, 2022

This course was my introduction to SQL and databases, in addition to using python and SQL together to accomplish a desired outcome. Overall, the course was good, but less time is spent explaining everything in detail in comparison to the previous three courses; therefore, more time must be spent to ensure that you learn everything and understand every concept.

By Roger M

Oct 27, 2021

The course provided an overview of databases and SQL and how Python can be used in relation to them. One gets an introduction to techniques of data science. There was not a lot of programming in this class. Most of the exercises/problems consisted of making small modifications to sample code. Dr. Chuck is a knowledgeable, effective, and entertaining instructor.

By Fredrik M

Oct 30, 2016

This works really well for an introduction on databases and how to use them with Python. The exercises are maybe a bit too easy. On the one hand, this makes it easy to actually complete the course (and you still learn the basics), but on the other hand, you don't get that familiar with the material.

The lecturer is intelligent and funny and structured.

By 王颖亮

Jul 3, 2018

I think this course is a bit of shorter. The final assignment could be arranged in a way more challenging than now it is. Besides, there are a lot of features in SQL can dig in, say LEFT/RIGHT/OUTER JOIN, GROUP BY, HAVING, Nested SQL structure, some basic SQL formula/functions like Max/Min/Sum/Average which is not tricky and fundamental in SQL.

By Jaydeep T

Jan 31, 2021

A lot of code is done based on other technologies that most people don't know about. Dr. Chuck doesn't get to go in detail about that. I think the course structure should cover everything (at least at a basic level) that is used in a code. Some students may not find it too hard but not everyone here is from CS background. Good course overall.

By Pradeep A

Nov 29, 2019

Another great course by Dr. Chuck. He is eloquent, patient and clear about what his explaining. However, I feel that he should have gone into greater detail about certain topics such as APIs, geodata and database management. Nevertheless, this is an excellent course and everyone interested in database management (using Python) should try it.

By Akshat A

May 20, 2018

I understand that delving into databases was not the motive and based on that the brevity of this course is rather appreciated. Although superficial examples raised the bar too high. Geo-coding example kind of turned down the spirits since i was unable to understand whether or not to understand the given JS and HTML codes.

By Carl B

Apr 20, 2018

Really enjoyed the course however I found some language not explained properly in enough detail. Also found some of the worked examples too complete. Had to go over and rewrite from scratch so I understood fully - would be nice if some had a couple of assignments, one simpler and one complex so its not so much of a leap

By Julián C

Nov 1, 2019

It is a great course, but it would have been great that it included how to perform data visualization in Python instead of just showing Javascript code. And I would also like to recommend to write at leat most of the SQL statements instead of just pasting them. Having said that, thank you Chuck for your efforts!