PostgreSQL Data Warehousing & Partitioning
This course discusses how to design Data Warehouse solutions based on PostgreSQL, starting from the basics and then moving to specific aspects such as partitioning, data loading, scalability and performance optimization for analytic queries. Suitable for application developers, as well as database administrators
Prerequisites
- Basics of PostgreSQL database administration
- PostgreSQL basics
- SQL basics
- Basics of PostgreSQL development
- Basics of applications design with PostgreSQL
Topics
- Business intelligence and data warehousing
- Multi-dimensional data modelling
- Horizontal partitioning
- Tablespaces
- Stored procedures
- Views
- Summary navigation
- Loading the data in the warehouse
- Data warehouse scalability
- Data warehouse high availability
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
Upcoming Training Courses
Trainings in Prato / Milano / Roma, Italy
On hold until further notice due to COVID-19
Additional information:
- The course will be confirmed when three students are enrolled for the Prato office, while for the Milan and Rome offices the course will be confirmed when 4 students are enrolled.
- The registration fee includes: didactic material, 2 coffee breaks per day and lunch.
- Each participant must have a personal laptop.
Tags: Database Administration, Database Development, Business Intelligence, Software development, Open source solutions integration
Length: 1.00 day