SQL & Databases
Schema design, joins that make sense, indexes, transactions, and queries that stay fast.
21 chapters
- 01Chapter 1: Introduction to SQL & RDBMS
- 02Chapter 2: Data Types (MySQL vs PostgreSQL)
- 03Chapter 3: Creating Databases & Tables
- 04Chapter 5: Constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, etc.)
- 05Chapter 6: WHERE, GROUP BY, HAVING, ORDER BY
- 06Chapter 7: Joins (INNER, LEFT, RIGHT, FULL)
- 07Chapter 8: Aggregate Functions (COUNT, SUM, AVG, etc.)
- 08Chapter 9: Subqueries and Nested Queries
- 09Chapter 10: Window Functions
- 10Chapter 11: Indexes and Query Optimization
- 11Chapter 12: Stored Procedures and Functions
- 12Chapter 13: Triggers and Events
- 13Chapter 15: Transactions and Concurrency Control
- 14Chapter 16: Database Security and User Management
- 15Chapter 17: Backup and Recovery
- 16Chapter 18: Database Replication & High Availability
- 17Chapter 19: Database Proxies & Connection Pooling
- 18Chapter 20: Partitioning & Sharding
- 19Chapter 21: ETL & Data Warehousing
- 20Chapter 22: Cloud Databases & Database as a Service (DBaaS)
- 21Chapter 23: Database DevOps & CI/CD