Databases and SQL for Data Science with Python

Ends tomorrow! Save 40% on your access to 10,000+ programs and make a real impact in your career. Save now.

Databases and SQL for Data Science with Python

This course is part of multiple programs.

Instructors: Rav Ahuja

659,439 already enrolled

Included with Learn more

Ask Coursera

6 modules

Gain insight into a topic and learn the fundamentals.

Beginner level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

6 modules

Gain insight into a topic and learn the fundamentals.

Beginner level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

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 videos4 readings2 assignments3 app items

6 videosTotal 19 minutes

Course Introduction3 minutes
Introduction to Databases4 minutes
SELECT Statement4 minutes
COUNT, DISTINCT, LIMIT2 minutes
INSERT Statement3 minutes
UPDATE and DELETE Statements3 minutes

4 readingsTotal 23 minutes

Course Overview3 minutes
SELECT statement examples10 minutes
Module Summary: Getting Started with SQL5 minutes
SQL Cheat Sheet: Basics - SELECT, INSERT, UPDATE, DELETE, COUNT, DISTINCT, LIMIT5 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

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 videos7 readings2 assignments3 app items

5 videosTotal 22 minutes

Relational Database Concepts6 minutes
Types of SQL statements (DDL vs. DML)2 minutes
CREATE TABLE Statement4 minutes
ALTER, DROP, and Truncate Tables4 minutes
How to create a Database instance on Cloud6 minutes

7 readingsTotal 45 minutes

Examples to ALTER and TRUNCATE tables using MySQL10 minutes
Examples to CREATE and DROP tables10 minutes
Understanding Relational Model Constraints10 minutes
SQL Scripts - Uses and Applications7 minutes
Summary: Relational Database Concepts and Tables2 minutes
SQL Cheat Sheet: CREATE TABLE, ALTER, DROP, TRUNCATE5 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

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 videos6 readings4 assignments4 app items

7 videosTotal 31 minutes

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

6 readingsTotal 22 minutes

[Optional] Hands-on Labs Using IBM Db21 minute
Summary: Refining Your Results5 minutes
SQL Cheat Sheet: Intermediate - LIKE, ORDER BY, GROUP BY5 minutes
[Optional] Hands-on Labs Using IBM Db21 minute
Summary: Functions, Multiple Tables, and Sub-queries5 minutes
SQL Cheat Sheet: FUNCTIONS and Implicit JOIN5 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

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 videos3 readings2 assignments7 app items

6 videosTotal 33 minutes

How to Access Databases Using Python6 minutes
Writing code using DB-API6 minutes
Accessing Databases with SQL Magic6 minutes
Analyzing data with Python10 minutes
Connecting to a database using ibm_db API2 minutes
Creating tables, loading data and querying data4 minutes

3 readingsTotal 13 minutes

Summary: Accessing databases using Python2 minutes
SQL Cheat Sheet: Accessing Databases using Python10 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

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 videosTotal 8 minutes

Working with Real World Datasets6 minutes
Getting Table and Column Details2 minutes

4 readingsTotal 5 minutes

Summary and Highlights1 minute
[Optional] Hands-on Labs Using IBM Db21 minute
Congratulations & Next Steps2 minutes
Thanks from the Course Team1 minute

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.

What's included

6 videos6 readings2 assignments4 app items

6 videosTotal 24 minutes

Views4 minutes
Stored Procedures4 minutes
ACID Transactions4 minutes
Join Overview4 minutes
Inner Join3 minutes
Outer Joins6 minutes

6 readingsTotal 29 minutes

About this Bonus Module2 minutes
[Optional] Hands-on Labs Using IBM Db22 minutes
Summary: Views, Stored Procedures, and Transactions5 minutes
SQL Cheat Sheet: Views, Stored Procedures and Transactions10 minutes
Summary: JOIN Statements5 minutes
SQL Cheat Sheet: JOIN Statements5 minutes

2 assignmentsTotal 20 minutes

Practice Quiz: Views, Stored Procedures, and Transactions10 minutes
Practice Quiz: Join Statements10 minutes

4 app itemsTotal 80 minutes

Hands-on Lab: Using Views20 minutes
Hands-on Lab: Stored Procedures20 minutes
Hands-on Lab: Committing and Rolling Back a Transaction20 minutes
Hands-on Lab: Joins20 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

Rav Ahuja

IBM

49 Courses4,439,631 learners

Hima Vasudevan

IBM

4 Courses692,365 learners

Offered by

IBM

Explore more from Data Analysis

Status: Free Trial
Edureka
Applied Data Analytics with Python and SQL
Course
Status: Free Trial
IBM
SQL for Data Science with R
Course
Status: Free Trial
Duke University
Scripting with Python and SQL for Data Engineering
Course
Status: Free Trial
Coursera
SQL for Data Science (and Version Control with GitHub)
Course

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."

Frequently asked questions

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.

When you enroll in the course, you get access to all of the courses in the Certificate, 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.