docs/
└── tutorials/
└── sql/
├── index.mdx
│
├── 01-getting-started/
│ ├── what-is-sql.mdx
│ ├── sql-vs-nosql.mdx
│ ├── relational-databases.mdx
│ ├── database-tables-rows-columns.mdx
│ ├── sql-dialects.mdx
│ ├── install-postgresql.mdx
│ ├── install-mysql.mdx
│ └── database-tools.mdx
│
├── 02-sql-fundamentals/
│ ├── sql-syntax.mdx
│ ├── comments-and-statements.mdx
│ ├── data-types.mdx
│ ├── null-values.mdx
│ ├── operators.mdx
│ └── operator-precedence.mdx
│
├── 03-database-and-table-management/
│ ├── create-database.mdx
│ ├── use-and-connect-database.mdx
│ ├── create-table.mdx
│ ├── alter-table.mdx
│ ├── rename-and-drop-table.mdx
│ ├── truncate-table.mdx
│ └── naming-conventions.mdx
│
├── 04-crud-operations/
│ ├── insert-into.mdx
│ ├── select.mdx
│ ├── where-clause.mdx
│ ├── update.mdx
│ ├── delete.mdx
│ ├── distinct.mdx
│ ├── order-by.mdx
│ ├── limit-and-offset.mdx
│ └── returning-and-output.mdx
│
├── 05-filtering-and-operators/
│ ├── comparison-operators.mdx
│ ├── and-or-not.mdx
│ ├── between.mdx
│ ├── in-and-not-in.mdx
│ ├── like-and-wildcards.mdx
│ ├── is-null.mdx
│ ├── case-expressions.mdx
│ └── filtering-dates.mdx
│
├── 06-functions-and-expressions/
│ ├── string-functions.mdx
│ ├── numeric-functions.mdx
│ ├── date-time-functions.mdx
│ ├── conversion-functions.mdx
│ ├── coalesce-and-nullif.mdx
│ ├── conditional-expressions.mdx
│ └── aliases-and-expressions.mdx
│
├── 07-aggregate-queries/
│ ├── count-sum-avg.mdx
│ ├── min-and-max.mdx
│ ├── group-by.mdx
│ ├── having.mdx
│ ├── aggregate-filtering.mdx
│ └── grouping-reports.mdx
│
├── 08-joins-and-relationships/
│ ├── primary-and-foreign-keys.mdx
│ ├── inner-join.mdx
│ ├── left-join.mdx
│ ├── right-join.mdx
│ ├── full-outer-join.mdx
│ ├── cross-join.mdx
│ ├── self-join.mdx
│ ├── multi-table-joins.mdx
│ └── join-vs-subquery.mdx
│
├── 09-subqueries-and-ctes/
│ ├── subquery-fundamentals.mdx
│ ├── correlated-subqueries.mdx
│ ├── exists-and-not-exists.mdx
│ ├── common-table-expressions.mdx
│ ├── recursive-ctes.mdx
│ └── derived-tables.mdx
│
├── 10-advanced-sql/
│ ├── union-and-union-all.mdx
│ ├── intersect-and-except.mdx
│ ├── window-functions.mdx
│ ├── row-number-rank-dense-rank.mdx
│ ├── lag-and-lead.mdx
│ ├── running-totals.mdx
│ ├── pivoting-data.mdx
│ └── json-in-sql.mdx
│
├── 11-database-design/
│ ├── entity-relationship-modeling.mdx
│ ├── normalization.mdx
│ ├── first-normal-form.mdx
│ ├── second-normal-form.mdx
│ ├── third-normal-form.mdx
│ ├── denormalization.mdx
│ ├── indexes-and-constraints.mdx
│ └── schema-design-project.mdx
│
├── 12-constraints-and-keys/
│ ├── primary-key.mdx
│ ├── foreign-key.mdx
│ ├── unique-constraint.mdx
│ ├── not-null-constraint.mdx
│ ├── check-constraint.mdx
│ ├── default-values.mdx
│ └── cascade-behavior.mdx
│
├── 13-transactions-and-concurrency/
│ ├── transaction-fundamentals.mdx
│ ├── begin-commit-rollback.mdx
│ ├── acid-properties.mdx
│ ├── isolation-levels.mdx
│ ├── locks-and-deadlocks.mdx
│ ├── savepoints.mdx
│ └── concurrency-control.mdx
│
├── 14-indexing-and-performance/
│ ├── index-fundamentals.mdx
│ ├── single-and-composite-indexes.mdx
│ ├── unique-and-covering-indexes.mdx
│ ├ ── explain-query-plans.mdx
│ ├── query-optimization.mdx
│ ├── pagination-strategies.mdx
│ └── performance-antipatterns.mdx
│
├── 15-views-routines-and-triggers/
│ ├── views.mdx
│ ├── materialized-views.mdx
│ ├── stored-procedures.mdx
│ ├── user-defined-functions.mdx
│ ├── triggers.mdx
│ └── scheduled-database-tasks.mdx
│
├── 16-security-and-administration/
│ ├── users-and-roles.mdx
│ ├── grants-and-revokes.mdx
│ ├── least-privilege.mdx
│ ├── sql-injection-prevention.mdx
│ ├── parameterized-queries.mdx
│ ├── backup-and-restore.mdx
│ ├── migrations.mdx
│ └── production-checklist.mdx
│
├── 17-application-integration/
│ ├── sql-with-javascript.mdx
│ ├── sql-with-nodejs.mdx
│ ├── sql-with-python.mdx
│ ├── connection-pooling.mdx
│ ├── prepared-statements.mdx
│ ├── transactions-in-applications.mdx
│ └── repository-pattern.mdx
│
├── 18-database-specific-guides/
│ ├── postgresql/
│ │ ├── index.mdx
│ │ ├── psql-basics.mdx
│ │ ├── returning-and-upsert.mdx
│ │ ├── jsonb-and-arrays.mdx
│ │ └── postgres-performance.mdx
│ └── mysql/
│ ├── index.mdx
│ ├── mysql-client-basics.mdx
│ ├── auto-increment-and-upsert.mdx
│ ├── mysql-json.mdx
│ └── mysql-performance.mdx
│
├── 19-projects/
│ ├── student-management-database.mdx
│ ├── library-management-system.mdx
│ ├── employee-analytics.mdx
│ ├── ecommerce-database.mdx
│ ├── inventory-management.mdx
│ └── reporting-dashboard.mdx
│
├── 20-practice/
│ ├── beginner-exercises.mdx
│ ├── intermediate-exercises.mdx
│ ├── advanced-exercises.mdx
│ ├── sql-challenges.mdx
│ ├── quizzes.mdx
│ └── interview-questions.mdx
│
├── reference/
│ ├── sql-cheatsheet.mdx
│ ├── commands-reference.mdx
│ ├── functions-reference.mdx
│ ├── joins-reference.mdx
│ ├── dialect-differences.mdx
│ └── glossary.mdx
│
└── assets/
├── images/
└── diagrams/