Goal: The aim of the lesson is to familiarize students with advanced database management
concepts and procedure, and to develop skills for query writing.
Course description: Relational data models, relational algebra, SQL deep dive. Logical and physical data
model, relations. RDBMS design, dependencies, constraints, normal forms,
normalization. Triggers and constrains in SQL. Database fundamentals, instance
definition, memory structures in db. Transactions. Index types, hashes. SQL tuning.