A.

What is SQL

B. Why learn SQL

C. What is Database & Types

1. Introduction
D. SQL Commands

a. Download & Install SQL Server

E. Setup Your Environment
b. Datasets and Create Databases

A. SELECT

B. FROM

C. WHERE

D. ORDER BY

2. Query Data (SELECT) E. GROUP BY

[Link] Level
F. HAVING

G. DISTINCT

H. TOP

I. Query Order & Execution

A. CREATE

3. Data Definition (DDL) B. ALTER

C. DROP

A. INSERT

4. Data Manipulation (DML) B. UPDATE

C. DELETE

A. Comparison Operators 1. =, !=, <>, <, >, >=, <=

a. AND

B. Logical Operators b. OR

5. Filterting Data c. NOT

C. BETWEEN

D. IN

E. LIKE

i. INNER Join

ii. LEFT Join

a. Basic Joins
iii. RIGHT Join

iv. FULL Join

i. LEFT Anti Join

ii. Right Anti Join

A. Joining Data
b. Advanced Joins
iii. FULL Anti Join

iv. Cross Join

c. How to Choose The Right Join

6. Combining Data
d. How To Join Multiple Tables

a. UNION

b. UNION ALL
B. SET Operators
c. EXCEPT

d. INTERSECT

a. CONCAT

b. LOWER/UPPER

c. TRIM

d. REPLACE
A. String Functions
e. LEN

f. LEFT

g. RIGHT

h. SUBSTRING
[Link] Level
a. ROUND
B. Numeric Functions
b. ABS
7. Row-Level Functions C. Date & Time Functions

a. ISNULL

SQL Course b. NULLIF

D. Null Functions c. COALESCE

d. CASE WHEN

e. IS NULL / IS NOT NULL

E. Case Statement

a. COUNT

b. SUM

A. Aggregate Functions c. AVG

d. MIN

e. MAX

B. Window Basics

a. COUNT

b. SUM

C. Window Aggregate Func. c. AVG

d. MAX

e. MIN
8. Aggregation & Analytical Functions
a. ROW_NUMBER

b. RANK

c. DENSE_RANK
D. Window Ranking Func.
d. NTILE

e. CUME_DISTC

f. PERCENT_RANK

a. LAG

b. LEAD
E. Window Value Func.
c. FIRST_VALUE

d. LAST_VALUE

a. MAX
a. Subqueries Basics
b. MIN

A. Subqueries b. Subqueries Examples

a. MAX
c. Subqueries vs Joins
b. MIN

a. CTE Basics

b. Non-Recursive
B. CTE
9. Advanced SQL Techniques c. Recursive

d. CTE vs Subqueries

C. Views

D. CTAS Table & Temp Tables

E. Stored Procedure

F. Triggers

A. Indexes

10. Performance Optimization B. Partitions

[Link] Level
C. Performance Tips

A. Generate SQL Code

B. Explain SQL Code

C. Understand & Learn SQL Concepts

D. Styling Code & Comments

E. Create Code Documentation

11. AI & SQL
F. Explaining Error Messages

G. Find Bugs & Fixing Errors

H. Translating Queries between Different Databases

I. Generating Sample Data

J. Optimizing Performance

A. Data Warehousing Project

12. SQL Projects B. Exploratory Data Analysis (EDA) project

C. Advanced Data Analytics Project