Using Databases with Python

TL;dr. Another disappointed course in the specialization. Old-fashioned teaching style, poor material, useless assignments and too much filled material. Find another course to learn the basics of Python if you can.

First things first: if you want to learn about how to use Python, how it interacts with databases and how to write code to build a database, this course is not for you as it only shows code previously written with little to non existent opportunities to practice your coding skills. It's a course about databases and SQLite with a few Python programs already built.

With that being said, the course has the same structure of the courses 1-3 and this is its first flaw. Repeated videos and content in the first week and then lectures, assignments and filler videos who want to be interesting but most of them don't add valuable knowledge.

The lectures are all provided in videos, with intensive use of slides, which I honestly consider a poor and old-fashioned approach to teaching a subject, especially one as practical as programming. It's evident at times that the instructor has repeated himself so many times that he rushes from one slide to another without properly explaining important concepts.

About the concepts, like courses 2 and specially 3, this one repeats the "don't worry about it, just type this code we provide you and if it works, it will be fine, you don't need to understand" approach. Again, I believe this is not the best approach to teach programming languages, especially if you're a beginner.

The assignments difficulty range from medium-easy to joke. The first few weeks they can be resumed in something like "take the same code we've explained in a previous video, modify or add two lines and then submit it". I don't see how I could improve my programming skills by doing this.
Special mention to the fifth week assignment. When I see the word "visualization" in the title I thought about grab some public data from the internet, put in into a database and then use Python to make some charts, diagrams or whatever. It would have been great...instead we're provided with two different programs, a JavaScript file ¿? and an HTML and told that we add a new line into a file, run the programs without any modification and provide a screenshot to complete the assignment. Again, I don't know how doing this would increase my programming skills and also, although I'm only a beginner, I think Python is capable of doing much more in data visualization.

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.

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 many videos about historical bits are entertaining but do not really add any value to the course, since they do not talk about the technology but just about what the creator was thinking when they came up with the idea.

As an example, the video about REST API, which nowadays is quite used, did not even explain what REST API is.

The concepts in the course are not disclosed in a well structured way because the student is not being provided many of the necessary details to understand the why, other than the how things are done. Although this makes sense in an course that is just meant to introduce the student to a subject, students are not taught how to find further information about missing details by themselves until course 4, which is simply too late, and it is also explained in a sloppy way.

During the whole course, I have seen the instructor typing actual code probably 3 or 4 times.

The instructor is there to show you that some code was written to do a certain job but he will not show you how he (?) put the code together and the reasoning behind his workflow.

This approach, which also makes heavy use of powerpoint slides, is a very old way of teaching concepts that has been proved wrong a long time ago and does not help students retaining information, for the simple reason that they are not engaged in the making of the code but are just asked to get to a specific solution by using the 90% completed code.

Quite often I found myself going on the python website, stackexchange or youtube to look for more detailed explanations about concepts that in this course are provided "as is" and have to be accepted per faith. Do not expect to learn how to use functions, classes or how to read the documentation just by learning from this course.

Another serious flaw is that the instructor does not bother to introduce the debugger/visualizer (which are extremely useful) nor how to effectively work with files.

Most of the exercises are on the Extremely easy side, with difficulty spikes caused by the foggy explanations during course 2 and 3. Course 4 is mostly a waste of time because you are basically using code already written for you and you just need to provide a database file that satisfies the search criteria.

Course 4 is totally obsolete now.

I have only finished this course because I paid for it but this course does not really teach you how to use python to work with databases, rather how to repeat a limited amount of actions to get specific results.

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!

It is sufficient to say that the University of Michigan itself does not find the level of this course good enough. I have applied for the applied data science masters at the University of Michigan (got admitted), in the application process, you have to pass a python assignment unless you have taken their python course on Coursera. I wanted to apply with the (python for everybody specialization) but found out they only accept students who have taken (python 3 specialization) , turns out that Michigan has two introductory python courses in Coursera and they are both dedicated for beginners. They say that the level (python for everybody specialization) is not high enough for a beginner student applying for their own masters. I would understand if the python 3 specialization was somewhat advanced, but no it's an introductory level course dedicated to beginners in python.

The assignments are really a joke, what's up with copying a whole code and add two lines and then submitting it, I don't understand how is this achieving anything. Assignment 5 in this particular course is a shame really a shame, they ask you to add a line of plain text to a notepad file and then run an already written code without any modification, can anybody enlighten me on how is this learning to program? I assumed that the last assignment in the course should be a little challenging, building some code from the scratch maybe, but no it's just taking screenshots of the output for some code that somebody else has written, this is really a shame.

Yeah, I have learned a lot in this specialization is totally true that I learned a lot, but it's not the best you can get it is not even the best introductory specialization you can get from the University of Michigan.

This was my first online coding course of any kind. I graduated in the early 90s with a Mechanical Engineering degree, and as part of that curriculum had to take several programming classes. I remember turning to a friend and asking "Can you imagine how fun it would be if you could do this for a living?" Unfortunately I waited ~30 years to actually pursue coding as a profession, and figured Python (widely used in three *huge* opportunities in terms of demand, compensation, and even world impact): Machine Learning/Artificial Intelligence, Data Science, and Cyber Security. Sorry for my overly wordy history, but I think context is important when writing a review, as it may help the reader understand this person's state of mind and level of proficiency relative to the subject being reviewed. With the above in mind, and also keeping in mind I've done pretty much exactly zero coding since college some ~30 years ago here's what I think might be most useful for anyone that has suffered through my bloated introduction.

Overall the first thing that impressed me - similar to earlier modules - was how thoroughly the lectures cover the most relevant content that the student should focus on. I'm enrolled in a five part series/modules of courses under the Google Coursera "Learning to Code with Python" and just as in the previous modules once again the instructor/module was concise, informative, and I learned a LOT more than I was expecting to!

I will warn that for me - having never been exposed to SQL or SQLite (something I wish had happened much sooner after seeing/learning about it) - I was able to successfully complete the class, I do not feel in any way competent in using/applying that knowledge in a meaningful way. Without the program files as resources to tinker with, and copy and past into, I wouldn't be able to code from scratch what is taught in the class.

However, I don't think that's the intent so much. With respect to the use of Databases with Python, I possess a much better understanding at the foundational level of what's important, what's possible, how various elements from different programming languages as well as tools like the SQLite Browser can be used together inside the same Python program, etc.

Even better, (although I'll likely enroll in official certification path that will layout exactly what I need to learn and when), I know exactly what I need to study and understand next in order to start putting these skills to work at my current job - which has nothing to do with programming.... my job involves and I see everyone around me doing the same thing estimating, and moving information from one document to another, over and over and over and often times it is the exact same information! And - while I had hoped completing this program would enable me to build tools that will enable me to be more efficient at my current job, now I see that I can and will build tools that aren't only useful to me, but to the entire team of project managers/estimators/purchasing! Sure I'll have to practice a lot more with json and SQLite (maybe even SQL), but I understand the foundational structure, how to get started, where to focus my studies, etc.

I guess that's the long way of saying "Wow!" I had no idea I'd get so much out of this class, while recognizing that a basic understanding != (sorry, had to sneak SOME python into my review) "Proficiency." Still, this seems to me to be something similar to playing the piano or a musical instrument, only with a learning curve that isn't nearly as steep. In other words - I know what I know, I know what I need more practice/experience with in terms of different programming languages, I know enough about DB Architecture, or at least 90-95% of what I need to know in order to build a robust application that can support distributed users, and knowing this allows me to begin setting up my initial databases, learning how to automate inputs into them, and I could go on and on!

Even though I might sound like I'm nitpicking my 5-star review - I wouldn't have minded some additional practice with json and SQLite in particular - but even that's not exactly fair to say because I can see now why there are entire courses dedicated solely to those tools.

I am in the process of completing the Python 5 course Specialization and I absolutely love these courses. Dr. Chuck and his team have put a tremendous amount of thought and technical planning into making this course something that you can accomplish remotely. I really appreciate how you can go back and re-watch the lectures, which is even better than a live one off in person lecture. I am older and have coded in other languages - R, SPlus, MatLab, C++ but am a firm believer of starting from scratch so going through the whole sequence. I have picked up so much knowledge at a reasonable price and in a manageable amount of time. I think Univ Michigan has undertaken a very heroic/noble quest to help vastly expand the knowledge people everywhere to keep pace with the technological demands of the 21st century.

Please be advised, similar to all programming languages and courses it takes a substantial amount of focus and effort to complete the programming assignments and pass the quizzes. To help you with this process there are vast online resources available that explain the precise details of every aspect of Python. During and after the lectures I spend a lot of time experimenting with code and researching methods, functions, etc. to help me figure out the assignments. Dr. Chuck has a huge repository of example code that is available for you to use and experiment with, adapt and research to help you along the way. One must devote a substantial amount of focus and time to achieve any academic goal. I have found myself up at 1AM experimenting with code snippets and it made me feel like an undergrad again...

One additional aspect of the course are all the interviews with important people across the IT world that have played pivotal roles in the development of computers and programming. For me, that has added a rich layer of contextual knowledge that has great expanded the scale and scope of my understanding of computer science and engineering has evolved since the beginning. You wouldn't get this in a live lecture...

All of this makes me wish I was 18 again and could go back and attend Univ Michigan in Data Science and CS.

I totally am satisfied with this course. IT is always the question of point of view. I can understand if you are a person who has knowledge about the databases or SQL , the course 5 may be disappointing. But from my point of view as a person who developed Oracle Databases with Oracle Forms i see the instruction about the databases with SQLite, exactly the best way to teach people who have no idea about Data structure in the relational databases.
Me and my other colleagues took this courses together and i could observe that they had difficulties to understand the concept of relational database. But after the course they were able to understand it and do the assignment.
We may not forget that this course is the beginner course as its name says Python for Everybody, not only for me.

I took the specialization Python for Everybody. The 1st and 2nd courses are great, very friendly for beginners, and encourage you to write up a bit of code by yourselves. That's really a helpful practice.

When I came to the course 3 & 4, I began to feel disappointed. The whole specialization is about python, not a web crawler or database SQL - these specific things should be for people who interested in them. Instead, as I suppose the content comes after course 2 should be more practices on FUNCTIONS and CLASS, even on algorithms. Algorithms on time/space complexity, on how to write up neat and high efficiency codes, should be extremely important for every programmers. What's more, the assignments in course 3 & 4 should be more focused on making the students write up the code by hands, instead of letting them just do a bit of changes on the provided code then click on "run".

I would like to give 5-star on course 1 & 2, but only 3-star for course 3 & 4.

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.

The instructor (Charles Severance) does not cover the basic, simple, essential things necessary to write Python code. He only breaks things down with a step wise explanation in one video in all of the first 4 classes and this video is using a Mac computer, so he never breaks things down for Windows users. He never mentions basic things like how to right click from your folder to set up the command prompt, or any of the essentials things you need to know to successfully write Python code, so you end up teaching yourself everything.

Many of the code assignments are set up to make you fail. Instead being straight forward and doing videos about how to write the code for the assignment, he will make the assignments different than the video, so you end up teaching yourself.

Buy the instructor's text book, because he won't teach you and you will need it to figure things out. By far the worst Coursera teacher and classes I have had. In Course 4 Module 5 Assignment 3, the instructor has you upload 3 screen captures, including a screenshot of the Geo Map with date stamp, time stamp and the map image with a closeup of the location name. When you do the screen capture of this map, you will not be able to upload it, because it will be greater than 1.1 MB. When I trimmed my map screenshot and uploaded it, my screen shot got flagged because it was now too small, which means you can't finish the module, course or specialist certification. I spent many hours trying to get this fixed and it still is not fixed. If you want to spend 10 times more time than any other Coursera class and have an instructor focused on making everything as difficult as possible, then this is the perfect class for you.

Dr. Charles Severance should communicate more simply, directly, precisely and parsimoniously. Instead he talks in circles and leaves out the essential distinctions you will need to complete the assignments and actually learn how to write Python code.

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.