SQL
SQL for Database Administrator (DBA) on CareerPlane — 10 practical, sandbox-driven topics. Pick a topic to open its interactive lesson.
10 topics
10 topic pages
Topics
SQL Query Basics & DML Operations
Professional · priority 1
sqldatabasedmlselectinsertupdatedelete
SQL Joins & Aggregations (INNER/LEFT/RIGHT/FULL)
Professional · priority 1
sqljoinsgroup-byhavingaggregate
SQL Window Functions (RANK / DENSE_RANK / ROW_NUMBER / LAG / LEAD)
Professional · priority 1
sqlwindow-functionsanalyticsranklaglead
CTEs & Subqueries (WITH Clause / Correlated Subqueries)
Professional · priority 1
sqlctecommon-table-expressionsubqueryrecursive
Query Optimization & EXPLAIN Plans
Professional · priority 1
sqlperformanceexplainexecution-planindex
Indexing Strategies (B-Tree / GIN / GiST / Partial Indexes)
Professional · priority 1
sqlindexb-treeginperformancepostgresql
Schema Design & Normalization (1NF / 2NF / 3NF / BCNF)
Professional · priority 1
sqlschemanormalizationdata-modelinger-diagram
Stored Procedures & Triggers
Professional · priority 1
sqlstored-proceduretriggerplpgsqlautomation
Transactions & ACID Properties (Isolation Levels / Deadlocks)
Professional · priority 1
sqltransactionsacidisolationdeadlockconcurrency
Authentication & Identity Security Infrastructure in Production
Professional · priority 1
sqlauthenticationidentitysecurityrbacrow-level-securityjwt
Keep exploring
- Back to portal — search every topic across every field, career, and subject.
- sitemap.xml — the full crawlable graph of index pages + topic pages.