The focus will be on

•       basic architecture of relational databases
•       index structures
•       query processing
•       query optimization
•       transaction management
•       data security
•       non-standard Implementations

What you will you learn? Which questions are answered?

• How to build a relational DB?
• How does query processing work?
• Why do index structures speed up queries? Which index structures are there? What are their advantages / disadvantages? Which one to use?
• Why did we burden students with relational algebra in RDB1 when there is SQL?
• How does relational algebra help in query optimization?
• Which optimization paradigms are there? How do they work?
• Why do database administrators get paid that well?
• What is transaction management for? What has to be done to implement it? What alternatives are there?
• How can you ensure that data is not lost?
• How to harded you DB againt power outages, fires, or earthquakes?
• How else can I implement a relational database?
• ... and many more!

Which pre-requisites are there?

• No special requirements. However, successful participation in Relational Databases 1 is highly recommended.