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. Introduction to Big data, Hadoop framework, Apache Spark.