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.
- Teacher: Noboa Erick
- Teacher: Rita Fleiner
Credit value: 4
Fields of knowledge: Informatika és technológia
Course host institution: Óbudai Egyetem