PostgreSQL for Business Intelligence and Mass-data-analysis

TRAINING COURSE

Details

In this workshop you will learn to import, process and effectively analyze large amounts of data. In addition to basic SQL techniques, you will learn more about efficient modeling of mass data. A special part will show you how to integrate external business logic directly into PostgreSQL. More at:

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.

Delivery Methods

Delivery Method Duration
Classroom
3 Days Get a Quote
Live Virtual Training
5 Days Get a Quote

Discounts Available

Brochure:

Download Brochure

Information may change without notice.

Audience

  • Business Intelligence Professionals

Pre-Requisites

  • PostgreSQL knowledge
  • SQL

Course Outline / Curriculum

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

Schedule Dates and Booking

There are currently no scheduled dates.

Add me to the waiting list

Submit Enquiry

Name
Email
Telephone
Query