Lectures¶
The slides do not cover everything that is said and given during the lectures. But they should contain enough of the technical material so that you can prepare for the exam if you need to skip some lectures. To get the full coverage, attend the lectures and read the Course Book.
Slides and notes from previous periods can be found here:
Course Plan¶
The course will contain:
- Relational model, E-R diagrams
- Functional dependencies
- Normalization, BCNF, Multivalued dependencies, 3NF, 4NF
- SQL DDL, SQL Queries, Relational Algebra
- Assertions, Triggers
- SQL/PSM, Embedded SQL, JDBC
- Transactions, Authorization
- Indexes
- XML
- …
| Date | Subject |
|---|---|
| November 1 | Lecture 1, Introduction + The relational data model |
| November 2 | Lecture 2, E-R diagrams |
| November 4 | Lecture 3, Functional dependencies, BCNF, 3NF |
| November 8 | Lecture 4, Independencies, 4NF |
| November 9 | Design recap quiz |
| November 15 | Lecture 5, SQL 1, Relational Algebra |
| November 16 | Lecture 6, SQL 2, Relational Algebra, Views |
| November 22 | Lecture 7, SQL 3, Relational Algebra |
| November 23 | Lecture 8, SQL 4, Assertions, Triggers |
| November 29 | Lecture 9, JDBC, SQL Injection, Authorization |
| November 30 | Lecture 10, Transactions |
| December 6 | Lecture 11, Indexes, non-natural keys, denormalization |
| December 7 | Lecture 12, XML and NoSQL |
| December 13 | Lecture 13, Databases at Recorded Future (guest lecture by Jan Sparud, Recorded Future) |
Lecture 1, Introduction + The relational data model¶
- Book sections
- Database Systems: The Complete Book, second edition: 1, 2.2, 3.3.1-2
- Slides:
- Part 1:
one per page,six per page - Part 2:
one per page,six per page
- Part 1:
Lecture 2, E-R diagrams¶
- Book sections
- Database Systems: The Complete Book, second edition: 4.1-4.6
- Slides:
Lecture 3, Functional dependencies, BCNF, 3NF¶
- Book sections
- Database Systems: The Complete Book, second edition: 3.1-3.5
- Slides:
- Part 1:
one per page,six per page - Part 2:
one per page,six per page
- Part 1:
Lecture 4, Independencies, 4NF¶
- Book sections
- Database Systems: The Complete Book, second edition: 3.6
- Slides:
Design recap quiz¶
- Slides:
- Kahoots:
Lecture 5, SQL 1, Relational Algebra¶
- Book sections
- Database Systems: The Complete Book, second edition: 2.3-2.5, 6.1-6.5, 5.1-5.2, 7.1-7.2, 7.4-7.5, 8.1-8.2, 9.4
- Slides:
- SQL:
Lecture 6, SQL 2, Relational Algebra, Views¶
- Book sections
- Database Systems: The Complete Book, second edition: 2.3-2.5, 6.1-6.5, 5.1-5.2, 7.1-7.2, 7.4-7.5, 8.1-8.2, 9.4
- Slides:
- SQL:
Lecture 7, SQL 3, Relational Algebra¶
- Book sections
- Database Systems: The Complete Book, second edition: 2.3-2.5, 6.1-6.5, 5.1-5.2, 7.1-7.2, 7.4-7.5, 8.1-8.2, 9.4
- Slides:
- SQL:
Lecture 8, SQL 4, Assertions, Triggers¶
- Book sections
- Database Systems: The Complete Book, second edition: 2.3-2.5, 6.1-6.5, 5.1-5.2, 7.1-7.2, 7.4-7.5, 8.1-8.2, 9.4
- Slides:
- SQL:
- Kahoot:
Lecture 9, JDBC, SQL Injection, Authorization¶
- Book sections
- Database Systems: The Complete Book, second edition: 9.5-9.6, 10.1
- Slides:
Lecture 10, Transactions¶
- Book sections
- Database Systems: The Complete Book, second edition: 6.6, 18.1
- Slides:
Lecture 11, Indexes, non-natural keys, denormalization¶
- Book sections
- Database Systems: The Complete Book, second edition: 8.3-8.4, 14.1
- Slides:
Lecture 12, XML and NoSQL¶
- Book sections
- Database Systems: The Complete Book, second edition: 11, 12.1-12.2
- Slides:
- Part 1:
one per page,six per page - Part 2:
one per page,six per page
- Part 1: