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.
| Week | Topic |
|---|---|
| Week 1 | Overview | Basic SQ |
| Week 2 | Relational Algebra | Predicate Logic |
| Week 3 | Predicate Logic | Relational Calculus |
| Week 4 | Equivalence of Relational Calculus and Algebra |
| Week 5 | Multisets, aggregation, grouping |
| Week 6 | Subqueries and other bits of SQL |
| Week 7 | Database constraints and entailment |
| Week 8 | Normal forms | SQL constraints and triggers |
| Week 9 | Transactions management |
| Week 10 | SQL in programming languages | The NULL value |
| Week 11 | Exercises 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.
License
All rights reserved The University of Edinburgh