Overview
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.
Syllabus
- Object Oriented Python
- To start this class out we cover the basics of Object Oriented Python. We won't be writing our own objects, but since many of the things we use like BeautifulSoup, strings, dictionaries, database connections all use Object Oriented (OO) patterns we should at least understand some of its patterns and terminology.
- Basic Structured Query Language
- We learn the four core CRUD operations (Create, Read, Update, and Delete) to manage data stored in a database.
- Data Models and Relational SQL
- In this section we learn about how data is stored across multiple tables in a database and how rows are linked (i.e., we establish relationships) in the database.
- Many-to-Many Relationships in SQL
- In this section we explore how to model situations like students enrolling in courses where each course has many students and each student is enrolled in many courses.
- Databases and Visualization
- In this section, we put it all together, retrieve and process some data and then use the OpenStreetMaps API to visualize our data.
Taught by
Charles Severance
Tags
Reviews
4.7 rating, based on 4,788 Class Central reviews
4.8 rating at Coursera based on 21325 ratings
Showing Class Central Sort
-
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 t…
-
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 imagi…
-
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…
-
Dr. Chuck is a top-notch teacher and I see that he is an enthusiastic musician too. I hope to meet him someday to thank him in person and maybe to play something. I'm really satisfied with the course. It fulfills my purpose which is to learn a bit more about the fundamentals of Python in a lightweight manner, evaluate the differences and improvements compared with Java, and have some fun. Thanks.
-
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 accomplis…
-
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 r…
-
It's a great course to begin the journey of database
-
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…
-
"Having completed Using Databases with Python course, I can confidently say it was an excellent experience. The course was meticulously organized, making it easy to follow along and grasp even the most complex concepts. The instructors were knowledgeable and engaging, providing clear explanations and ample opportunities for hands-on practice. I particularly appreciated the structured approach to learning Python, which allowed me to build a solid foundation in programming. Overall, I highly recommend this course to anyone looking to delve into the world of Python programming."
-
a great introduction to databases and integrate python programming to access, create, modify and edit them. no dive deep into the database just explore the surface.
-
I love this and all the other courses in the specialisation. The instructor inspires a relaxed yet committed approach to the subject. It has been a pleasure doing this course.
-
Dr. Chuck is a marvel and a gift to humanity. The course is well explained and the materials are interesting.
-
"Using Databases with Python" is a well-structured course that teaches the fundamentals of working with relational databases using Python. Dr. Charles Severance once again delivers a clear and engaging learning experience, making the often complex t…
-
Good foundational base for working with SQL in Python. You aren't going to exit this course as a database administrator-designer-superwiz, but you'll get your feet wet enough to make basic programs and go deeper into SQL -- if you so desire. Like ge…
-
This unit was very simple, mainly because it was more "complete the code" rather than writing code from scratch; which would've been extremely time-consuming and mainly unproductive. That said, it would've been a nice touch to explore some of these libraries and discuss in a bit more detail how they work internally (perhaps exploring their source code a little).
-
If you want to pursue a career in Python or just casually explore the field, this course is a fantastic introduction to SQL and a crucial component of learning Python. I thoroughly enjoyed every moment of it and Dr. Chuck is an absolutely fabulous instructor. Highly recommend!
-
Even better than the other courses so far in this series! I am a big fan of Dr. Chuck after taking 4 of his courses. I am going to sign up for another after I finish this specialization (in SQL which is a major part of this course). I look forward to taking this classes and think about what I have learned throughout the day and how I can use the information to make my office better (and a better place to work!)
-
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…
-
It's a very informative course, and the dr. Chuck style of explaining all the details related to SQL is very good. I learned a lot from this course.
-
The database course with Python clarified the connection that exists between programming and how database calls can be made through libraries. Additionally, it was very important to understand database relationships, SQL statements, and how they can be incorporated.