Advanced Database Systems and Data Warehouses IS-FCS-00028

Description:
1. Procedural SQL. 2. Advanced database objects: trigger, sequence, function, package. 3. Introduction to data warehouses. 4. Dimensional data model in data warehouses. 5. Data warehouses operations: advanced SQL (e.g., ROLLUP, GROUPING SETS, CUBE, PIVOT). 6. Advanced SQL: analytic functions. 7. Query optimization in practice. 8-9. Data integration in data warehouses. 10-11. NoSQL databases: key-value databases, column databases, document-oriented databases, graph databases. 12-13. Large-scale data analysis with Bayesian networks. 14-15. Map-reduce in distributed databases.

Requirements:
SQL, rational database model.