Spring 2020 (20-2 or 2204)
CS 1555/2055 : Database Management Systems
Department of Computer Science
University of Pittsburgh
Home
Syllabus
Policies & Grading
»
Recording/Copyright
»
Piazza
Class Schedule
Notes Videos & Readings
Recitations
Assignments
»
Submit
»
Project Info
»
System Docs
FAQ
Links
Recitation Notes
(
Note:
please visit this page frequently as it will be updated constantly during the term)
CS1555 Recitation Handouts
DATES
SUBJECT
HANDOUT
SOLUTION
Related Material
8/10 Jan 2020
Introduction to DB Server and GUI
Oracle 12c Server
&
SQL Developer and DataGrip
15/17 Jan 2020
SQL DDL
Recitation 2
Solution of Recitation 2
22/25 Jan 2020
SQL DDL -2-
Recitation 3
Solution of Recitation 3
29/31 Jan 2020
Relational Algebra
Recitation 4
Solution of Recitation 4
5/7 Feb 2020
Relational Algebra -2-
Recitation 5
Solution of Recitation 5
12/14 Feb 2020
SQL
Recitation 6
Solution of Recitation 6
19/21 Feb 2020
Advanced SQL and Views
Recitation 7
Solution of Recitation 7
26/28 Feb 2020
Midterm Review
Reviewed Slides
4/6 Mar 2020
Transactions, Procedures, and Functions
Recitation 8
Solution of Recitation 8
18/20 Mar 2020
Triggers
Recitation 9
Solution of Recitation 9
Your browser does not support the video tag. In MP4:
video to download
25/27 Mar 2020
Normalization
Recitation 10
Solution of Recitation 10
Your browser does not support the video tag. In MP4:
1st video to download
Your browser does not support the video tag. In MP4:
2nd video to download
Your browser does not support the video tag. In MP4:
3rd video to download
1/3 Apr 2020
E-R Diagrams
Recitation 11
Solution of Recitation 11
Your browser does not support the video tag. In MP4:
1st video to download
Your browser does not support the video tag. In MP4:
2nd video to download
8/10 Apr 2020
Static and Dynamic Hashing
Recitation 12
Solution of Recitation 12
Your browser does not support the video tag. In MP4:
1st video to download
Your browser does not support the video tag. In MP4:
2nd video to download
15/17 Apr 2020
B+Tree
Recitation 13
Solution of Recitation 13
Your browser does not support the video tag. In MP4:
video to download
Copyright
Panos K. Chrysanthis
&
Costantinos Costa
© 2020
Last updated on April 25, 2020 at 13:04:46 EST