Goal: The aim of the lesson is to familiarize students with advanced database management concepts and procedure.
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. NoSQL databases: types, concepts, architecture, queries. MongoDB and Cassandra. Introduction to Big data, Hadoop framework, Apache Spark. Streaming and batch processing in Spark.