π SQL Content Structure Overview
π SQL Content Structure Overview
Section titled βπ SQL Content Structure OverviewβLocation:
dsa-docs/src/content/docs/sql/Total Files: 43 files (flat structure)
π Directory Tree
Section titled βπ Directory Treeβsql/βββ π index.mdβββ π database-rdbms-basics.mdβββ π mysql-architecture.mdββββ π data-types.mdβββ π crud-operations.mdβββ π keys-constraints.mdββββ π joins.mdβββ π inner-join.mdβββ π left-join-left-outer-join.mdβββ π right-join-right-outer-join.mdβββ π full-outer-join.mdβββ π cross-join.mdβββ π self-join.mdβββ π exclusion-joins-anti-joins.mdβββ π join-conditions-pitfalls.mdβββ π choosing-the-right-join-decision-guide.mdββββ π subqueries-ctes.mdβββ π set-operations.mdβββ π aggregations-functions.mdβββ π window-functions.mdβββ π case-and-conditional-logic.mdβββ π null-handling.mdβββ π query-execution-order.mdββββ π normalization.mdβββ π indexing.mdβββ π views.mdβββ π stored-procedures-functions.mdβββ π triggers.mdβββ π json-and-fulltext.mdββββ π transactions-acid-properties.mdβββ π isolation-levels-and-deadlocks.mdβββ π locks.mdβββ π explain-query-optimization.mdβββ π performance-optimization.mdβββ π partitioning-and-sharding.mdβββ π replication.mdβββ π backup-and-restore.mdββββ π users-and-privileges.mdββββ π interview-questions.mdβββ π common-interview-questions-answers.mdβββ π interview-prep.mdββββ π quick-reference-summary.mdβββ π quick-revision-cheat-sheet.mdπ Topic Groups
Section titled βπ Topic Groupsβ| Topic Area | Files | Key Concepts |
|---|---|---|
| Basics | 3 | RDBMS basics, MySQL architecture, data types |
| CRUD & Constraints | 3 | CRUD operations, keys & constraints |
| Joins | 11 | All join types (INNER, LEFT, RIGHT, FULL, CROSS, SELF, ANTI), decision guide, pitfalls |
| Advanced Queries | 6 | Subqueries, CTEs, set operations, aggregations, window functions, CASE, NULL handling |
| Schema & Objects | 6 | Normalization, indexing, views, stored procedures, triggers, JSON/FullText |
| Performance & Transactions | 7 | ACID, isolation levels, locks, EXPLAIN, query optimization, partitioning/sharding, replication |
| Security | 1 | Users & privileges |
| Interview | 3 | Interview Q&A (Γ3 formats) |
| Reference | 2 | Quick reference summary, revision cheat sheet |
File Count: 43 files | Created: July 3, 2026