PostgreSQL for Business Intelligence and Mass-data-analysis

TRAINING COURSE

Details Audience and Pre-Requisites Course Outline / Curriculum Schedule Dates and Booking Enquiry

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
Instructor-led classroom-based training. Classes are scheduled at various conference centres in the Sandton area or your premises. Stationary and printed manuals or online resources are included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided. Training is between 9 am to 4 pm.
Classroom
3 Days Get a Quote
Live Virtual Training
This course is delivered live via Microsoft Teams. You will be able to see and hear the instructor, view their whiteboard, and ask questions or communicate in the chat. Attend from the comfort of your own home or private office.
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