| 1 |
SQL Basics (Introduction, What is SQL, Databases, RDBMS) |
|
| 2 |
Database Installation & Setup (MySQL, PostgreSQL, SQL Server, SQLite) |
|
| 3 |
Data Types (INT, VARCHAR, CHAR, DATE, BOOLEAN, DECIMAL, TEXT) |
|
| 4 |
Creating Databases & Tables (CREATE, ALTER, DROP) |
|
| 5 |
Inserting Data (INSERT INTO, Bulk Insert, Default Values) |
|
| 6 |
Selecting Data (SELECT, DISTINCT, Aliases, Expressions) |
|
| 7 |
Filtering Data (WHERE, AND, OR, NOT, LIKE, IN, BETWEEN) |
|
| 8 |
Sorting & Limiting Data (ORDER BY, LIMIT, OFFSET) |
|
| 9 |
Joins (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, CROSS JOIN) |
|
| 10 |
Aggregate Functions (COUNT, SUM, AVG, MIN, MAX) |
|
| 11 |
Grouping Data (GROUP BY, HAVING) |
|
| 12 |
Subqueries (Single Row, Multi Row, Correlated Subqueries) |
|
| 13 |
Set Operations (UNION, UNION ALL, INTERSECT, EXCEPT) |
|
| 14 |
Indexes (Primary Key, Unique, Composite, Full-Text) |
|
| 15 |
Constraints (NOT NULL, UNIQUE, CHECK, DEFAULT, FOREIGN KEY) |
|
| 16 |
Views (CREATE VIEW, Updating Views, Materialized Views) |
|
| 17 |
Stored Procedures (CREATE PROCEDURE, Parameters, Execution) |
|
| 18 |
Functions (Scalar Functions, Table-Valued Functions, User-Defined Functions) |
|
| 19 |
Triggers (AFTER, BEFORE, INSTEAD OF, Trigger Events) |
|
| 20 |
Transactions (BEGIN, COMMIT, ROLLBACK, ACID Properties) |
|
| 21 |
Locks & Concurrency (Row-Level, Table-Level, Deadlocks, Isolation Levels) |
|
| 22 |
Normalization & Denormalization (1NF, 2NF, 3NF, BCNF) |
|
| 23 |
Database Design (ER Diagrams, Relationships, Keys) |
|
| 24 |
Performance Optimization (Indexes, Query Optimization, EXPLAIN Plans) |
|
| 25 |
Advanced Queries (Window Functions, CTEs, Recursive Queries) |
|
| 26 |
Security & User Management (Roles, Privileges, GRANT, REVOKE) |
|
| 27 |
Backup & Restore (Full Backup, Incremental Backup, Restore Strategies) |
|
| 28 |
Data Import & Export (CSV, JSON, Bulk Copy, ETL Basics) |
|
| 29 |
Monitoring & Maintenance (Performance Metrics, Logs, Health Checks) |
|
| 30 |
SQL Best Practices & Documentation |
|