Databases and SQL for Data Science with Python by Coursera
This course is part of multiple programs.
Course Highlights
- 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 will learn!
Curriculum
16 Topics
Course Introduction
Introduction to Databases
SELECT Statement
COUNT DISTINCT LIMIT
INSERT Statement
UPDATE and DELETE Statements
Course Overview
Summary: Basic SQL
Practice Quiz: Basic SQL
Graded Quiz: Basic SQL
Hands-on Lab: Simple SELECT Statements
Hands-on Lab: COUNT DISTINCT LIMIT
Hands-on Lab: INSERT UPDATE and DELETE
Helpful Tips for Course Completion
SELECT statement examples
SQL Cheat Sheet: Basics - SELECT INSERT UPDATE DELETE COUNT DISTINCT LIMIT
16 Topics
Relational Database Concepts
Types of SQL statements (DDL vs. DML)
CREATE TABLE Statement
ALTER DROP and Truncate Tables
How to create a Database instance on Cloud
Summary: Relational Database Concepts and Tables
[Optional] Hands-on Lab Using IBM Db2
Practice Quiz: Introduction to Relational Databases and Tables
Relational DB Concepts and Tables
Hands-on Lab : CREATE ALTER TRUNCATE DROP
Hands-on Lab: Create and Load Tables using SQL Scripts
Obtain IBM Cloud Feature Code and Activate Trial Account
Examples to ALTER and TRUNCATE tables using MySQL
Examples to CREATE and DROP tables
SQL Scripts - Uses and Applications
SQL Cheat Sheet: CREATE TABLE ALTER DROP TRUNCATE
21 Topics
Using String Patterns and Ranges
Sorting Result Sets
Grouping Result Sets
Built-in Database Functions
Date and Time Built-in Functions
Sub-Queries and Nested Selects
Working with Multiple Tables
[Optional] Hands-on Labs Using IBM Db2
Summary: Refining Your Results
[Optional] Hands-on Labs Using IBM Db2
Summary: Functions Multiple Tables and Sub-queries
Practice Quiz: Refining Your Results
Practice Quiz: Functions Multiple Tables and Sub-queries
Graded Quiz: Refining Your Results
Graded Quiz: Functions Multiple Tables and Sub-queries
Hands-on Lab: String Patterns Sorting and Grouping
Hands-on Lab: Built-in functions
Hands-on Lab: Sub-queries and Nested Selects
Hands-on Lab: Working with Multiple Tables
SQL Cheat Sheet: Intermediate - LIKE ORDER BY GROUP BY
SQL Cheat Sheet: FUNCTIONS and Implicit JOIN
18 Topics
How to Access Databases Using Python
Writing code using DB-API
Accessing Databases with SQL Magic
Analyzing data with Python
Connecting to a database using ibm_db API
Creating tables loading data and querying data
Summary: Accessing databases using Python
[Optional] Hands-on Labs Using IBM Db2
Practice Quiz: Accessing Databases using Python
Graded Quiz: Accessing databases using Python
Hands-on Lab: Creating tables inserting and querying Data
Hands-on Tutorial: Accessing Databases with SQL magic
Hands-on Lab: Analyzing a Real-World Data Set
(Optional) Db2 Lab: Connecting to a database instance
(Optional) Db2 Lab: Creating tables inserting and querying Data
(Optional) Db2 Lab: Tutorial Accessing Databases with SQL magic
(Optional) Db2 Lab: Analyzing a real World Data Set
SQL Cheat Sheet: Accessing Databases using Python
10 Topics
Working with Real World Datasets
Getting Table and Column Details
Summary and Highlights
[Optional] Hands-on Labs Using IBM Db2
Congratulations & Next Steps
Graded Quiz on Assignment
Final Exam
Hands-on Lab: Working with a real world data-set
(Optional)Hands-on Lab: Practice Querying Real World Datasets
Final Assignment: Database Querying using SQLite
22 Topics
Views
Stored Procedures
ACID Transactions
Join Overview
Inner Join
Outer Joins
About this Honors Module
[Optional] Hands-on Labs Using IBM Db2
Summary: Views Stored Procedures and Transactions
Summary: JOIN Statements
Practice Quiz: Views Stored Procedures and Transactions
Practice Quiz: Join Statements
Graded Quiz: Views Stored Procedures and Transactions
Graded Quiz: JOIN Statements
Graded Quiz: Advanced SQL for Data Engineers
Hands-on Lab: Using Views
Hands-on Lab: Stored Procedures
Hands-on Lab: Committing and Rolling Back a Transaction
Hands-on Lab: Joins
Hands-on Lab: Final Project: Advanced SQL Techniques
SQL Cheat Sheet: Views Stored Procedures and Transactions
SQL Cheat Sheet: JOIN Statements
Databases and SQL for Data Science with Python
Related SQL Courses
Thank You!
Your review has been submitted successfully.