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.
This course is part of the Python for Everybody Specialization
About this Course
What you will learn
Use the Create, Read, Update, and Delete operations to manage databases
Explain the basics of Object Oriented Python
Understand how data is stored across multiple tables in a database
Utilize the Google Maps API to visualize data
Skills you will gain
- Python Programming
- Database (DBMS)
Start working towards your Master's degree
Syllabus - What you will learn from this course
Object Oriented Python
Basic Structured Query Language
Data Models and Relational SQL
Many-to-Many Relationships in SQL
- 5 stars82.30%
- 4 stars14.28%
- 3 stars2.30%
- 2 stars0.45%
- 1 star0.65%
TOP REVIEWS FROM USING DATABASES WITH PYTHON
well designed class especially the homework. by going through all the homework, i have dramatically improved my python data extraction and database management skills. Great introduction course!
I had a little bit of knowledge about Python coding before taking these courses, but it was very insightful and helpful in my quest to learn more and helped instill the things I did already know.
The course is simple and easy.Dr.Chuck takes you through databases,how to write SQL queries,execute them and so on.My advice is to do the other three courses first and then move on to this one.
Tied together many data transfer concepts that I had heard of but did not understand. Very interesting set of topics - makes a novice understand what other languages might be interesting to learn.
About the Python for Everybody Specialization
Frequently Asked Questions
When will I have access to the lectures and assignments?
What will I get if I subscribe to this Specialization?
Is financial aid available?
More questions? Visit the Learner Help Center.