Skip to content

00-index.md

Latest commit

 

History

History
33 lines (25 loc) · 1.2 KB

00-index.md

File metadata and controls

33 lines (25 loc) · 1.2 KB
Raw

SQL Guide Index

Architecture / Rationale

This guide is structured as a scalable learning path for Obsidian and GitHub publishing.

Level boundaries: 0. Level 0 - Foundations: what SQL is, ER modeling, first steps, and the Northwind database.

  1. Level 1 - Structure: schema design and relational integrity.
  2. Level 2 - Basics: core query and mutation patterns.
  3. Level 3 - Intermediate: joins, subqueries, views, union, normalization.
  4. Level 4 - Advanced: transactions, stored procedures, user-defined functions.
  5. Future Levels: indexing deep dive, query optimization, operational SQL.

Current implementation scope is Level 0 through Level 4.

Query / Code Blocks

-- Suggested learning sequence
-- [[00-foundations/00-index]]
-- [[01-structure/00-index]]
-- [[02-basics/00-index]]
-- [[03-intermediate/00-index]]
-- [[04-advanced/00-index]]
-- [[90-roadmap/00-future-themes]]

Performance / Optimization Notes

  • Keep each concept in a dedicated file for predictable navigation in large vaults.
  • Use numeric prefixes (00, 01, 02) to enforce deterministic reading order.
  • Reuse the same section headings in every page to support consistent maintenance and reviews.