Goal:
The aim of the lesson is to familiarize students with advanced database management concepts and procedure, and to develop skills for query writing and Big Data analysis.
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.
NonSQL database management system i.e. Cassandra, MongoDB. Big data analysis with Apache Spark.
Database- and Big Data technologies (Cyber Security Engineering MSc, Data Science MSc)