Complete SQL Course – From Zero to Data Pro

0 (0 Ratings)

Complete SQL Course – From Zero to Data Pro

Categories Data analytics

Wishlist

Write powerful queries to retrieve, filter, and sort data
Master data aggregation and data segmentation for business insights
How to combine data from multiple tables with JOINs and Subqueries
Advanced reporting and analytics using Window Functions
Database Management concepts (DDL & DML)

Course Curriculum

Module 1 – Introduction to Databases & SQL

Introduction to Databases

02:00
What is SQL & How Databases Work

01:58
SQL Basic Concepts

01:58
Setting Up Google Colab for SQL

03:00
How to study this course

00:00
Practice: SELECT & FROM Statements

09:56
Working with Text Data Type

01:03
Working with (Date)Data Type

00:36
Filtering Data Using WHERE Conditions

02:59
Quiz 1 – SQL Basics

Module 2 – SQL Data Aggregation

Introduction to Aggregate Functions

05:49
Using Aliases in SQL

01:34
Data Aggregation with Group By

05:17
AVG() Function Practice

02:14
How to Search on SQL Functions on W3Schools Website

02:30
Using HAVING for Groups Filtering

08:49
CASE WHEN Statement (Advanced SQL)

08:39
Practice: CASE WHEN & Aggregation

04:09
Combined Practice: CASE WHEN + WHERE + Aggregation

04:56
Case When Deep Analysis

03:03
How to solve quizzes and Graduation Project in this course
Quiz 2 – SQL Aggregation

Module 3 – Subqueries & Joins

Introduction to Subqueries

07:00
Subquery Practice

10:24
Introduction to Joins

02:16
SQL Databases types introduction

02:37
Introduction to SQL Server Management Studio (SSMS)

05:29
Setup Microsoft SQL Server on your Computer

01:22
Importing Databases into SSMS

01:49
Inner Join Explained (with Animation)

01:30
Practice on inner join

05:17
Join Types Overview

02:13
Left Join Explained (with Animation)

01:26
Practice on Left join

04:59
Right Join Explained (with Animation)

01:01
Practice on Right Join

02:08
Full Outer Join Practice

01:46
Self Join Explained (with Animation)

03:16
Practice on Self Join Interview question [Part 1]

05:20
Practice on Self Join Interview question [Part 2]

03:20
cross join (Use Case 1) practice

02:48
cross join (Use Case 2) practice

03:41
Union

03:38
The difference between Union and Union All

01:50
Quiz 3 – Subqueries & Joins

Module 4 – Advanced SQL: Window Functions

Module 5 – Database Management (DDL & DML)

SQL Graduation Project

Student Ratings & Reviews

No Review Yet

Level

All Levels
Total Enrolled

235
Last Updated

January 12, 2026
Certificate

Certificate of completion

Complete SQL Course – From Zero to Data Pro

What I will learn?

Course Curriculum

Module 1 – Introduction to Databases & SQL

Introduction to Databases

What is SQL & How Databases Work

SQL Basic Concepts

Setting Up Google Colab for SQL

How to study this course

Practice: SELECT & FROM Statements

Working with Text Data Type

Working with (Date)Data Type

Filtering Data Using WHERE Conditions

Quiz 1 – SQL Basics

Module 2 – SQL Data Aggregation

Introduction to Aggregate Functions

Using Aliases in SQL

Data Aggregation with Group By

AVG() Function Practice

How to Search on SQL Functions on W3Schools Website

Using HAVING for Groups Filtering

CASE WHEN Statement (Advanced SQL)

Practice: CASE WHEN & Aggregation

Combined Practice: CASE WHEN + WHERE + Aggregation

Case When Deep Analysis

How to solve quizzes and Graduation Project in this course

Quiz 2 – SQL Aggregation

Module 3 – Subqueries & Joins

Introduction to Subqueries

Subquery Practice

Introduction to Joins

SQL Databases types introduction

Introduction to SQL Server Management Studio (SSMS)

Setup Microsoft SQL Server on your Computer

Importing Databases into SSMS

Inner Join Explained (with Animation)

Practice on inner join

Join Types Overview

Left Join Explained (with Animation)

Practice on Left join

Right Join Explained (with Animation)

Practice on Right Join

Full Outer Join Practice

Self Join Explained (with Animation)

Practice on Self Join Interview question [Part 1]

Practice on Self Join Interview question [Part 2]

cross join (Use Case 1) practice

cross join (Use Case 2) practice

Union

The difference between Union and Union All

Quiz 3 – Subqueries & Joins

Module 4 – Advanced SQL: Window Functions

introduction to window functions

Nth Rank using Row_Number()

Row_Number() with partition by and order by

CTE Commen table Expresion

Quiz 4 – Window Functions

Module 5 – Database Management (DDL & DML)

How to create tables in the Database [Method 1]

How to create tables in Database [Method 2]

How to Modify the table structure (adding, deleting, renaming cols ..etc)

How to insert data into a table [Method 1]

How to insert data into tables [Method 2]

How to delete rows from a table

How to update the values inside a table

Quiz

SQL Graduation Project

Quiz

Student Ratings & Reviews

Shopping cart