VOOZH about

URL: https://www.coursera.org/learn/sql-data-science

⇱ Databases and SQL for Data Science with Python | Coursera

Databases and SQL for Data Science with Python

Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.

Databases and SQL for Data Science with Python

This course is part of multiple programs.

655,129 already enrolled

Included with

Ask Coursera

Gain insight into a topic and learn the fundamentals.
4.7

22,666 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
Gain insight into a topic and learn the fundamentals.
4.7

22,666 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.

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

14 assignments¹

AI Graded see disclaimer
Taught in English

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 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
4 readings•Total 23 minutes
  • Course Overview•3 minutes
  • SELECT statement examples•10 minutes
  • Module Summary: Getting Started with SQL•5 minutes
  • SQL Cheat Sheet: Basics - SELECT, INSERT, UPDATE, DELETE, COUNT, DISTINCT, LIMIT•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

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 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
7 readings•Total 45 minutes
  • Examples to ALTER and TRUNCATE tables using MySQL•10 minutes
  • Examples to CREATE and DROP tables•10 minutes
  • Understanding Relational Model Constraints•10 minutes
  • SQL Scripts - Uses and Applications•7 minutes
  • Summary: Relational Database Concepts and Tables•2 minutes
  • SQL Cheat Sheet: CREATE TABLE, ALTER, DROP, TRUNCATE•5 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

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 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
6 readings•Total 22 minutes
  • [Optional] Hands-on Labs Using IBM Db2•1 minute
  • Summary: Refining Your Results•5 minutes
  • SQL Cheat Sheet: Intermediate - LIKE, ORDER BY, GROUP BY•5 minutes
  • [Optional] Hands-on Labs Using IBM Db2•1 minute
  • Summary: Functions, Multiple Tables, and Sub-queries•5 minutes
  • SQL Cheat Sheet: FUNCTIONS and Implicit JOIN•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

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 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
3 readings•Total 13 minutes
  • Summary: Accessing databases using Python•2 minutes
  • SQL Cheat Sheet: Accessing Databases using Python•10 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

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

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
6 readings•Total 29 minutes
  • About this Bonus Module•2 minutes
  • [Optional] Hands-on Labs Using IBM Db2•2 minutes
  • Summary: Views, Stored Procedures, and Transactions•5 minutes
  • SQL Cheat Sheet: Views, Stored Procedures and Transactions•10 minutes
  • Summary: JOIN Statements•5 minutes
  • SQL Cheat Sheet: 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

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
4.6 (3,879 ratings)
IBM
55 Courses•5,118,042 learners
IBM
4 Courses•688,058 learners

Offered by

Explore more from Data Analysis

Why people choose Coursera for their career

👁 Image

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

Jennifer J.

Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
👁 Image

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

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.37%

  • 4 stars

    18.30%

  • 3 stars

    3.83%

  • 2 stars

    1.10%

  • 1 star

    1.38%

Showing 3 of 22666

MM
·

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!

AZ
·

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.

AT
·

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!

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.

Financial aid available,

¹ Some assignments in this course are AI-graded. For these assignments, your data will be used in accordance with Coursera's Privacy Notice.