Targets

• Software development
• Business Intelligence
• Database administration
• Database development
• Open-source solutions integration

Topics

• Business intelligence and data warehousing
• Multi-dimensional data modelling
• Horizontal partitioning
• Tablespaces
• Stored procedures
• Views
• Summary navigation
• Loading the data in the warehouse (ETL or ELT?)
• Data warehouse scalability
• Data warehouse high availability

Requirements

• Basics of PostgreSQL database administration
• PostgreSQL basics
• SQL basics
• Basics of PostgreSQL development
• Basics of applications design with PostgreSQL
• Basics of PL/pgSQL
• Advanced PostgreSQL database administration

Course acquired skills

• Advanced database architecture techniques
• Basics of database scalability with PostgreSQL
• Basics of data warehousing
• Basics of multi-dimensional modelling
• Basic optimisation techniques for data warehousing in PostgreSQL