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.