Course Content
Introduction to SQL
0/2
What is SQL?
14:57
How to Setup & Install SQL Server
11:41
Basic SQL Queries
0/2
SQL SELECT Queries: All Essential Clauses
54:49
SQL WHERE Conditions | AND, OR, NOT, LIKE, BETWEEN, IN
40:37
SQL Command Types: DDL & DML
0/2
SQL DDL Commands | CREATE, ALTER, DROP
11:34
SQL DML Commands | INSERT, UPDATE, DELETE
25:06
Basic Joins and Functions
0/4
SQL Joins Basics: INNER, LEFT, RIGHT, FULL
40:18
SQL Functions Explained
05:23
SQL String Functions
26:27
SQL Number Functions
04:21
Working with NULL and Case Statements
0/3
SQL NULL Functions | COALESCE, ISNULL, NULLIF, IS (NOT) NULL
52:59
SQL NULL vs Empty String vs Blank Space
17:04
SQL CASE WHEN Statement
36:18
Complex Queries & Joins
0/3
Advanced SQL JOINS: ANTI & CROSS
19:16
Joining Multiple Tables in SQL (3+ Joins)
14:48
SQL SET Operators: UNION, UNION ALL, EXCEPT, INTERSECT
48:37
Date & Time Functions
0/4
SQL Date & Time Functions I
43:26
SQL Date & Time Functions II
30:47
SQL Date & Time Functions III
23:47
SQL Aggregate Functions | COUNT, SUM, AVG, MAX, MIN
06:37
Window Functions
0/4
SQL Window Functions Basics
57:18
SQL Aggregate Window Functions
01:07:33
SQL Ranking Window Functions
01:04:31
SQL Value Window Functions
45:01
Reusable Query Structures
0/5
SQL Subquery
01:21:27
SQL CTE (Common Table Expression)
01:17:41
SQL Views
01:02:40
SQL CTAS | Create Tables From Query
25:58
SQL Temp Tables
16:18
Indexing & Performance
0/4
SQL Indexes | Clustered vs Nonclustered
43:09
SQL Columnstore vs Rowstore Indexes
26:22
SQL Unique & Filtered Indexes
12:02
Choosing the Right Index
03:53
SQL Hands-On Starter Portfolio Project
0/9
Intro To SQL Project
01:46
Intro to Data Warehouse
06:54
Intro to the ETL Process: Extract, Transform, Load Explained
11:11
Project Plan & Setup
10:03
Designing a Data Architecture for Your Data Warehouse
25:29
Project Setup: Git, Naming & Database Creation
17:17
Build The Bronze Layer: Data Ingestion
37:40
Build The Silver Layer: Cleanse & Transform Data
01:38:01
Building The Gold Layer: Star Schema Modeling
54:48
Complete SQL Masterclass: For Data Analysts & Developers
About Lesson

Course materials are available for download below

Download Course Materials

Previous
Next