✦ AI TUTORClick any topic node to open it — then switch to AI Tutor tab for an instant AI explanation
11 topicsSQL
Master SQL — from basic queries to advanced joins, window functions, query optimization, and database design.
- SQL
- Relational Database Concepts
- Basic Queries (SELECT, WHERE)
- CRUD (INSERT, UPDATE, DELETE)
- JOINs (INNER, LEFT, RIGHT, FULL)
- Aggregations (GROUP BY, HAVING)
- Subqueries & CTEs
- Window Functions (ROW_NUMBER, RANK)
- Indexes & Query Optimization
- Transactions & ACID
- Database Design & Normalization
- Stored Procedures & Views