1 Background
2 Teaching Philosophy
3 Teaching Material
Topic | Learning objectives |
Python (Part 1, videos and/or 5.5.) | Basics, functions, functional programming |
IMDb (Part 1, 7.5.) | Data modeling, relational model |
Python (Part 2, videos and/or 12.5.) | Object-orientation, unit tests and automatic testing |
IMDb (Part 2, 14.5.) | Relationale algebra |
NSA (Part 1, 28.5.) | Introduction to SQL |
NSA (Part 2, 4.6.) | Analytical SQL, big data arithmetics, big data vs privacy, counter-measures |
Query optimization (Part 1, 18.6.) | Automatic query optimization, physical operators, heuristic optimization |
Query optimization (Part 2, 25.6.) | Cost-based optimization, join order, plan variants, pipelining, physical optimizations |
Trade, banks, ticket system (Part 1, 2.7.) | Database management system (DBMS), transactions, serializability theory |
Trade, banks, ticket system (Part 2, 9.7.) | Two-phase locking (2PL), isolation-levels |
Summary (16.7.) |