Home
Syllabus
Policies & Grading
» Recording/Copyright
» Campuswire
Class Schedule
Office Hours
Notes & Readings
Recitations
Assignments
» Submit
FAQ
Links
Recitation Handouts
(Note: please visit this page frequently as it will be updated constantly during the term)

Recitation Zoom Details

Dates
Subject
Handout & Scripts
Solution
3 Sep 2021
 Introduction to DB Server and GUI PostgreSQL & DataGrip setup
SQL DDL slides
SQL script
Interfaces quick guide 		N/A
10 Sep 2021
 Relational Model & SQL DDL Recitation 2
SQL script
 Recitation 2 Solution
17 Sep 2021
 SQL DDL & Relational Algebra Recitation 3 RA
Recitation 3 SQL DDL
 Recitation 3 RA Solution
Recitation 3 SQL DDL Solution
24 Sep 2021
 Relational Algebra Recitation 4
 Recitation 4 Solution
1 Oct 2021
 DML (query execution) & Normalization (canonical cover) Recitation 5
 Recitation 5 Solution
8 Oct 2021
 Normalization & E-R Recitation 6 Normalization Exercise
Recitation 6 ER
 Recitation 6 ER Solution
22 Oct 2021
 Advanced SQL DML Recitation 7
Recitation 7 SQL scipt
 Recitation 7 Solution
29 Oct 2021
 Advanced SQL DML, Views, and Temp Tables Recitation 8
Recitation 8 SQL scipt
 Recitation 8 Solution
5 Nov 2021
 Modes of Evaluation & Concurrency Control Recitation 9
 Recitation 9 Solution
12 Nov 2021
 Concurrency Control & Triggers Recitation 10
Recitation 10 SQL scipt
 Recitation 10 Solution
19 Nov 2021
 Procedures/Functions & Cursors & JDBC Recitation 11
JDBC guide
JDBC code Examples
Recitation 11 SQL scipt
 Recitation 11 Solution
3 Dec 2021
 B+Tree Recitation 12
 Recitation 12 Solution
10 Dec 2021
 Final Q&A session Good luck!! N/A

Copyright Panos K. Chrysanthis © 2021 Last updated on December 15, 2021 at 20:31:07 EST