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

Access provided by REBOOT

631,949 already enrolled

6 modules

Gain insight into a topic and learn the fundamentals.

22,569 reviews

Beginner level

Recommended experience

Flexible schedule

2 weeks at 10 hours a week

Learn at your own pace

94%

Most learners liked this course

6 modules

Gain insight into a topic and learn the fundamentals.

22,569 reviews

Beginner level

Recommended experience

Flexible schedule

2 weeks at 10 hours a week

Learn at your own pace

94%

Most learners liked this course

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.

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

14 assignments¹

AI Graded see disclaimer

Taught in English

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

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

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

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 videos Total 19 minutes

Course Introduction 3 minutes
Introduction to Databases 4 minutes
SELECT Statement 4 minutes
COUNT, DISTINCT, LIMIT 2 minutes
INSERT Statement 3 minutes
UPDATE and DELETE Statements 3 minutes

2 readings Total 8 minutes

Course Overview 3 minutes
Summary: Basic SQL 5 minutes

2 assignments Total 20 minutes

Graded Quiz: Basic SQL 10 minutes
Practice Quiz: Basic SQL 10 minutes

3 app items Total 70 minutes

Hands-on Lab: Simple SELECT Statements 20 minutes
Hands-on Lab: COUNT, DISTINCT, LIMIT 30 minutes
Hands-on Lab: INSERT, UPDATE, and DELETE 20 minutes

3 plugins Total 23 minutes

Helpful Tips for Course Completion 3 minutes
SELECT statement examples 5 minutes
SQL Cheat Sheet: Basics - SELECT, INSERT, UPDATE, DELETE, COUNT, DISTINCT, LIMIT 15 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 items5 plugins

5 videos Total 22 minutes

Relational Database Concepts 6 minutes
Types of SQL statements (DDL vs. DML) 2 minutes
CREATE TABLE Statement 4 minutes
ALTER, DROP, and Truncate Tables 4 minutes
How to create a Database instance on Cloud 6 minutes

2 readings Total 3 minutes

Summary: Relational Database Concepts and Tables 2 minutes
[Optional] Hands-on Lab Using IBM Db2 1 minute

2 assignments Total 25 minutes

Relational DB Concepts and Tables 15 minutes
Practice Quiz: Introduction to Relational Databases and Tables 10 minutes

3 app items Total 70 minutes

Hands-on Lab : CREATE, ALTER, TRUNCATE, DROP 20 minutes
Hands-on Lab: Create and Load Tables using SQL Scripts 20 minutes
Obtain IBM Cloud Feature Code and Activate Trial Account 30 minutes

5 plugins Total 37 minutes

Examples to ALTER and TRUNCATE tables using MySQL 5 minutes
Examples to CREATE and DROP tables 5 minutes
Reading: Understanding Relational Model Constraints 15 minutes
SQL Scripts - Uses and Applications 7 minutes
SQL Cheat Sheet: CREATE TABLE, ALTER, DROP, TRUNCATE 5 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 videos Total 31 minutes

Using String Patterns and Ranges 4 minutes
Sorting Result Sets 3 minutes
Grouping Result Sets 4 minutes
Built-in Database Functions 6 minutes
Date and Time Built-in Functions 3 minutes
Sub-Queries and Nested Selects 5 minutes
Working with Multiple Tables 6 minutes

4 readings Total 12 minutes

[Optional] Hands-on Labs Using IBM Db2 1 minute
Summary: Refining Your Results 5 minutes
[Optional] Hands-on Labs Using IBM Db2 1 minute
Summary: Functions, Multiple Tables, and Sub-queries 5 minutes

4 assignments Total 50 minutes

Graded Quiz: Refining Your Results 15 minutes
Graded Quiz: Functions, Multiple Tables, and Sub-queries 15 minutes
Practice Quiz: Refining Your Results 10 minutes
Practice Quiz: Functions, Multiple Tables, and Sub-queries 10 minutes

4 app items Total 90 minutes

Hands-on Lab: String Patterns, Sorting and Grouping 30 minutes
Hands-on Lab: Built-in functions 20 minutes
Hands-on Lab: Sub-queries and Nested Selects 20 minutes
Hands-on Lab: Working with Multiple Tables 20 minutes

2 plugins Total 20 minutes

SQL Cheat Sheet: Intermediate - LIKE, ORDER BY, GROUP BY 5 minutes
SQL Cheat Sheet: FUNCTIONS and Implicit JOIN 15 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 videos Total 33 minutes

How to Access Databases Using Python 6 minutes
Writing code using DB-API 6 minutes
Accessing Databases with SQL Magic 6 minutes
Analyzing data with Python 10 minutes
Connecting to a database using ibm_db API 2 minutes
Creating tables, loading data and querying data 4 minutes

2 readings Total 3 minutes

Summary: Accessing databases using Python 2 minutes
[Optional] Hands-on Labs Using IBM Db2 1 minute

2 assignments Total 25 minutes

Graded Quiz: Accessing databases using Python 15 minutes
Practice Quiz: Accessing Databases using Python 10 minutes

7 app items Total 200 minutes

Hands-on Lab: Creating tables, inserting and querying Data 20 minutes
Hands-on Tutorial: Accessing Databases with SQL magic 20 minutes
Hands-on Lab: Analyzing a Real-World Data Set 45 minutes
(Optional) Db2 Lab: Connecting to a database instance 20 minutes
(Optional) Db2 Lab: Creating tables, inserting and querying Data 30 minutes
(Optional) Db2 Lab: Tutorial, Accessing Databases with SQL magic 20 minutes
(Optional) Db2 Lab: Analyzing a real World Data Set 45 minutes

1 plugin Total 15 minutes

SQL Cheat Sheet: Accessing Databases using Python 15 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 videos4 readings2 assignments3 app items

2 videos Total 8 minutes

Working with Real World Datasets 6 minutes
Getting Table and Column Details 2 minutes

4 readings Total 5 minutes

Summary and Highlights 1 minute
[Optional] Hands-on Labs Using IBM Db2 1 minute
Congratulations & Next Steps 2 minutes
Thanks from the Course Team 1 minute

2 assignments Total 60 minutes

Graded Quiz on Assignment 30 minutes
Final Exam 30 minutes

3 app items Total 105 minutes

Hands-on Lab: Working with a real world data-set 30 minutes
(Optional)Hands-on Lab: Practice Querying Real World Datasets 45 minutes
Final Assignment: Database Querying using SQLite 30 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.

What's included

6 videos4 readings2 assignments4 app items2 plugins

6 videos Total 24 minutes

Views 4 minutes
Stored Procedures 4 minutes
ACID Transactions 4 minutes
Join Overview 4 minutes
Inner Join 3 minutes
Outer Joins 6 minutes

4 readings Total 14 minutes

About this Bonus Module 2 minutes
[Optional] Hands-on Labs Using IBM Db2 2 minutes
Summary: Views, Stored Procedures, and Transactions 5 minutes
Summary: JOIN Statements 5 minutes

2 assignments Total 20 minutes

Practice Quiz: Views, Stored Procedures, and Transactions 10 minutes
Practice Quiz: Join Statements 10 minutes

4 app items Total 80 minutes

Hands-on Lab: Using Views 20 minutes
Hands-on Lab: Stored Procedures 20 minutes
Hands-on Lab: Committing and Rolling Back a Transaction 20 minutes
Hands-on Lab: Joins 20 minutes

2 plugins Total 30 minutes

SQL Cheat Sheet: Views, Stored Procedures and Transactions 15 minutes
SQL Cheat Sheet: JOIN Statements 15 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructors

Instructor ratings

(3,862 ratings)

Rav Ahuja

IBM

55 Courses 4,820,323 learners

Hima Vasudevan

IBM

4 Courses 664,886 learners

Offered by

IBM

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

5 stars
75.34%
4 stars
18.32%
3 stars
3.83%
2 stars
1.10%
1 star
1.38%

Showing 3 of 22569

Reviewed on Oct 6, 2023

This course was an Excellent, Interesting, and knowledgeful game for me. I have been excited to lean SQL and Databases and finally IBM and Coursera let my dream come true. Thanks both of them!

Reviewed on Feb 11, 2025

Very intriguing first exposure to SQL for CS students! Loved the integration with Python. It was a bit hard to actually learn SQL from this exclusively, so using outside resources will be helpful.

Reviewed on Feb 26, 2020

A very useful course with some very interesting datasets/Jupyter notebooks to work through/practice your skills. Offers a good balanced blend between theory and practical/practice. Very good course!

View more reviews