Complete SQL Road Map
1. Intro to SQL
- Definition
- Purpose
- Relational DBs
- DBMS
2. Basic SQL Syntax
- SELECT
- FROM
- WHERE
- ORDER BY
- GROUP BY
3. Data Types
- Integer
- Floating-Point
- Character
- Date
- VARCHAR
- TEXT
- BLOB
- BOOLEAN
4. Sub languages
- DML
- DDL
- DQL
- DCL
- TCL
5. Data Manipulation
- INSERT
- UPDATE
- DELETE
6. Data Definition
- CREATE
- ALTER
- DROP
- Indexes
7. Query Filtering and Sorting
- WHERE
- AND
- OR Conditions
- Ascending
- Descending
8. Data Aggregation
- SUM
- AVG
- COUNT
- MIN
- MAX
9. Joins and Relationships
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- Self-Joins
- Cross Joins
- FULL OUTER JOIN
10. Subqueries
- Subqueries used in
- Filtering data
- Aggregating data
- Joining tables
- Correlated Subqueries
11. Views
- Creating
- Modifying
- Dropping Views
12. Transactions
- ACID Properties
- COMMIT
- ROLLBACK
- SAVEPOINT
- ROLLBACK TO SAVEPOINT
13. Stored Procedures
- CREATE PROCEDURE
- ALTER PROCEDURE
- DROP PROCEDURE
- EXECUTE PROCEDURE
- User-Defined Functions (UDFs)
14. Triggers
- Trigger Events
- Trigger Execution and Syntax
15. Security and Permissions
- CREATE USER
- GRANT
- REVOKE
- ALTER USER
- DROP USER
16. Optimizations
- Indexing Strategies
- Query Optimization
17. Normalization
- 1NF(Normal Form)
- 2NF
- 3NF
- BCNF
18. Backup and Recovery
- Database Backups
- Point-in-Time Recovery
19. NoSQL Databases
- MongoDB
- Cassandra etc…
- Key differences
20. Data Integrity
- Primary Key
- Foreign Key
21. Advanced SQL Queries
- Window Functions
- Common Table Expressions (CTEs)
22. Full-Text Search
- Full-Text Indexes
- Search Optimization
23. Data Import and Export
- Importing Data
- Exporting Data (CSV, JSON)
- Using SQL Dump Files
24. Database Design
- Entity-Relationship Diagrams
- Normalization Techniques
25. Advanced Indexing
- Composite Indexes
- Covering Indexes
26. Database Transactions
- Savepoints
- Nested Transactions
- Two-Phase Commit Protocol
27. Performance Tuning
- Query Profiling and Analysis
- Query Cache Optimization
