Home
A History of ADU
Courses
One Course
Faculty and Alumni
Colloquia
|
Database Management Systems
|
![[spacer]](/images/spacer_pixel.gif)
previous | next
|
|
Instructor: Ravi Jasuja
Lecture Videos06-08-01: Overview, Query Processing, Embedded SQL, Cursors, Triggers
06-11-01: Relational Algebra, Relational Calculus
06-12-01: Entity Relationship Diagrams
06-13-01: RDBMS Memory and Disk Storage, RAID, Buffer Management
06-14-01: Unordered/Sorted/Hashed Files, Indexes
06-15-01: Index Sequential Access Method, B+ Trees
06-18-01: Static and Dynamic Hash Indexing
06-19-01: External Sorting, Merge Sort, Double Buffering, Replacement Sort
06-21-01: Query Optimizers, Query Evaluation
06-25-01: Normal Forms
06-26-01: Query Analysis and Optimizing in Oracle
Problem SetsProblem_Set_01.txt Tuning-Project-Extra-Credit.txt Tuning-Project.txt
ExamsExam_02.txt
Links
The solutions
[ postscript
 |
pdf ]
to the odd numbered problems in the text.
Lecture slides to a Database course taught by the text's author.
The Grammar for SQL-92. Not very useful, but interesting nonetheless:
http://www.contrib.andrew.cmu.edu/~shadow/sql/sql2bnf.aug92.txt
|
|
|