| Fall 2021 (22-1 or 2221) |
| CS 1555/2055 : Database Management Systems |
| Department of Computer Science University of Pittsburgh |
| Home |
| Syllabus |
| Policies & Grading |
| » Recording/Copyright |
| » Campuswire |
| Class Schedule |
| Office Hours |
| Notes & Readings |
| Recitations |
| Assignments |
| » Submit |
| FAQ |
| Links |
Lectures Zoom Details
| Overview of Database Management Systems | Chapter 1 & 2 from the textbook |
Set #1,
Set #2 4 slides per page |
|
| Overview of Database Management Systems | Chapter 1 & 2 from the textbook |
Set #3 4 slides per page |
|
| Relational Database Model | Chapter 5 from the textbook |
Set #1 4 slides per page |
|
| Relational Database Model | Chapter 5 from the textbook |
Set #2 4 slides per page |
|
| Structured Query Language SQL - DDL | Chapters 6.1-6.2 and 7.4 from the textbook (7th Ed.) |
Set #1 4 slides per page |
|
| Relational Algebra | Chapter 8.1-8.5 from the textbook (7th Ed.) |
Set #1 4 slides per page |
|
| Relational Algebra | Chapter 8.1-8.5 from the textbook (7th Ed.) |
Set #2 4 slides per page |
|
| Relational Algebra | Chapter 8.1-8.5 from the textbook (7th Ed.) |
Set #3 4 slides per page |
|
| SQL DML Introduction | Chapters 6.3-6.6 & 7.1 from the textbook (7th Ed.) |
Set #1 4 slides per page |
|
| SQL DML Introduction | Chapters 6.3-6.6 & 7.1 from the textbook (7th Ed.) |
Set #2 4 slides per page |
|
| DB Design - Normalization | Chapter 14 and Sections 15.2-15.5 from the textbook (7th Ed.) |
Set #1 4 slides per page |
|
| DB Design - Normalization | Chapter 14 and Sections 15.2-15.5 from the textbook (7th Ed.) |
Set #2 4 slides per page |
|
| DB Design - Conceptual Design, ER Model | Chapters 3, 4 and 9 from the textbook (7th Ed.) |
Set #1 4 slides per page |
|
| DB Design - Conceptual Design, ER Model | Chapters 3, 4 and 9 from the textbook (7th Ed.) |
Set #2 4 slides per page |
|
| DB Design - Conceptual Design, ER Model | Chapters 3, 4 and 9 from the textbook (7th Ed.) |
Set #3 4 slides per page |
|
| Nested SQL Queries | Chapters 6.3-6.6 & 7.1 from the textbook (7th Ed.) |
Set #1 4 slides per page |
|
| Nested SQL Queries | Chapters 6.3-6.6 & 7.1 from the textbook (7th Ed.) |
Set #2 4 slides per page |
|
| SQL Views | Chapters 7.2-7.5 from the textbook (7th Ed.) |
Set #1 4 slides per page |
|
| SQL Views | Chapters 7.2-7.5 from the textbook (7th Ed.) |
Set #2 4 slides per page |
|
| SQL Access Control | Chapters 7.2-7.5 from the textbook (7th Ed.) |
Set #1 4 slides per page |
|
| SQL Integrity Constraints | Chapters 7.2-7.5 from the textbook (7th Ed.) |
Set #1 4 slides per page |
|
| SQL Integrity Constraints | Chapters 7.2-7.5 from the textbook (7th Ed.) |
Set #2 4 slides per page |
|
| SQL Transactions | Chapters 7.2-7.5 from the textbook (7th Ed.) |
Set #1 4 slides per page |
|
| Transaction Processing - Concurrency Control | Chapters 20 to 22 from the textbook (7th Ed.) |
Set #1 4 slides per page |
|
| Transaction Processing - Recovery | Chapters 20 to 22 from the textbook (7th Ed.) |
Set #1 4 slides per page |
|
| Transaction Processing - Recovery | Chapters 20 to 22 from the textbook (7th Ed.) |
Set #2 4 slides per page |
|
| DB Programming (ESQL & PLSQL) | Chapters 10-11 from the textbook (7th Ed.) |
Set #1 4 slides per page |
|
| DB Programming (PLSQL) | Chapters 10-11 from the textbook (7th Ed.) |
Set #2 4 slides per page |
|
| DB Programming (PLSQL) | Chapters 10-11 from the textbook (7th Ed.) |
Set #3 4 slides per page |
|
| SQL Injection | Chapters 10-11 from the textbook (7th Ed.) |
Set #4 4 slides per page |
|
| Physical Organization: Storage & Files | Chapters 16 and 17 from the textbook (7th Ed.) |
Set #1 4 slides per page |
|
| Physical Organization: Storage & Files | Chapters 16 and 17 from the textbook (7th Ed.) |
Set #2 4 slides per page |
|
| Physical Organization: Indexing | Chapters 16 and 17 from textbook (7th Ed.) |
Set #1 4 slides per page |
|
| Query Processing & Optimization | Chapters 18.1 & 18.4 and 19.1-19.2 from the textbook (7th Ed.) |
Set #1 4 slides per page |
|
| Big Data, NOSQL, NewSQL and Data Streams | Chapters 24 and 25 from the textbook (7th Ed.) |
Set #1 4 slides per page |
| Copyright Panos K. Chrysanthis © 2021 | Last updated on December 15, 2021 at 20:31:07 EST |