PostgreSQL for business intelligence and mass data analysis

Level:

Intermediate

Date:

28.05 - 30.05.18

Duration:

3 Days

Sign up for this course

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.

Contents of this course

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
Sign up for this course