PostgreSQL Data Warehousing & Partitioning

Learn about the concepts of data warehousing and partitioning

Prerequisites Topics Acquired skills

• 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

• 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

• 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

Tags: Database Development, Open source solutions integration, Software development, Business Intelligence, Database Administration

Code: PGDWPEN
Length: 1 days
Price: £ 600


Stay in touch with us

Subscribe to our monthly newsletter to hear the latest developments from 2ndQuadrant and related technologies.

We’ll also send you any important news or updates that we think you’ll find useful.

We value your privacy and will not pass your details on to anyone else.