Databases and SQL for Data Science with Python

Databases and SQL for Data Science with Python

This course is part of multiple programs.

Instructors: Rav Ahuja

What you'll learn

Analyze data within a database using SQL and Python.
Create a relational database and work with multiple tables using DDL commands.
Construct basic to intermediate level SQL queries using DML commands.
Compose more powerful queries with advanced SQL techniques like views, transactions, stored procedures, and joins.

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

17 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 available as part of

When you enroll in this course, you'll also be asked to select a specific program.

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 6 modules in this course

Working knowledge of SQL (or Structured Query Language) is a must for data professionals like Data Scientists, Data Analysts and Data Engineers. Much of the world's data resides in databases. SQL is a powerful language used for communicating with and extracting data from databases.

In this course you will learn SQL inside out- from the very basics of Select statements to advanced concepts like JOINs. You will: -write foundational SQL statements like: SELECT, INSERT, UPDATE, and DELETE -filter result sets, use WHERE, COUNT, DISTINCT, and LIMIT clauses -differentiate between DML & DDL -CREATE, ALTER, DROP and load tables -use string patterns and ranges; ORDER and GROUP result sets, and built-in database functions -build sub-queries and query data from multiple tables -access databases as a data scientist using Jupyter notebooks with SQL and Python -work with advanced concepts like Stored Procedures, Views, ACID Transactions, Inner & Outer JOINs through hands-on labs and projects You will practice building SQL queries, work with real databases on the Cloud, and use real data science tools. In the final project you’ll analyze multiple real-world datasets to demonstrate your skills.

In this module, you will be introduced to databases. You will learn how to use basic SQL statements like SELECT, INSERT, UPDATE and DELETE. You will also get an understanding of how to refine your query results with the WHERE clause as well as using COUNT, LIMIT and DISTINCT.

What's included

6 videos2 readings2 assignments3 app items3 plugins

6 videosTotal 19 minutes

Course Introduction3 minutesPreview module
Introduction to Databases3 minutes
SELECT Statement3 minutes
COUNT, DISTINCT, LIMIT2 minutes
INSERT Statement2 minutes
UPDATE and DELETE Statements3 minutes

2 readingsTotal 8 minutes

Course Overview3 minutes
Summary: Basic SQL5 minutes

2 assignmentsTotal 20 minutes

Practice Quiz: Basic SQL10 minutes
Graded Quiz: Basic SQL10 minutes

3 app itemsTotal 70 minutes

Hands-on Lab: Simple SELECT Statements20 minutes
Hands-on Lab: COUNT, DISTINCT, LIMIT30 minutes
Hands-on Lab: INSERT, UPDATE, and DELETE20 minutes

3 pluginsTotal 23 minutes

Helpful Tips for Course Completion3 minutes
SELECT statement examples5 minutes
SQL Cheat Sheet: Basics - SELECT, INSERT, UPDATE, DELETE, COUNT, DISTINCT, LIMIT15 minutes

In this module, you’ll learn more about relational database concepts and their importance. This module helps you to understand the process of creating a table in your database on MySQL using the graphical interface and SQL scripts. Further, you will also learn how to alter the entries or delete the entries for any table in the database, or even delete the table itself.

What's included

5 videos2 readings2 assignments3 app items4 plugins

5 videosTotal 21 minutes

Relational Database Concepts5 minutesPreview module
Types of SQL statements (DDL vs. DML)2 minutes
CREATE TABLE Statement3 minutes
ALTER, DROP, and Truncate Tables4 minutes
How to create a Database instance on Cloud5 minutes

2 readingsTotal 3 minutes

Summary: Relational Database Concepts and Tables2 minutes
[Optional] Hands-on Lab Using IBM Db21 minute

2 assignmentsTotal 25 minutes

Practice Quiz: Introduction to Relational Databases and Tables10 minutes
Relational DB Concepts and Tables15 minutes

3 app itemsTotal 70 minutes

Hands-on Lab : CREATE, ALTER, TRUNCATE, DROP20 minutes
Hands-on Lab: Create and Load Tables using SQL Scripts20 minutes
Obtain IBM Cloud Feature Code and Activate Trial Account30 minutes

4 pluginsTotal 22 minutes

Examples to ALTER and TRUNCATE tables using MySQL5 minutes
Examples to CREATE and DROP tables5 minutes
SQL Scripts - Uses and Applications7 minutes
SQL Cheat Sheet: CREATE TABLE, ALTER, DROP, TRUNCATE5 minutes

This module helps you learn how to use string patterns and ranges to search data and how to sort and group data in result sets. You will also practice composing nested queries and execute select statements to access data from multiple tables.

What's included

7 videos4 readings4 assignments4 app items2 plugins

7 videosTotal 31 minutes

Using String Patterns and Ranges4 minutesPreview module
Sorting Result Sets2 minutes
Grouping Result Sets3 minutes
Built-in Database Functions6 minutes
Date and Time Built-in Functions3 minutes
Sub-Queries and Nested Selects4 minutes
Working with Multiple Tables6 minutes

4 readingsTotal 12 minutes

[Optional] Hands-on Labs Using IBM Db21 minute
Summary: Refining Your Results5 minutes
[Optional] Hands-on Labs Using IBM Db21 minute
Summary: Functions, Multiple Tables, and Sub-queries5 minutes

4 assignmentsTotal 50 minutes

Practice Quiz: Refining Your Results10 minutes
Practice Quiz: Functions, Multiple Tables, and Sub-queries10 minutes
Graded Quiz: Refining Your Results15 minutes
Graded Quiz: Functions, Multiple Tables, and Sub-queries15 minutes

4 app itemsTotal 90 minutes

Hands-on Lab: String Patterns, Sorting and Grouping30 minutes
Hands-on Lab: Built-in functions20 minutes
Hands-on Lab: Sub-queries and Nested Selects20 minutes
Hands-on Lab: Working with Multiple Tables20 minutes

2 pluginsTotal 20 minutes

SQL Cheat Sheet: Intermediate - LIKE, ORDER BY, GROUP BY5 minutes
SQL Cheat Sheet: FUNCTIONS and Implicit JOIN15 minutes

In this module you will learn the basic concepts of using Python to connect to databases. In a Jupyter Notebook, you will create tables, load data, query data using SQL magic and SQLite python library. You will also learn how to analyze data using Python.

What's included

6 videos2 readings2 assignments7 app items1 plugin

6 videosTotal 33 minutes

How to Access Databases Using Python6 minutesPreview module
Writing code using DB-API5 minutes
Accessing Databases with SQL Magic6 minutes
Analyzing data with Python9 minutes
Connecting to a database using ibm_db API2 minutes
Creating tables, loading data and querying data3 minutes

2 readingsTotal 3 minutes

Summary: Accessing databases using Python2 minutes
[Optional] Hands-on Labs Using IBM Db21 minute

2 assignmentsTotal 25 minutes

Practice Quiz: Accessing Databases using Python10 minutes
Graded Quiz: Accessing databases using Python15 minutes

7 app itemsTotal 200 minutes

Hands-on Lab: Creating tables, inserting and querying Data20 minutes
Hands-on Tutorial: Accessing Databases with SQL magic20 minutes
Hands-on Lab: Analyzing a Real-World Data Set45 minutes
(Optional) Db2 Lab: Connecting to a database instance20 minutes
(Optional) Db2 Lab: Creating tables, inserting and querying Data30 minutes
(Optional) Db2 Lab: Tutorial, Accessing Databases with SQL magic20 minutes
(Optional) Db2 Lab: Analyzing a real World Data Set45 minutes

1 pluginTotal 15 minutes

SQL Cheat Sheet: Accessing Databases using Python15 minutes

In this module, you will be working with multiple real-world datasets for the city of Chicago. You will be asked questions that will help you understand the data just as you would in the real world. You will be assessed on the correctness of your SQL queries and results.

What's included

2 videos3 readings2 assignments3 app items

2 videosTotal 8 minutes

Working with Real World Datasets5 minutesPreview module
Getting Table and Column Details2 minutes

3 readingsTotal 4 minutes

Summary and Highlights1 minute
[Optional] Hands-on Labs Using IBM Db21 minute
Congratulations & Next Steps2 minutes

2 assignmentsTotal 60 minutes

Graded Quiz on Assignment30 minutes
Final Exam30 minutes

3 app itemsTotal 105 minutes

Hands-on Lab: Working with a real world data-set30 minutes
(Optional)Hands-on Lab: Practice Querying Real World Datasets45 minutes
Final Assignment: Database Querying using SQLite30 minutes

This module covers some advanced SQL techniques that will be useful for Data Engineers. In this module, you will learn how to build more powerful queries with advanced SQL techniques like views, transactions, stored procedures, and joins. If you are following the Data Engineering track, you must complete this module. Completion of this module is not required for those completing the Data Science or Data Analyst tracks.