Complete SQL Course – From Zero to Data Pro

About Course

Learn SQL from scratch and master the skills to query, analyze, and manage data like a professional.

This course covers everything from the basics to advanced techniques with real-world examples.

Course Content

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

About Course

What Will You Learn?

Course Content

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