Goal: The aim of the lesson is to familiarize students with advanced database management concepts and procedure.
Course description: Data and 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. NoSQL databases: types, concepts, architecture, queries. Translating business problems into data. R language.