Data Engineering track

SQL Mastery

Joins, window functions, CTEs, query plans, optimization and analytical SQL.

16 concepts8 labs1 projects2 challenges
0%
0% complete
Keep going!
Concepts

Start learning

Work through the concepts in order, or jump to what you need.

1

SQL Query Fundamentals

Concept · Hands-on lab included

2

Joins In Depth

Concept · Hands-on lab included

3

Aggregations and GROUP BY

Concept · Hands-on lab included

4

Window Functions

Concept · Hands-on lab included

5

CTEs and Subqueries

Concept · Hands-on lab included

6

Set Operations

Concept · Hands-on lab included

7

NULLs and Coalescing

Concept · Hands-on lab included

8

String and Date Functions

Concept · Hands-on lab included

9

Advanced Aggregates

Concept · Hands-on lab included

10

Indexes and Query Performance

Concept · Hands-on lab included

11

EXPLAIN and Query Plans

Concept · Hands-on lab included

12

Transactions and Isolation

Concept · Hands-on lab included

13

SQL Anti-Patterns

Concept · Hands-on lab included

14

Schema Design and Constraints

Concept · Hands-on lab included

15

SQL in Warehouses

Concept · Hands-on lab included

16

Analytics Engineering in SQL

Concept · Hands-on lab included

Practice

Hands-on labs

Apply what you've learned in guided, production-style environments.

Browse all labs
Build

Projects

Ship real projects and grow a portfolio that gets you interviews.

Browse all projects
Continue

Next modules

Keep your learning streak going with related modules.