Chevron Left
Back to Using Databases with Python

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

4.8
stars
21,315 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:

51 - 75 of 3,216 Reviews for Using Databases with Python

By liu x l

Jan 2, 2016

Same as the 3 previous courses in this specialization, this one is also very informative. And the explanations are very clear.

Only one thing I realize after these 4 courses -- exercises are all very simple, or rather, the difficult part of the exercises are already made, and we only need to add very simple part of the code. This way we don't get much practice. As a result, when i wanted to program something myself, i needed to search for references constantly. But probably the final project of the specialization is exactly there to cover the practicing part. Looking forward to it.

By Daniel C

Jan 15, 2016

It's still a good series of courses, and now they are breaking down the lectures into shorter chunks. That makes it easier to download and easier to manage my study time.

The slides and screenviews are still hard to see. Tiny purple text on a black background just *does*not*work*.

Up to week 2 I'm finding the explanations are not deep and detailed enough, and the assignments are too easy and superficial.

But I guess that's OK, it's a short course and it gives you a quick overview of a bunch of different technologies. It is very good at that.

By Nickson O

Sep 5, 2020

This course lays a concrete foundation to structured query language (SQL) and SQLite3 database browser (this is just but one among many including MySQL, SQLServer, Oracle, PostgreSQL, etc.) and relational databases in general. No mention of nonrelational databases like MongoDB although it's a perfect start. I plan to learn more databases. I also learned some unique tips from Dr. Chuck's brief introduction to object oriented programming (OOP), which I could relate to SQL. I recommend this course to anyone who has some background in Python.

By Ashutosh D

May 15, 2017

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. This course will cover Chapters 14-15 of the book “Python for Informatics”. 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 2.

By Abbas J

Oct 18, 2020

Maybe the best course in the specialization, it also a quit reasonable intro to SQL and Sqlite database. It treated what was possibly the most complex subject in this specialization with a lot of care, neither simplifying too much nor making SQL and RDBMS concepts too difficult to understand for novices.

I have been saying this repetitively, but with this particular course, it is worth repeating even more: more exercises, maybe some thing like

https://codingbat.com/python would be very useful. So would more quizzes.

By Anand B S

Oct 17, 2016

The Teacher made me thirsty of more work. Especially in the last chapter, I was looking for more challenging work. The way the assignment was designed and the topics were taught made me think, the assignment for the last week was quite easier and I was expecting something more challenging. This proves the beauty of this class. I wish I have a trainer like this always with me, at least as long as I cannot go out and look for work myself.

Thanks a million to Dr. Charles Severance. This is a very positive experience.

By Kieran M

Feb 2, 2017

Dr. Chuck is very knowledgeable and clearly passionate about ensuring that everybody know how to program. Further to this, the information that was provided in this course, along with the specialization's accompanying courses, gave me enough knowledge to begin my own venture into scraping, cleaning and storing web content. Add this to the University of Michigan's specialization in Data Science and you'll definitely have solid foundational knowledge of how to collect, manipulate and analyze digital data.

By Christina O

Dec 31, 2015

Dr Chuck makes the daunting look less daunting. Subjects covered include exploration of API, grounding in data scraping etiquette, basic data modeling economical database normalization, continuation of Google API geocoding, use of Python for scraping and cleaning data. The course assumption is that if you made it this far, you can handle a speedier pace of content delivery. The discussion forums are more valuable too, as one learns what libraries and functions differ between Python 2.7.x and Python 3.x.

By Jianghong Y

Jun 21, 2019

I'm going to recommend THIS course to everyone, to me it's like the core course of the whole bunch of stuff. It's very easy to find syntax about Python on the web, cause you have Python in your mind, after all that what you're pursuing. But modern programming is more than that: you need storage to store all information/data you gathered. That's why you need to learn this course. All basic concepts are covered, SQL, primary key, etc. Even if you don't use Python, databases are still of most importance.

By Edward F

May 31, 2017

I took the Python Specialization, which included this course, so I'm going to provide the same review for each of the component courses.

I think this is an excellent course for beginning programmers. Python is a great language for someone starting out - easy to learn - with a lot of power available for more advanced projects (e.g., machine learning).

But, most of all, you have to love Dr. Serverance. I can't think of a more entertaining and enjoyable person to teach programming. Thanks, Dr. Chuck.

By Nestor R

Jan 13, 2016

As having completed all coursers of introduction to python environment, I can fully recommend this series of courses to anyone interested in learning how to program. Is it not an impossible task, just a little time and commitment. Thanks to Dr. Chuck, he is the best teacher and he really knows how to lay these subjects in an easy and understandable way. I hope in the future there will be more courses like these to become a better programmer and student and to learn new and interesting things.

By Mustafa K

Jun 3, 2017

I had a basic knowledge on SQL and database. This course gave me opportunity to use these skills in a programming language Python. Course provides not only dealing with SQL but also other web data exchange tools such as xml and json. As all you know from former courses, Dr. Chuck makes a great job and keep everything simple by giving key points and ideas to students and encouraging them to explore more of it. Thanks a lot for this great course series and highly recommend to anyone.

By Youssef E

Dec 31, 2020

Simply amazing, I never thought I would be able to do so much with Python, matter of fact I didn't know Python had so much capabilities. Very well explained, Prof. Charles made it very easy and understandable and with so many codes and exercises given you can practice and get hands-on coding. I specially loved the last quiz where I was able to get an API key from google and insert it into my code in order to get the location of a nearby building and visualize it on maps. AMAZING

By JieZhang

Mar 5, 2020

Overall good. However, I often feel incomprehensible during the lecture. Teachers often mention things that have not been taught before. And I have no foundation in computers, which leads me to not understand what the teacher is saying. There are too many codes that have not been taught in the code examples. Although I can roughly understand what those functions are, I can't clearly understand the meaning of each line in a program, which makes me feel frustrated and confused.

By Jasper A B

Sep 15, 2020

Great learning experience. Now on my last leg of the specialization and I feel comfortable making my own programs. I started with 0 programming knowledge but advanced Excel skills. I have made various programs and made even more friends withing the PY4E community. This course has definitely helped me make the programs I want and needs. From simple to more complex web scraping and data base management personal projects this course will definitely guide you through Python 3.

By Vadim Y

Feb 21, 2016

As with the previous courses in this series, this class is excellent. It builds on what what was discussed in the preceding courses and combines it all to show students how it all comes together to create practical applications. Not only that, but you will learn about how databases work as well as best practices for building databases. Charles Severance has a way of making seemingly complex concepts very simple to understand. One of my favorite instructors thus far.

By Joseph D

Jan 27, 2016

These courses, taught by the well spoken Professor Severance, is fantastic for beginners in the Python language. I feel like I've learned more from these than any book I just picked up and started reading. Charles Severance not only explains how to work with Python but the full spectrum of W's(who, what, when, why).

I'd recommend signing up for this if you are interested in Python. In fact, I've touted its usefulness to quite a few people in conversation.

By Alexander P

Mar 4, 2016

This course does an excellent job of blending a basic introduction to relational databases and SQLite with some important tools in Python. Folks comfortable with SQL can probably skip most of the lecture in weeks 2 and 3, as the content is focused on learning SQL and using the SQLite browser as opposed to using Python with these tools. This was a great way to bring together the fundamentals from the first three courses in this specialization.

By Anastasia K

Jun 30, 2020

Since I have informed my family that I started with Python and ohhhh I will be finally programming, they kept saying "yeah that's cool but you also should learn to treat databases". I was like "what are databases? why databases?"

And after this course I will definetely go further for them! SQlight is so convenient and cool!

I like Dr Chuck's style of teaching very much and always follow him. This course is worth the highest grade ever!

By Vince S

Jan 3, 2021

I had a great time learning about databases using Python. The teacher makes the course a great experience. The level of difficulty is suitable for anyone who wants to learn Python. A lot of the coding for each assignment is given to you. Some may find the course assignments too easy. However, once you have completed the courses, it is up to the individual as to what you wan to do with your new knowledge. I highly recommend the course.

By Mykhailo K

Feb 28, 2020

Great course to make students familiar with databases fundamentals, data retrieving from API and data mining concepts. Prof. Severance excellent teacher and tells about history of information technologies and about databases fundamentals in that way to interest the students.

For me it was a little bit easy class, because I'm already familiar with the databases, but the rest of the course was new for me, useful and very interesting.

By Mladen R

Dec 26, 2016

This course gives a great introduction to SQL and how it can be used inside of Python for communicating with Databases. The pace is good and the exercises are explained well, though the quizzes can be a bit more difficult. Final exercise was good, but I think it can be more challenging by giving less suggestions how to do something and by giving more independence to students. Overall, the course was awesome and I learned a lot.

By Yash B

Oct 15, 2016

This course is as awesome as the other ones in the series. I love the way things from all the courses(SQL, accessing data from web API's etc.) merges together in the end. This course complements the others and the series as a whole teaches one enough to develop some useful programs.

I wish there were more of coding exercises rather than just code completion. Overall, a great learning experience with Dr. Chuck, the Pythonista.

By Juan J C

Mar 3, 2016

The final course in the amazing Python for Everybody Specialization by UMich and Dr. Charles Severance. Really glad I took part in these series, which improved my skills in Python programming. Real hands-on approach to show the basic and essential concepts about how to interface with databases using as a tool the embedded sqlite, how to correctly define normalized tables, and how to implement important design patterns.

By Andres F A H

Oct 30, 2016

The course is amazing, the professor gives you right examples an amount of information for understanding the topics. After you finish the course you are not an expert but you have the right concepts and knowledge for developing your projects. Furthermore, the additional material (interviews) are pretty interesting. I audit the course but I did all the homework, you must do the homework to really understand the topics.