MainPage

Lecturing

Research

Professional

ACS 565  Lecture  Notes

Chapter   1 - Introduction to Database Systems
Chapter   2 - ER Model - Conceptual Design
Chapter   3 - Relational Model - SQL DDL
Chapter   4 - Relational Algebra and Calculus
Chapter   5 - SQL - DML
Chapter  6 -  Database Application Development
Chapter  7 -  Database-Backed Internet Development
Chapter  8  - Overview of Storage and Indexing
Chapter   9 - Data  Storage
Chapter  10 - Tree indexes
Chapter 11 - Hash Indexes
Chapter 12 - Overview of Query Evaluation
Chapter  13 - External Sorting
Chapter  1 4 - Evaluation of Relational Operators - Joins & Others
Chapter  15 - Typical Relational Optimizer
Chapter  16 -  Transaction Management
Chapter  17  - Concurrency Control
Chapter  18  - Crash  Recovery
Chapter  19  - Schema Refinement, FDs, Normalization
Chapter  20  - Physical DB Design, Tuning
Chapter  21  - Security and Authorization
Chapter  22  - Parallel and Distributed DBs
Chapter  23  -Object-Database Systems
Chapter  24  - Deductive Databases
Chapter  25  - Warehousing and Decision Support
Chapter  26  - Data Mining
Chapter  27  - Information Retrieval & XML Data Management
Chapter  28  - Spatial Databases
Chapter  29  - Further Reading