PostgreSQL for business intelligence and mass data analysis

Level:

Intermediate

Date:

On demand

Duration:

3 days

Dates

PostgreSQL trainings and workshops can be held at your location – and anywhere else in the world. We also offer every training as an online training. Please contact us for details. Contact >>

Contact us to 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 write 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

 

Contact us to sign up for this course >>