</>DevThesis
HomeCurriculumSQL Fundamentals

SQL Fundamentals

Relational query language syntax, Data Manipulation Language (DML), complex joins, subqueries, group aggregations, and window functions.

1DML & DDL Syntax Core Fundamentals

Relational algebra foundations, schema constraints, Volcano iterator execution, and ACID transaction boundaries.

DML & DDL Syntax Core Fundamentals

Master relational algebra mappings, DDL schema integrity constraints, the Volcano iterator query engine, and transactional DML execution.

DML & DDL Syntax Core Fundamentals

Master the relational model foundations, formal relational algebra mappings to SQL DML, DDL schema constraints, Volcano iterator pipelining, and ACID transaction boundaries.

2Relational Joins & Set Operations

Physical join operators, hash joins, sort-merge mechanics, outer joins, and multiset versus set operations.

Relational Joins & Set Operations

Master physical join algorithms, nested loops, two-phase hash joins, sort-merge joins, and set operations under SQL bag semantics.

Relational Joins & Set Operations

Analyze physical join algorithms including Nested Loop, In-Memory Hash Join, Grace Hash Join, and Sort-Merge Join, alongside SQL set semantics and null-safe comparisons.

3Grouping, Aggregations & Having Filtering

Hash vs streaming aggregation, pipeline breaking characteristics, Welford's algorithm, and multi-dimensional rollup cubes.

Grouping, Aggregations & Having Filtering

Understand aggregation execution plans, online single-pass statistical accumulators, WHERE versus HAVING filtering, and multi-dimensional grouping sets.

Grouping, Aggregations & Having Filtering

Explore hash aggregation versus streaming sort aggregation, online variance calculation via Welford's algorithm, optimizer predicate pushdown, and CUBE/ROLLUP multidimensional analysis.

4Advanced Subqueries & SQL Window Functions

Window frame specifications, ranking functions, analytic lag/lead navigation, subquery decorrelation, and sessionization pipelines.

Advanced Subqueries & SQL Window Functions

Master SQL window frames, ranking metrics, analytic navigation, correlated subquery decorrelation into semijoins, and clickstream sessionization.

Advanced Subqueries & SQL Window Functions

Implement production window functions, master partition frame sliding mechanics, evaluate subquery decorrelation into semijoins, and execute single-pass time-series sessionization.