Home
Syllabus
Policies & Grading
» Recording/Copyright
» Piazza
Class Schedule
Office Hours
Notes Videos & Readings
» Section I
» Section II
Recitations
Assignments
» Submit
» Project Info
FAQ
Links
Section I: Class Notes, Videos, and Reading Guide
(Note: please visit this page frequently as it will be updated constantly during the term)

Lectures Zoom Details

Dates
Topic
Reading
Slides
Video Sec I
20 Aug 2020
 Introduction to Database Systems Chapter 1 & 2 from the textbook 1 slide per page
4 slides per page
25 Aug 2020
 Introduction to Database Systems Chapter 1 & 2 from the textbook 1 slide per page
4 slides per page
27 Aug 2020
 Introduction to Database Systems Chapter 1 & 2 from the textbook 1 slide per page
4 slides per page
Relational Database Model Chapter 5 from the textbook 1 slide per page
4 slides per page
1 Sept 2020
 Relational Database Model Chapter 5 from the textbook 1 slide per page
4 slides per page
3 Sept 2020
 Relational Database Model Chapter 5 from the textbook 1 slide per page
4 slides per page
Structured Query Language SQL - DDL Chapters 6.1-6.2 and 7.4 from the textbook (7th Ed.) 1 slide per page
4 slides per page
8 Sept 2020
 Structured Query Language SQL - DDL Chapters 6.1-6.2 and 7.4 from the textbook (7th Ed.) 1 slide per page
4 slides per page
10 Sept 2020
 Relational Algebra Chapter 8.1-8.5 from the textbook (7th Ed.) 1 slide per page
4 slides per page
15 Sept 2020
 Relational Algebra Chapter 8.1-8.5 from the textbook (7th Ed.) 1 slide per page
4 slides per page
17 Sept 2020
 Relational Algebra Chapter 8.1-8.5 from the textbook (7th Ed.) 1 slide per page
4 slides per page
22 Sept 2020
 SQL DML Introduction Chapters 6.3-6.6 & 7.1 from the textbook (7th Ed.) 1 slide per page
4 slides per page
24 Sept 2020
 SQL DML Introduction Chapters 6.3-6.6 & 7.1 from the textbook (7th Ed.) 1 slide per page
4 slides per page
29 Sept 2020
 Nested SQL Queries Chapters 6.3-6.6 & 7.1 from the textbook (7th Ed.) 1 slide per page
4 slides per page
1 Oct 2020
 SQL Views Chapters 7.2-7.5 from the textbook (7th Ed.) 1 slide per page
4 slides per page
6 Oct 2020
 SQL Access Control Chapters 7.2-7.5 from the textbook (7th Ed.) 1 slide per page
4 slides per page
SQL Integrity Constraints Chapters 7.2-7.5 from the textbook (7th Ed.) 1 slide per page
4 slides per page
8 Oct 2020
 SQL Transactions Chapters 7.2-7.5 from the textbook (7th Ed.) 1 slide per page
4 slides per page
15 Oct 2020
 SQL Programming (PLSQL) Chapters 10-11 from the textbook (7th Ed.) 1 slide per page
4 slides per page
20 Oct 2020
 SQL Programming (PLSQL & Embedded SQL) Chapters 10-11 from the textbook (7th Ed.) 1 slide per page
4 slides per page
22 Oct 2020
 SQL Programming (Embedded SQL & JDBC) Chapters 10-11 from the textbook (7th Ed.) 1 slide per page
4 slides per page
27 Oct 2020
 SQL Programming (JDBC) Chapters 10-11 from the textbook (7th Ed.) 1 slide per page
4 slides per page
29 Oct 2020
 DB Design - Normalization Chapter 14 and Sections 15.2-15.5 from the textbook (7th Ed.) 1 slide per page
4 slides per page
3 Nov 2020
 DB Design - Normalization Chapter 14 and Sections 15.2-15.5 from the textbook (7th Ed.) 1 slide per page
4 slides per page
5 Nov 2020
 DB Design - Conceptual Design, E-R Model Chapters 3, 4 and 9 from the textbook (7th Ed.) 1 slide per page
4 slides per page
10 Nov 2020
 DB Design - Conceptual Design, E-R Diagrams Chapters 3, 4 and 9 from the textbook (7th Ed.) 1 slide per page
4 slides per page
12 Nov 2020
 ER/EER Diagrams Chapters 3, 4 and 9 from the textbook (7th Ed.) 1 slide per page
4 slides per page
Physical Organization: Storage & Files Chapters 16 and 17 from the textbook (7th Ed.) 1 slide per page
4 slides per page
17 Nov 2020
 Physical Organization: Indexing Chapters 16 and 17 from textbook (7th Ed.) 1 slide per page
4 slides per page
19 Nov 2020
 Transaction Processing - Concurrency Control Chapters 20 to 22 from the textbook (7th Ed.) 1 slide per page
4 slides per page
Transaction Processing - Recovery Chapters 20 to 22 from the textbook (7th Ed.) 1 slide per page
4 slides per page

Copyright Panos K. Chrysanthis & Constantinos Costa © 2020 Last updated on January 18, 2021 at 21:41:11 EST