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
Could your company benefit from training employees on in-demand skills?
Try Coursera for BusinessWhat 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)
- Sqlite
- SQL
Could your company benefit from training employees on in-demand skills?
Try Coursera for BusinessOffered by
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
Reviews
- 5 stars82.30%
- 4 stars14.28%
- 3 stars2.30%
- 2 stars0.45%
- 1 star0.64%
HIGHLIGHTS
TOP REVIEWS FROM USING DATABASES WITH PYTHON
This course was great! I enjoyed parsing different types of data: from documents and the web. This course is definitely (rudimentary) a must take course for anyone who wants to go into data science.
I hope this can be a little bit more challenge. All the assignments are easy to be finished, some of them can be done within minutes. Comparing with JHU's R programming, that can be too hard, though.
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.
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.
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.