[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

previous | next

Instructor: Ravi 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

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?