February 2027
Sun
Mon
Tue
Wed
Thu
Fri
Sat
31
1
Normalization 1NF–BCNF
2
3
SQL DDL & SELECT Basics Textbook 6.1-6.2
4
5
SQL Joins Inner, Outer, Semi, Anti
6
7
8
Aggregation, GROUP BY, HAVING Textbook 6.4
9
10
Subqueries Correlated, EXISTS, IN
11
12
CTEs (WITH) PostgreSQL 7.8
13
14
15
Window Functions I OVER, PARTITION BY
16
17
Window Functions II Frames, LAG/LEAD
18
19
Recursive Queries WITH RECURSIVE
Paper: Hirn & Grust 2023
20
21
22
Views, Constraints, Triggers Textbook 7-8
23
24
Python + psycopg + pandas
25
26
DuckDB + Notebooks + Viz
27
28
1
2
3
4
5
6