When you enroll in this course, you'll also be enrolled in this Specialization.
Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate
There are 5 modules in this course
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.
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.
What's included
12 videos4 readings2 assignments
Show info about module content
12 videos•Total 97 minutes
Welcome to Using Databases with Python•3 minutes
Unicode Characters and Strings•17 minutes
Windows 10: Installing Python and Writing A Program•8 minutes
Windows: Taking Screen Shots•2 minutes
Macintosh: Using Python and Writing A Program•4 minutes
Macintosh: Taking Screen Shots•4 minutes
Object Oriented Definitions and Terminology•15 minutes
Notice for Auditing Learners: Assignment Submission•10 minutes
2 assignments•Total 60 minutes
Using Encoded Data in Python 3•30 minutes
Object Oriented Programming•30 minutes
Chapter Fifteen: Basic Structured Query Language
Module 2•4 hours to complete
Module details
We learn the four core CRUD operations (Create, Read, Update, and Delete) to manage data stored in a database.
What's included
6 videos1 assignment2 app items
Show info about module content
6 videos•Total 68 minutes
Relational Databases•14 minutes
Using Databases•12 minutes
Single Table CRUD•17 minutes
Worked Example: Counting Email in a Database•14 minutes
Bonus: Office Hours Zagreb, Croatia•3 minutes
Interview: Elizabeth Fong - The Early Years of SQL•8 minutes
1 assignment•Total 30 minutes
Single-Table SQL•30 minutes
2 app items•Total 120 minutes
Our First Database•60 minutes
Counting Email in a Database•60 minutes
Chapter Fifteen: Data Models and Relational SQL
Module 3•3 hours to complete
Module details
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.
What's included
8 videos1 assignment1 app item
Show info about module content
8 videos•Total 74 minutes
Designing a Data Model•14 minutes
Representing a Data Model in Tables•12 minutes
Inserting Relational Data•9 minutes
Reconstructing Data with JOIN•12 minutes
Worked Example: Tracks.py•8 minutes
Bonus: Office Hours Perth, Australia•2 minutes
Bonus Interview: Niklaus Wirth•15 minutes
Bonus: Office Hours Barcelona•2 minutes
1 assignment•Total 30 minutes
Multi-Table Relational SQL•30 minutes
1 app item•Total 60 minutes
Multi-Table Database - Tracks•60 minutes
Chapter Fifteen: Many-to-Many Relationships in SQL
Module 4•2 hours to complete
Module details
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.
What's included
4 videos1 assignment1 app item
Show info about module content
4 videos•Total 40 minutes
Many-to-Many Relationships•17 minutes
Worked Example: roster.py•11 minutes
Bonus: Office Hours Mexico, City•1 minute
Bonus Interview: Andrew Tannenbaum - Minix•11 minutes
1 assignment•Total 30 minutes
Many-to-Many Relationships and Python•30 minutes
1 app item•Total 60 minutes
Many Students in Many Courses•60 minutes
Chapter Sixteen: Databases and Visualization
Module 5•2 hours to complete
Module details
In this section, we put it all together, retrieve and process some data and then use the OpenStreetMaps API to visualize our data.
What's included
5 videos3 readings1 app item
Show info about module content
5 videos•Total 38 minutes
Geocoding•9 minutes
Worked Example: Geodata•19 minutes
Bonus: Office Hours - Amsterdam•3 minutes
Bonus Interview: Richard Stallman - Free Software Foundation•3 minutes
Bonus Interview: Brian Behlendorf - Apache Foundation•5 minutes
The mission of the University of Michigan is to serve the people of Michigan and the world through preeminence in creating, communicating, preserving and applying knowledge, art, and academic values, and in developing leaders and citizens who will challenge the present and enrich the future.
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."
Learner reviews
4.8
21,590 reviews
5 stars
82.09%
4 stars
14.16%
3 stars
2.28%
2 stars
0.47%
1 star
0.97%
Showing 3 of 21590
C
CS
5·
Reviewed on Jul 5, 2018
Well taught course, with material made easy to understand and discussed in an engaging way. The assignments really help to solidify your understanding and are like puzzles that I enjoy working at.
F
FF
5·
Reviewed on Nov 21, 2017
the way this course is design is absolutely amiziong. just good amount of most important information is provided. task are not too complecated to finish (maybe coudl be little more dificult:) love it!
J
J
5·
Reviewed on Mar 1, 2020
one of the best course you can take. you'll learn a lot and not just about python but about database too, XML, Json, and is really a fun fun course to take, and the instructor is one of the best.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.