# Topic |
Slides |

1. Introduction | [pdf] |

2. Entity-Relationship (ER) Model | [pdf] |

3. Relational Model | [pdf] |

4a. SQL I. | [pdf] |

4a. SQL examples | [pdf] [sql] |

4b. SQL II. | [pdf] |

5. Integrity Constraints | [pdf] [sql] |

6. Functional Dependencies | [pdf] |

7. Normal forms | [pdf] |

8. Schemas | [pdf] [pivot chart] |

9. Database Internals | [pdf] |

10. Query Processing | [pdf] |

11. Query Optimization | [pdf] |

12. Transactions | [pdf] |

13. Two Phase Commit | [pdf] |

14. Replication | [pdf] |

15. Key-value Stores | [pdf] |

16. Security | [pdf] |

17. New hardware | [pdf] |

Date (Solve by) | Topic | Handouts | Slides | Solution |
---|---|---|---|---|

February 23rd/26th | No exercise | |||

March 1st/4th | Entity-Relationship Model | [Ex-1] | [Slides-1] | [Solution-1] |

March 8th/11th | Relational Model | [Ex-2] | [Slides-2] | [Solution-2] |

March 15th/18th | Relational Algebra | [Ex-3] | [Slides-3] | [Solution-3] |

March 22nd | Database Setup |
[Ex-4] [Datasets] |
||

April 5th/8th | SQL | [Ex-5] | [Slides-5] | [Solution-5] |

April 12th/15th | SQL II | [Ex-6] | [Slides-6] | [Solution-6] |

April 19th/22nd | Integrity Constraints | [Slides-7] | [Solution-7] | |

April 26th/29th | Normal Forms I | [Ex-8] | [Slides-8] | [Solution-8] |

May 3rd/6th | Normal Forms II | [Ex-9] | [Slides-9] | [Solution-9] |

May 10th/13th | Query Processing & Query Optimization | [Ex-10] | [Slides-10] | [Solution-10] |

May 17th/20th | Transactions | [Ex-11] | [Slides-11] | [Solution-11] |

May 24th/27th | Two Phase Commit & Replication | [Ex-12] | [Slides-12] | [Solution-12] |

May 31st/June 3rd | Q&A -- Send us questions! | [Slides-13] |