IDB: Introduction to Databases

Welcome to Introduction to Databases (IDB).

Please note that the schedule below is tentative and may be subject to change during the course.

WeekTopic
Week 1Overview | Basic SQL
Week 2Relational Algebra
Week 3Predicate Logic | Relational Calculus | Equivalence of RC and RA
Week 4Multisets (including RA on bags) | Aggregation and Grouping
Week 5Subqueries and other bits of SQL
Week 6Database constraints and entailment
Week 7Normal forms | SQL constraints and triggers
Week 8Transactions management
Week 9-10SQL in programming languages | The NULL value
Week 11Exercises in preparation for the exam

Advanced Topics

One or more of the following may be covered if time allows:

  • Deductive Databases
  • Incomplete Information
     

Files

Introduction
Basic SQL
Relational Algebra
Predicate Logic
Relational Calculus
Equivalence of Relational Calculus and Algebra
Multisets (including RA on bags)
Aggregation and Grouping
License
All rights reserved The University of Edinburgh