SQLearnAcademy

Learn

19 modules · 168 lessons

Part 1

Query basics

Reading, filtering, transforming and counting.

5 modules

00Foundations: thinking in data

0/8
Start

01Reading data: SELECT

0/8

02Filtering data: WHERE

0/8

03Functions and data transformation

0/9

04Aggregation and grouping

0/8

Part 2

Multiple tables

Relationships, JOIN, building a schema and changing data.

5 modules

05Data modeling and relationships

0/9

06Combining tables: JOIN

0/10

07Creating and changing schema: DDL

0/10

08Changing data: DML

0/8

09Normalization

0/8

Part 3

Advanced queries and reports

Subqueries, CTEs, window functions and summary reports.

3 modules

10Subqueries and CTEs

0/9

11Window functions and analytics

0/10

12Set operations and reports

0/6

Part 4

Data engineering

Transactions, performance, reliability and scale.

6 modules

13Transactions and integrity

0/9

14Performance and indexes

0/11

15Advanced PostgreSQL features

0/10

16Reliability, security, integrity

0/8

17Scaling and data architecture

0/10

18Production cases and the data engineer's practice

0/9