Week | Date | Description |
Material
|
W02 | 01/18/2019 | Recitation 01 Objective: To practice the relational model and SQL DDL - Working with PostgreSQL using DataGrip |
|
W03 | 01/25/2019 | Recitation 02 Objective: To practice ER diagrams and transforming them to relational schemas. |
|
W04 | 02/01/2019 | Recitation 03 Objective: To practice normalization, canonical forms, decomposing relations into BCNF and checking for lossless decompositions. |
|
W05 | 02/08/2019 | Recitation 04 Objective: To practice relational algebra. |
|
W06 | 02/15/2019 | Recitation 05 Objective: 1. To practice more relational algebra, especially aggregations, joins, and division. 2. To practice SQL queries. |
|
W07 | 02/22/2019 | Recitation 06 Objective: To practice more SQL queries on Postgres. |
|
W08 | 03/14/2019 | Recitation 07 Objectives: 1. To get started with JDBC and demonstrate transaction concurrency control on PostgreSQL 2. To practice Views |
|
W09 | 03/21/2019 | Recitation 08 Objectives: 1. To understand how triggers work in PostgreSQL and to practice writing triggers |
|
W10 | 03/29/2019 | Recitation 09 Objectives: 1. Constraint Evaluation Modes and Transactions |
|
W11 | 04/05/2019 | Recitation 10 Objectives: 1. Practice operations on static hashing, extendible hashing and B+-tree |
|
W12 | 04/12/2019 | Recitation 11 Objectives: 1. Practice Concurrency Control, Recovery |