Goal: In the course, students learn the principles and implementation of relational database management, the process of database design and modern data management methods. During the course, students will gain insights into the world of non-relational database management and Big Data, and will become familiar with the concepts, procedures and tools of NoSQL and Big Data data storage.
Course description: Relational data model, relational algebra, RDBMS architecture, logical and physical data model, database design, normal forms. Database management in Oracle environment database instances, memory structures, transactions. Execution planning, optimization, SQL tuning. Index structures, join methods. NoSQL database types and their operation, their relation to Big Data systems. Understanding the use of MongoDB and Cassandra database management systems: basics, architecture, queries. Big data basics and the Hadoop framework. Apache Spark.