CareerPlane subject · v1
portal
subject · Database Administrator (DBA)

SQL

SQL for Database Administrator (DBA) on CareerPlane — 10 practical, sandbox-driven topics. Pick a topic to open its interactive lesson.

10 / topics
in the subject
10 / pages
topic pages
L1 / priority
core fundamentals

Topics in SQL

10 topics · 10 pages
TOPIC · 01

SQL Query Basics & DML Operations

priority 1 Professional sqldatabasedmlselectinsertupdatedelete
TOPIC · 02

SQL Joins & Aggregations (INNER/LEFT/RIGHT/FULL)

priority 1 Professional sqljoinsgroup-byhavingaggregate
TOPIC · 03

SQL Window Functions (RANK / DENSE_RANK / ROW_NUMBER / LAG / LEAD)

priority 1 Professional sqlwindow-functionsanalyticsranklaglead
TOPIC · 04

CTEs & Subqueries (WITH Clause / Correlated Subqueries)

priority 1 Professional sqlctecommon-table-expressionsubqueryrecursive
TOPIC · 05

Query Optimization & EXPLAIN Plans

priority 1 Professional sqlperformanceexplainexecution-planindex
TOPIC · 06

Indexing Strategies (B-Tree / GIN / GiST / Partial Indexes)

priority 1 Professional sqlindexb-treeginperformancepostgresql
TOPIC · 07

Schema Design & Normalization (1NF / 2NF / 3NF / BCNF)

priority 1 Professional sqlschemanormalizationdata-modelinger-diagram
TOPIC · 08

Stored Procedures & Triggers

priority 1 Professional sqlstored-proceduretriggerplpgsqlautomation
TOPIC · 09

Transactions & ACID Properties (Isolation Levels / Deadlocks)

priority 1 Professional sqltransactionsacidisolationdeadlockconcurrency
TOPIC · 10

Authentication & Identity Security Infrastructure in Production

priority 1 Professional sqlauthenticationidentitysecurityrbacrow-level-securityjwt
Keep exploring
Back to portal — search every topic across every field, career, and subject. Or browse the full sitemap.xml graph of index + topic pages.