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
- SQL DDL, SQL Queries, Relational Algebra
- Assertions, Triggers
- SQL/PSM, Embedded SQL, JDBC
- Transactions, Authorization
- Indexes
- XML
- …
| Date | Subject |
|---|---|
| October 31 | lecture1 |
| November 1 | lecture2 |
| November 3 | lecture3 |
| November 7 | lecture4 |
| November 8 | lecture5 |
| November 14 | lecture6 |
| November 15 | lecture7 |
| November 21 | lecture8 |
| November 22 | lecture9 |
| November 28 | lecture10 |
| November 29 | lecture11 |
| December 5 | lecture12 |
| December 6 | lecture13 |
| December 12 | lecture14 |
| December 13 | lecture14 |
Lecture 1, Introduction + The relational data model¶
- Book sections
- |book2e|: 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 3, Functional dependencies, BCNF, 3NF¶
- Book sections
- |book2e|: 3.1-3.5
- Slides:
- Part 1:
one per page,six per page - Part 2:
one per page,six per page
- Part 1:
Lecture 5, SQL 1, Relational Algebra¶
- Book sections
- |book2e|: 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
- |book2e|: 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, Exercises¶
Lecture 8, SQL 4, Relational Algebra¶
- Book sections
- |book2e|: 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 9, Relation Algebra: Exercises¶
- Slides:
Lecture 10, SQL 4, Assertions, Triggers¶
- Book sections
- |book2e|: 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:
- one per page, six per page
- SQL:
Lecture 12, Transactions, Indexes, non-natural keys, denormalization¶
- Book sections
- |book2e|: 6.6, 18.1, 8.3-8.4, 14.1
- Slides:
- Part 1:
one per page,six per page - Part 2:
one per page,six per page
- Part 1:
Lecture 13, XML¶
- Book sections
- |book2e|: 11, 12.1-12.2
- Slides:
- Part 1:
one per page,six per page
- Part 1:
Lecture 14, Preparation Exam¶
- Exam