CareerPlane subject · v1
portal
subject · Data Engineer

SQL

SQL for Data Engineer on CareerPlane — 6 practical, sandbox-driven topics. Pick a topic to open its interactive lesson.

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

Topics in SQL

06 topics · 06 pages
TOPIC · 01

SQL for Data Engineering (Window Functions / Analytical Queries)

priority 1 Professional sqldata-engineeringanalyticswindow-functionsetl
TOPIC · 02

Advanced SQL for ETL Pipelines (MERGE / UPSERT / COPY)

priority 1 Professional sqletlmergeupsertcopybulk-loadpipeline
TOPIC · 03

SQL SELECT & WHERE — Filtering, Operators, NULL Handling

priority 1 Professional sqlselectwherenulloperators
TOPIC · 04

SQL Joins — INNER / LEFT / RIGHT / FULL + Anti-Joins

priority 1 Professional sqljoinsinnerleftrightanti-join
TOPIC · 05

CTEs & Recursive Queries — WITH Clause / Hierarchies / Graph Walks

priority 1 Professional sqlcterecursivewithhierarchygraph
TOPIC · 06

Star Schema Modeling — Facts, Dimensions, SCD Type 2 / 4

priority 1 Professional sqlstar-schemadimensional-modelingscdkimballfacts
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.