[aduni.org logo] [classroom photo]

Home
A History of ADU
Courses
   One Course
Faculty and Alumni
Colloquia

Course Directory
Math SICP Disc
HCW OOP Alg
Sys Web ToC
AI DB Prob

FAQ  ||  donate  ||  USB drive


 Database Management Systems

[spacer]
   previous | next
 

InstructorRavi Jasuja

Course Description | Lectures and Courseware | Student Evaluations

Lecture Videos

06-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 Sets

Problem_Set_01.txt
Tuning-Project-Extra-Credit.txt
Tuning-Project.txt

Exams

Exam_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


[horizontal rule]

Site last updated: May 14, 2013
Comments? Questions?

Creative Commons License

[spacer]