1
SQL Fundamentals
- Introduction to Databases — Types, Properties & CRUDReady
- What SQL Is & Why Databases ExistComing soon
- Relational Database ConceptsComing soon
- Tables, Rows, ColumnsComing soon
- Primary Key vs Foreign KeyComing soon
- Basic SQL Syntax & FormattingComing soon
2
Table Design & Schema Basics
- CREATE TABLEComing soon
- Constraints: PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL, CHECKComing soon
- Indexes (Conceptual + Practical Intro)Coming soon
- Normalization Basics (1NF, 2NF, 3NF)Coming soon
- Denormalization (When & Why)Coming soon
3
Data Manipulation (DML)
- INSERTComing soon
- UPDATEComing soon
- DELETEComing soon
- UPSERT (ON CONFLICT)Coming soon
- Transactions (BEGIN, COMMIT, ROLLBACK)Coming soon
4
Core Querying
- SELECT, FROM, WHEREComing soon
- DISTINCTComing soon
- ORDER BYComing soon
- LIMIT / OFFSETComing soon
- Aliases (AS)Coming soon
5
Filtering & Conditions
- Comparison Operators (=, !=, <, >, BETWEEN)Coming soon
- Logical Operators (AND, OR, NOT)Coming soon
- IN, NOT INComing soon
- LIKE, ILIKEComing soon
- IS NULL, IS NOT NULLComing soon
- CASE WHENComing soon
6
Aggregations & Grouping
- Aggregate Functions: COUNT, SUM, AVG, MIN, MAXComing soon
- GROUP BYComing soon
- HAVINGComing soon
- WHERE vs HAVINGComing soon
7
Joins
- INNER JOINComing soon
- LEFT JOINComing soon
- RIGHT JOINComing soon
- FULL OUTER JOINComing soon
- CROSS JOINComing soon
- Join Conditions & Join KeysComing soon
- Self JoinsComing soon
- Common Join Pitfalls (Duplicate Rows)Coming soon
8
Subqueries & CTEs
- Subqueries in SELECT, FROM, WHEREComing soon
- Correlated SubqueriesComing soon
- WITH (Common Table Expressions)Coming soon
- Recursive CTEs (Conceptual)Coming soon
- CTEs vs Subqueries — When to Use WhichComing soon
9
Window Functions
- OVER() ClauseComing soon
- PARTITION BYComing soon
- ORDER BY within WindowsComing soon
- Ranking Functions: ROW_NUMBER, RANK, DENSE_RANKComing soon
- Aggregate Window FunctionsComing soon
- LAG, LEADComing soon
- Running Totals & Moving AveragesComing soon
10
Data Cleaning & Transformation
- String Functions (LOWER, UPPER, TRIM, SUBSTRING)Coming soon
- Date/Time FunctionsComing soon
- Type Casting (CAST, ::)Coming soon
- Handling Missing ValuesComing soon
- Conditional TransformationsComing soon
- Normalizing Raw Data Using SQLComing soon
11
Performance & Optimization
- Indexes and How They Work (Deep Dive)Coming soon
- Query Execution Plans (EXPLAIN)Coming soon
- Common Slow Query PatternsComing soon
- Filtering Early vs LateComing soon
- Avoiding Unnecessary JoinsComing soon
- When SQL Beats PandasComing soon
12
Analytical Thinking with SQL
- Funnel AnalysisComing soon
- Cohort AnalysisComing soon
- Time-Based AnalysisComing soon
- User Behavior AnalysisComing soon
- Feature Extraction Using SQLComing soon
- Creating ML-Ready DatasetsComing soon
13
SQL Dialects Awareness
- PostgreSQLComing soon
- MySQLComing soon
- SQLiteComing soon
- BigQuery / Snowflake (Conceptual)Coming soon
- ANSI SQL vs Dialect DifferencesComing soon
14
SQL + Python Integration
- Running SQL from PythonComing soon
- sqlite3, psycopg2, sqlalchemyComing soon
- Pandas + SQL WorkflowsComing soon
- Writing Parameterized QueriesComing soon
- Avoiding SQL InjectionComing soon
15
Databases Every AI Engineer Should Touch
- PostgreSQLComing soon
- SQLiteComing soon
- MySQLComing soon
- Cloud Warehouses (BigQuery / Redshift / Snowflake — Awareness)Coming soon