Course Content
Module 1 – Introduction to Databases & SQL
0/10
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
0/12
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
0/23
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
0/5
introduction to window functions
13:17
Nth Rank using Row_Number()
04:10
Row_Number() with partition by and order by
04:07
CTE Commen table Expresion
02:53
Quiz 4 – Window Functions
Module 5 – Database Management (DDL & DML)
0/8
How to create tables in the Database [Method 1]
08:38
How to create tables in Database [Method 2]
06:58
How to Modify the table structure (adding, deleting, renaming cols ..etc)
02:35
How to insert data into a table [Method 1]
03:38
How to insert data into tables [Method 2]
01:54
How to delete rows from a table
01:03
How to update the values inside a table
02:09
Quiz
SQL Graduation Project
0/1
Quiz
Complete SQL Course – From Zero to Data Pro
Previous
Next
0% Complete
Facebook-f Whatsapp Linkedin Youtube
DataSkool
Logo
Shopping cart