NO JOIN

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Complete SQL Mastery

Introduction to SQL

Course Introduction (1:29)
Course Resources
Course Roadmap & Structure (5:51)
What is SQL and What are Databases? (3:13)
What is DBMS? (2:18)
Types of Databases (2:13)
Database Structure (2:54)
SQL Commands (2:10)
Why Learn SQL? (2:05)
Environment Setup: SQL Server, SSMS and Databases (20:04)

SELECT Queries

What is SQL Query (1:46)
Components of SQL (2:45)
SELECT & FROM (8:01)
WHERE (6:03)
ORDER BY (8:55)
GROUP BY (8:17)
HAVING (7:57)
DISTINCT (3:22)
TOP (5:13)
Coding & Execution Order (4:00)
Cool SQL Stuff (4:50)

Data Definition (DDL)

CREATE (6:19)
ALTER (3:23)
DROP (1:45)

Data Manipulation (DML)

INSERT (13:26)
UPDATE (6:30)
DELETE (4:21)

Filtering Data

Intro - What is Data Filtering (1:16)
Comparison Operators (9:15)
AND Operator (4:41)
OR Operator (2:53)
NOT Operator (3:28)
BETWEEN Operator (4:28)
IN Operator (4:14)
LIKE Operator (10:46)

SQL Joins

Intro - What is Data Combining (1:33)
Intro to JOINS (8:57)
NO JOIN (1:40)
INNER JOIN (12:30)
LEFT JOIN (7:12)
RIGHT JOIN (4:55)
FULL JOIN (4:39)
LEFT ANTI JOIN (4:04)
RIGHT ANTI JOIN (4:56)
FULL ANTI JOIN (6:57)
CROSS JOIN (3:16)
Choosing the Right JOIN (1:39)
Multiple Table JOINS (13:22)

SQL SET Operators

Introduction to SET Operators (0:33)
Set Rules & Syntax (11:58)
UNION (5:25)
UNION ALL (3:54)
EXCEPT (5:18)
INTERSECT (2:37)
Use Case – Combining Information (9:43)
Use Case – Delta Detection (3:55)
SET Operators Summary (2:03)

String Functions

Intro - What is Data Transformation (1:03)
SQL Functions (5:16)
CONCAT (3:04)
UPPER & LOWER (2:30)
TRIM (5:27)
REPLACE (3:31)
LEN (1:49)
LEFT & RIGHT (3:11)
SUBSTRING (6:08)
Number Functions (4:14)

Date & Time Functions

What is Date & Time (3:31)
Overview of Date & Time Functions (2:39)
DAY, MONTH, YEAR (2:59)
DATEPART (5:53)
DATENAME (4:34)
DATETRUNC (8:10)
EOMONTH (3:31)
Use Cases – Date Extraction (5:03)
Comparing Extract Functions (3:38)
Introduction to Formatting & Casting (5:34)
FORMAT (13:13)
CONVERT (6:24)
CAST (5:08)
DATEADD (4:43)
DATEDIFF (4:21)
ISDATE (7:24)
Date & Time Summary (1:08)
Date & Time Scripts

NULL Functions

Introduction to NULLs (2:36)
COALESCE vs ISNULL (11:30)
Handling NULLs – Data Aggregation (3:39)
Handling NULLs – Mathematical Operations (6:10)
Handling NULLs – Joining Data (7:05)
Handling NULLs – Sorting Data (5:32)
NULLIF (5:57)
IS NULL & IS NOT NULL (9:41)
NULL vs Empty vs Blank (6:01)
Handling NULLs – Data Policies (8:35)
NULL Summary (1:52)

CASE WHEN Statement

Introduction to CASE Statements (9:34)
Use Case – Categorizing Data (5:18)
CASE Rules (1:30)
Use Case – Mapping Values (8:51)
Use Case – Handling NULLs (8:32)
CASE Statement Summary (1:49)

Window Functions Basics

Intro - What is Data Aggregation (6:34)
Aggregate Functions (6:34)
Window Functions vs Group By (12:41)
Syntax of Window Functions (5:02)
Window Partition By (10:11)
Window Order By (4:16)
Window Frame (14:26)
Window Function Rules (7:38)
Window Basic Summary (2:26)

Window Aggregate Functions

Introduction to Window Aggregate Functions (2:03)
Window COUNT (16:42)
Window SUM (7:27)
Window AVG (9:03)
Window MIN & MAX (9:37)
Use Case: Rolling & Running Total (9:36)
Use Case: Moving Average (9:07)
Window Aggregate Functions Summary (2:32)

Window Ranking Functions

Introduction to Ranking Functions (4:54)
Window ROW_NUMBER (4:25)
Window RANK (4:04)
Window DENSE_RANK (4:25)
ROW_NUMBER vs RANK vs DENSE_RANK (1:02)
Use Cases: Top/Bottom N Analysis (7:15)
Use Cases: Assign Unique IDs (2:47)
Use Cases: Identify Duplicates (5:34)
Window CUME_DIST (4:50)
Window PERCENT_RANK (7:48)
Window NTILE (13:39)
Window Ranking Function Summary (2:09)

Window Value Functions

Introduction to Window Value Functions (3:39)
Window LEAD & LAG (9:44)
Use Case: Month-Over-Month (MoM) (6:49)
Use Case: Customer Retention (8:45)
Use Case: Time Gap Analysis (5:43)
Window FIRST & LAST (12:10)
Window Value Functions Summary (3:16)

Subqueries

Challenges in Complex Projects (17:27)
What is Subquery? (2:45)
Why Subquery? (2:07)
Subquery Categories (2:06)
Subquery Result Types (2:30)
Subquery in FROM (10:52)
How DB Executes Subquery (1:36)
Subquery in SELECT (7:02)
Subquery in JOIN (5:02)
Subquery in WHERE (6:44)
Subquery using IN Operator (8:29)
Subquery using ALL & ANY Operators (6:13)
Correlated Subquery (10:46)
Subquery using Exists (12:19)
Subquery Summary (1:25)

Common Table Expression (CTE)

Introduction to CTE (6:03)
Why CTE? (4:55)
How DB Executes CTE (2:16)
CTE Types (0:35)
Standalone CTE (8:42)
Multiple Standalone CTE (8:04)
Nested CTE (13:37)
CTE Best Practices (2:41)
Recursive CTE (27:29)
CTE Summary (2:22)

Views

Database Structure & Views (5:26)
What is DDL (5:30)
3 Levels Architecture (4:47)
What is View (1:57)
Views vs Tables (1:39)
Use Case: Central Logic (3:18)
Views vs CTEs (1:44)
CREATE, ALTER, DROP Views (12:16)
How DB Executes View (3:00)
Use Case: Hide Complexity (10:35)
Use Case: Data Security (6:36)
Use Case: Flexibility (2:14)
Use Case: Multi-Language (2:04)
Use Case: Data Warehouse (3:22)
View Summary (2:31)

CTAS & TEMP Tables

Introduction to Tables (3:28)
CTAS vs CREATE/INSERT (2:44)
CTAS vs Views (4:50)
CTAS Syntax (2:43)
Use Case: Optimize Performance (7:39)
How DB Executes CTAS (0:53)
Use Case: Snapshots (1:26)
Use Case: Data Warehouse (2:15)
Introduction to TEMP Tables (2:19)
TEMP Syntax & Example (6:42)
How DB Executes TEMP Tables (1:26)
TEMP Table Use Cases (2:48)
My opinion about TEMP Tables (0:24)
Table Summary (1:59)
Compare All Methods (9:28)

Stored Procedures

Introduction to Stored Procedures (9:26)
Basics of Stored Procedures (4:05)
Parameters (6:49)
Multi-Queries in Stored Procedure (3:06)
Variables (7:39)
Control Flow IF ELSE (6:36)
Error Handling TRY & CATCH (5:18)
Styling Stored Procedures (2:48)
What are Triggers (2:11)
Triggers Use Case (8:28)

Indexes

Introduction Indexes (1:32)
Types of Indexes (1:41)
Heap Structure (6:01)
Clustered Index (6:10)
NonClustered Index (4:46)
Clustered vs NonClustered Index (8:07)
How to Create INDEX (8:44)
Composite Index (4:51)
What is Columnstore Index? (1:45)
Process of Building Columnstore Index (6:30)
Columnstore vs Rowstore Index (6:54)
How to Create Columnstore Index (10:45)
Unique Index (5:34)
Filter Index (5:41)
Choose Right Index (3:30)
Monitor Usage (13:41)
Monitor Missing Indexes (3:15)
Monitor Duplicate Indexes (3:08)
Update Statistics (8:21)
Fragmentations (6:06)
Execution Plan (25:33)
SQL hints (6:14)
Indexing Strategy (1:07)

Partitions

Introduction to Partitions (4:52)
The Process of Partitions (17:18)
Create Partitioned Tables (6:44)
The Performance of Partitions (3:36)

Performance Best Practices

Introduction to Performance Tips (1:27)
Performance Tips for Fetching Data (2:47)
Performance Tips for Filtering (5:21)
Performance Tips for Joining (12:49)
Performance Tips for Aggregation (2:15)
Performance Tips for Subquiers (5:13)
Performance Tips for Table DDL (7:36)
Performance Tips for Indexing (2:04)
Performance Tips Summary (1:06)

Copilot & ChatGPT for SQL

Introduction to AI & SQL (3:36)
What is ChatGPT & Copilot (2:11)
ChatGPT vs Copliot (4:23)
How to Use Copilot (5:38)
ChatGPT Prompt Structure (3:25)
ChatGPT Prompts for SQL Developers (27:48)
ChatGPT Prompts for SQL Learning (12:13)

SQL Data Warehouse Project

Project Resources
SQL Project Types (1:24)
Intro to Data Warehouse (DWH) (6:47)
What is ETL (3:52)
ETL Methods (7:12)
Get Project Resources (2:10)
Notion for Project Management (7:35)
Understand Project Requirements (3:12)
Data Architecture Approaches (6:25)
Design the Data Warehouse Layers (6:53)
Draw DWH Architecture (8:18)
Refine the Project Plan (0:51)
Define The Naming Conventions (6:26)
Prepare Your GIT Repo (4:24)
Create The Database (5:12)
Bronze Layer | Analyze Source Systems (5:18)
Bronze Layer | DDL Create Tables (5:36)
Bronze Layer | Load Scripts (7:53)
Bronze Layer | Build Stored Procedure (13:06)
Bronze Layer | Document The Work (4:55)
Silver Layer | Exploring Data (12:26)
Silver Layer | DDL Create Tables (3:42)
Silver Layer | Load Script 1 (15:08)
Silver Layer | Load Script 2 (20:40)
Silver Layer | Load Script 3 (16:46)
Silver Layer | Load Script 4 (18:47)
Silver Layer | Build Stored Procedure (5:47)
Silver Layer | Document The Work (3:31)
Gold Layer | Data Modelling (6:57)
Gold Layer | Analysis (3:49)
Gold Layer | Build Dimension Customers (16:23)
Gold Layer | Build Dimension Products (7:09)
Gold Layer | Build Fact Sales (6:01)
Gold Layer | Draw The Data Model (5:05)
Gold Layer | Create Data Catalog (2:38)
Gold Layer | Document The Work (5:29)

Exploratory Data Analysis Project (EDA)

Project Resources
Introduction to EDA (0:17)
Data Analytics Project Roadmap (1:53)
Get Project Resources (3:44)
Dimensions vs Measures (4:34)
Database Exploration (1:53)
Dimensions Exploration (3:48)
Date Exploration (5:14)
Measure Exploration (8:31)
Magnitude Analysis (11:26)
Ranking Analysis (7:23)
What is EDA and Why Data Analysts do it? (1:14)

SQL Advanced Data Analytics Project

Introduction to the Project (0:42)
Change Over Time Analysis (8:23)
Cumulative Analysis (7:50)
Performance Analysis (12:24)
Part to Whole Analysis (7:22)
Data Segmentation (15:49)
Build Customers Report (19:12)
Build Products Report (3:37)
Document Your Work in GIT (2:09)

THANK YOU

Congratulations & THANK YOU Video (0:18)

NO JOIN

Complete and Continue

Discussion

1 comments

Lesson Content Locked

Your session expired. Please sign in again to continue.

Login