PostgreSQL for business intelligence and mass data analysis
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 >>
Other courses that might interest you
We offer these services
9/5 Dedicated DBA
CYBERTEC 9/5 Dedicated DBA support service includes a dedicated CYBERTEC expert who remotely takes care of your databases. We will handle any issues before you would even notice them and proactively inform you about possible future problems and needed actions. 9/5 means that your DBA is here for you from Monday to Friday from 9am […]
CYBERTEC Partner Network (CPN)
PostgreSQL expertise for your product portfolio The perfect solution for resellers and software retailers Are you a system house or a software retailer that offers PostgreSQL to its customers instead of or next to other database systems? Do you need a competent partner, with lots of experience, sophisticated services, solutions and products? Join the […]
Support for Reseller
These support packages are intended for resellers only. Please contact us, if you are a reseller and do not find a fitting package for your needs. Contact us >> 3rd-Level Support 3rd-Level Support is addressed to companies who sell products (hardware or software) to their customers that use PostgreSQL as database. This support variant ensures […]