Database Systems in Business Environments Objectives Familiarisation with the application areas of relational database systems in business environments Ability to efficiently design relational databases Ability to formulate complex SQL queries Acquiring basic DBMS administration skills Acquiring basic knowledge of the concepts: data warehouse, OLAP, business intelligence Contents Fundamentals, principles, architectures and applications of relational databases in business environments Data modelling and database designs SQL and database programming Overview of the concepts: data warehouse, OLAP, business intelligence Practical exercises with the relational DBMS PostgreSQL and Oracle
