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 | Predicate Logic
Week 3Predicate Logic | Relational Calculus
Week 4Equivalence of Relational Calculus and Algebra
Week 5Multisets, aggregation, grouping
Week 6Subqueries and other bits of SQL
Week 7Database constraints and entailment
Week 8Normal forms | SQL constraints and triggers
Week 9Transactions management
Week 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:

  • Data Storage and Indexing
  • Query Processing
  • Incomplete Information
  • Deductive Databases.
     

Files

Introduction
Basic SQL
Relational Algebra
Predicate Logic
License
All rights reserved The University of Edinburgh