Lecture Slides
We will be using the
slides
from the book website with minor modifications.
I Foundations
Chapter 1: Introduction
Chapter 2: ER Model and Conceptual Design
Chapter 3: The Relational Model and SQL DDL
Chapter 4:
Relational Algebra
and
Relational Calculus
Chapter 5: SQL
II Applications
Chapter 6: Database Application Development
PL\SQL
Chapter 7: Database-backed Internet Applications
V Systems
Chapter 16: Overview of Transaction Management
Chapter 17: Concurrency Control
Chapter 18: Recovery
VI Applications
Chapter 19: Schema Refinement, Functional Dependencies, Normalization
Chapter 21: Security and Authorization
Introduction to Semistructured Data and XML
XQuery
Chapter 26: Data Mining
Other material
ER Modeling Exercise