Skip to content

πŸ“ SQL Content Structure Overview

Location: dsa-docs/src/content/docs/sql/ Total Files: 43 files (flat structure)

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 AreaFilesKey Concepts
Basics3RDBMS basics, MySQL architecture, data types
CRUD & Constraints3CRUD operations, keys & constraints
Joins11All join types (INNER, LEFT, RIGHT, FULL, CROSS, SELF, ANTI), decision guide, pitfalls
Advanced Queries6Subqueries, CTEs, set operations, aggregations, window functions, CASE, NULL handling
Schema & Objects6Normalization, indexing, views, stored procedures, triggers, JSON/FullText
Performance & Transactions7ACID, isolation levels, locks, EXPLAIN, query optimization, partitioning/sharding, replication
Security1Users & privileges
Interview3Interview Q&A (Γ—3 formats)
Reference2Quick reference summary, revision cheat sheet

File Count: 43 files | Created: July 3, 2026