Lessons
- Intro
- Introduction to SQL
- Setup Your Environment
- Query Data (SELECT)
- DDL Commands
- DML Commands
- Filtering Data
- SQL Joins (Basics)
- SQL Joins (Advanced)
- Set Operators
- SQL Functions
- String Functions
- Numeric Functions
- Date and Time Functions
- NULL Functions
- Case Statement
- Aggregate Functions
- Window Functions Basics
- Window Aggregate
- Window Ranking
- Window Value
- Advanced SQL Techniques
- Subqueries
- Common Table Expressions (CTE)
- Views
- CTAS and Temp Tables
- Compare Advanced Techniques
- Stored Procedures
- Triggers
- Indexes
- Execution Plan
- Partitions
- 30x Performance Tips
- AI and SQL
- Project: SQL Data Warehouse
- Project DWH | Bronze
- Project DWH | Silver
- Project DWH | Gold
- Project: Exploratory Data Analysis (EDA)
- Project: Advanced Data Analytics
- Thank You
Learning panel
Guest
Sign in and start this course to unlock notes and progress tracking.