Databases and SQL for Data Science with Python

Course Content

Module 1: Getting Started with SQL

Course Introduction

00:00
Introduction to Databases

00:00
SELECT Statement

00:00
COUNT, DISTINCT, LIMIT

00:00
INSERT Statement

00:00
UPDATE and DELETE Statements

00:00

2 readings

2 assignments

3 app items

3 plugins

Module 2: Introduction to Relational Databases and Tables

2 readings

2 assignments

3 app items

4 plugins

Module 3: Intermediate SQL

4 readings

4 assignments

4 app items

2 plugins

Module 4: Accessing Databases using Python

2 readings

2 assignments

7 app items

1 plugin

Module 5: Course Assignment

3 readings

2 assignments

3 app items

Module 6: Bonus Module: Advanced SQL for Data Engineer (Honors)

4 readings

5 assignments

5 app items

2 plugins

Student Ratings & Reviews

No Review Yet

What Will You Learn?

Course Content

Module 1: Getting Started with SQL

Course Introduction

Introduction to Databases

SELECT Statement

COUNT, DISTINCT, LIMIT

INSERT Statement

UPDATE and DELETE Statements

2 readings

Course Overview

Summary: Basic SQL

2 assignments

Practice Quiz: Basic SQL

Graded Quiz: Basic SQL

3 app items

Hands-on Lab: Simple SELECT Statements

Hands-on Lab: COUNT, DISTINCT, LIMIT

Hands-on Lab: INSERT, UPDATE, and DELETE

3 plugins

Helpful Tips for Course Completion

SELECT statement examples

SQL Cheat Sheet: Basics – SELECT, INSERT, UPDATE, DELETE, COUNT, DISTINCT, LIMIT

Module 2: Introduction to Relational Databases and Tables

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

2 readings

Summary: Relational Database Concepts and Tables

[Optional] Hands-on Lab Using IBM Db2

2 assignments

Practice Quiz: Introduction to Relational Databases and Tables

Relational DB Concepts and Tables

3 app items

Hands-on Lab : CREATE, ALTER, TRUNCATE, DROP

Hands-on Lab: Create and Load Tables using SQL Scripts

Obtain Cloud Feature Code and Activate Trial Account

4 plugins

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

Module 3: Intermediate SQL

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

4 readings

[Optional] Hands-on Labs Using Db2

Summary: Refining Your Results

[Optional] Hands-on Labs Using Db2

Summary: Functions, Multiple Tables, and Sub-queries

4 assignments

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

4 app items

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

2 plugins

SQL Cheat Sheet: Intermediate – LIKE, ORDER BY, GROUP BY

SQL Cheat Sheet: FUNCTIONS and Implicit JOIN

Module 4: Accessing Databases using Python

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 API

Creating tables, loading data and querying data

2 readings

Summary: Accessing databases using Python

[Optional] Hands-on Labs Using Db2