Using Databases with Python

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.

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.

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 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.

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.

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 course is the 4th in a sequence of 5, that is intended to be an introduction to programming, using Python, for people with no programming experience. I found this course (along with the previous 3 courses) to be very informative for my particular needs. I am an engineer, who learned programming many years ago with BASIC, FORTRAN, PASCAL, and C, and currently do most of my programming in Matlab. I had never used Python, but was curious about it and wanted a low stress introduction and this sequence has been exactly what I was hoping for and more. I am not likely to use anything in this course in my normal job duties, but I feel like I could bring myself up to speed fairly quickly, if needed, having taken this course. This course also introduces the student to XML and JSON data storage formats, and the creation and use of SQL databases and database browsers, which was a pleasant surprise, as I had no knowledge of these subjects before I decided to take this sequence to see what Python was all about. Most of the assignments are pretty easy, and Dr. Chuck usually gives you a sample file to start with, so that you don't have to start writing every single assignment from scratch. This helps to keep the focus on the concepts presented, and not getting lost in the weeds of syntax and memorization. Furthermore, many of the concepts and explanations are repeated in the following assignments, so that you start to recognize the commonly used little snippets of code, and their purpose, and the syntax, and the need for memorization is mostly avoided. That being said, I don't recommend letting too much time pass between each lesson, as there is a significant amount of new information thrown at the audience. For a beginner, I think this course is probably the most difficult, because it uses much of the information taught in the previous 3 courses. It might help to have another browser tab open to the previous lectures, or maybe one open to a website for python functions, for quick reference, when working some of the assignments. This course may feel more like drinking from a firehose, but if you keep in mind that Dr. Chuck is mostly focused on a few important concepts, it is really not. He does not stray from those few concepts, in the quizzes, nor in the assignments. As far as I can remember, if he did not cover something, you do not need it to complete any of the assignments.

The Python Database Course exceeded my expectations and provided an exceptional learning experience. The course comprehensively covered database concepts and their implementation using Python, making it suitable for both beginners and those with prior programming knowledge.

Throughout the course, the instructor's clear and concise explanations helped demystify complex topics. From fundamental concepts like relational databases, SQL querying, to more advanced topics like data modeling and database normalization, every module was well-structured and easy to follow.

Hands-on exercises and projects were a highlight, as they enabled practical application of the theory. I appreciated the real-world scenarios, which gave me the confidence to tackle database-related challenges in my own projects. The integration of Python libraries like SQLAlchemy and SQLite further enhanced the learning experience, providing insight into industry-relevant tools.

The course's pacing was well-balanced, allowing ample time to grasp each concept before moving forward. Additionally, the interactive quizzes and peer discussions fostered engagement and ensured a deeper understanding of the material.

In conclusion, the Python Database Course is an invaluable resource for anyone seeking a solid foundation in working with databases using Python. The course's quality content, engaging delivery, and practical approach make it a must-join for those aiming to expand their programming and database skills.

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!