Visual Calendar — Spring 2027

Month view of every class day, exam, quiz, and the review day. For full topic details see the Schedule page.

Legend

§1 Foundations
§2 SQL Mastery
§3 Programming & Tools
§4 Storage & Indexing
§5 Query Processing
§6 Transactions
§7 Distributed & Modern
Exam
Quiz
Paper Discussion
No Class
January 2027
Sun
Mon
Tue
Wed
Thu
Fri
Sat
27
28
29
30
31
1
2
3
4
5
6
7
8
9
10
11 Course Introduction Syllabus, repo tour
12
13 History of Databases Codd 1970, Textbook Ch. 1
14
15 Relational Model & Data Types Textbook 2.1-2.3
16
17
18 Martin Luther King Jr. Day — no class
19
20 Relational Algebra I Select, Project, Sets
21
22 Relational Algebra II Joins, Division
23
24
25 ER Modeling Textbook 4.1-4.5
26
27 ER-to-Relations Textbook 4.5-4.6
28
29 Functional Dependencies Closure, Keys
30
31
1
2
3
4
5
6
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
March 2027
Sun
Mon
Tue
Wed
Thu
Fri
Sat
28
1 Storage Hierarchy Disks, SSDs, Pages
2
3 Exam 1 Weeks 1-8
4
5 Buffer Management Textbook 13.5-13.6
6
7
8 Row vs Column Stores Paper: C-Store (VLDB 2005)
9
10 B+ Trees I Search, Bulk Loading
11
12 B+ Trees II Insert, Delete, Cost
13 Spring break
14 Spring break
15 Spring break
16 Spring break
17 Spring break
18 Spring break
19 Spring break
20 Spring break
21
22 Hash Indexes Extendible, Linear
23
24 PostgreSQL Index Types GiST, GIN, BRIN
25
26 External Sorting Textbook 15.4 Quiz (Sections 1-4)
27
28
29 Joins I Nested Loop, Block NL
30
31 Joins II Sort-Merge, Hash, Grace
1
2
3
April 2027
Sun
Mon
Tue
Wed
Thu
Fri
Sat
28
29
30
31
1
2 Iterator (Volcano) Model
3
4
5 Vectorized Execution & Optimization I Textbook 16.1-16.2
6
7 Optimization II Cost Est., System R Paper: Leis 2015
8
9 Transactions & ACID Serializability Drop/withdrawal deadline
10
11
12 Exam 2 Sections 4-5
13
14 Two-Phase Locking Deadlocks
15
16 MVCC & Snapshot Isolation Timestamps
17
18
19 Recovery (WAL, ARIES) + Distributed & Modern Papers: ARIES, DuckDB
20
21 Final Exam Review Questions
22 Reading day
23 Reading day
24 Finals week begins
25 Finals week
26 Finals week
27 Finals week
28 Final Exam (Exam 3) date and time per UF final exam schedule
29 Finals week
30 Finals week
1

Final Exam (Exam 3): during finals week (April 24-30), at the time set by the UF final exam schedule.


back