Introduction to Database Systems: Lectures
The slides are in PDF and cover the following topics:
-
Introduction
(Slides,
Handouts)
-
Fundamental Concepts
(Slides,
Handouts)
-
Conceptual Modelling
(Slides,
Handouts)
-
The Relational Model
(Slides,
Handouts)
-
Mapping ER Models to Relational Schemas
(Slides,
Handouts)
-
Data Definition and Manipulation in SQL
(Slides,
Handouts)
-
Relational Algebra
(Slides,
Handouts)
-
Queries in SQL
(Slides,
Handouts)
-
Database Access from a Programming Language
(Slides,
Handouts)
-
File Organisation and Indexing
(Slides,
Handouts)
-
Tree-structured Indexes
(Slides,
Handouts)
-
Query Execution
(Slides,
Handouts)
-
Indexes in Database Management Systems: PostgreSQL and Oracle
(Slides,
Handouts)
-
Execution Plans in PostgreSQL
(Slides,
Handouts)
-
Functional Dependencies
(Slides,
Handouts)
-
Normalization
(Slides,
Handouts)
Back to the course homepage