Using Databases with Python

Using Databases with Python

This course is part of Python for Everybody Specialization

Instructor: Charles Russell Severance

What you'll 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'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

5 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Build your subject-matter expertise

This course is part of the Python for Everybody Specialization

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

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

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

12 videosTotal 96 minutes

Welcome to Using Databases with Python2 minutesPreview module
Unicode Characters and Strings17 minutes
Windows 10: Installing Python and Writing A Program8 minutes
Windows: Taking Screen Shots2 minutes
Macintosh: Using Python and Writing A Program4 minutes
Macintosh: Taking Screen Shots4 minutes
14.1 - Object Oriented Definitions and Terminology15 minutes
14.2 - Our First Class and Object10 minutes
14.3 - Object Life Cycle9 minutes
14.4 - Object Inheritance9 minutes
Bonus: Interview - Software Engineering - Bertrand Meyer11 minutes
Bonus: Office Hours - London1 minute

4 readingsTotal 40 minutes

Help us learn more about you!10 minutes
Python Textbook10 minutes
Course Syllabus10 minutes
Notice for Auditing Learners: Assignment Submission10 minutes

2 assignmentsTotal 60 minutes

Using Encoded Data in Python 330 minutes
Object Oriented Programming30 minutes

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

6 videosTotal 67 minutes

15.1 Relational Databases13 minutesPreview module
15.2 - Using Databases12 minutes
15.3 - Single Table CRUD16 minutes
Worked Example: Counting Email in a Database13 minutes
Bonus: Office Hours Zagreb, Croatia3 minutes
Interview: Elizabeth Fong - The Early Years of SQL7 minutes

1 assignmentTotal 30 minutes

Single-Table SQL30 minutes

2 app itemsTotal 120 minutes

Our First Database60 minutes
Counting Email in a Database60 minutes

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

8 videosTotal 74 minutes

15.4 - Designing a Data Model13 minutesPreview module
15.5 - Representing a Data Model in Tables11 minutes
15.6 - Inserting Relational Data9 minutes
15.7 - Reconstructing Data with JOIN12 minutes
Worked Example: Tracks.py (Chapter 15)7 minutes
Bonus: Office Hours Perth, Australia1 minute
Bonus Interview: Niklaus Wirth15 minutes
Bonus: Office Hours Barcelona2 minutes

1 assignmentTotal 30 minutes

Multi-Table Relational SQL30 minutes

1 app itemTotal 60 minutes

Multi-Table Database - Tracks60 minutes

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

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

5 videosTotal 38 minutes

16.1 - Geocoding9 minutesPreview module
Worked Example: Geodata (Chapter 16)18 minutes
Bonus: Office Hours - Amsterdam3 minutes
Bonus Interview: Richard Stallman - Free Software Foundation2 minutes
Bonus Interview: Brian Behlendorf - Apache Foundation4 minutes

3 readingsTotal 30 minutes

Peer Graded Assignment - Instructor Input10 minutes
Please Rate this Course on Class-Central10 minutes
Post-Course Survey10 minutes

1 app itemTotal 60 minutes

Databases and Visualization (peer-graded)60 minutes

Instructor

Instructor ratings

4.8 (1,249 ratings)

Charles Russell Severance

University of Michigan

60 Courses4,400,571 learners

Offered by

University of Michigan

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"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,329 reviews

5 stars
82.23%
4 stars
14.21%
3 stars
2.28%
2 stars
0.46%
1 star
0.79%

Showing 3 of 21329

Reviewed on Jun 22, 2017

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.

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.

Reviewed on Jan 31, 2020

Course is worthwhile taking and Dr. Severance is engaging in the videos. People new to Python should read book chapters prior to viewing videos so as to familiarize themselves with the subject matter.

View more reviews