PostgreSQL for business intelligence and mass data analysis

PostgreSQL for business intelligence and mass data analysis

Duration: 3 Days
Level: Intermediate
Date: on request
26.09. – 28.09.2016 in Wr. Neustadt, Austria (German)
Audience: During this course you will learn how to use PostgreSQL for business intelligence related tasks. You will learn to right sophisticated SQL and see how the database system can be scaled up to BI needs.

 

Content:

Database Design

  • Preparing data structures for analysis
  • Data structures for data warehousing

Importing data

  • Bulk loading
  • LOGGED vs. UNLOGGED tables
  • Tuning imports

Analytics and windowing functions

  • Simple windows (rank, dense_rank, etc.)
  • Frame clauses and sliding windows
  • Performance tuning

Serverside business logic

  • Including server side modules
  • Data mining with PL/R

Performance tuning

  • PostgreSQL for business intelligence
  • Detecting and optimizing slow queries
  • Optimizing large queries