Course Instructor: Ciprian-Octavian Truică

This course focuses on data storage and processing technologies. It makes a transition from Relational Databases on a single instance to the distributed NoSQL used in Big Data. The course is divided into 2 sections. In the first part of the course, we will discuss relational databases from the point of view of architecture design and data processing using procedural languages for both operational databases (OLTP) and data warehouses (OLAP ). The second part of the course focuses on the field of Big Data and NoSQL storage technologies. We will discuss the main classes of NoSQL databases from the point of view of both architecture implementation and data processing languages.

Syllabus:

• Oracle PL/SQL Language
• Data Warehouses and OLAP
• Microsoft SQL Server Architecture, Query Language, and Transact-SQL
• PostgreSQL Architecture, Query Language, and PL/pgSQL
• Big Data
• NoSQL Movement
• Key-Value Databases
• Riak Database
• Document-Oriented Databases
• MongoDB Database
• Wide-Column Databases
• Apache Cassandra Database