PostgreSQL for business intelligence and mass data analysis
Dates & Duration
See available dates for this course!
If there is no date and time available for a certain training you are interested in, please contact us.
This training can also be held at your place or as online training especially for your company. In this case the course agenda can also be adapted to suit your needs best.Learn more about our customized training >>
This course takes 3 days with 8 hours each (on site) or 4 hours each (online).
The only difference is that there will be less practical exercises in an online course. However, we will hand them over to you and you can still do them on your own and ask our consultants for feedback or help if needed.
During this course you will learn how to use PostgreSQL for business intelligence related tasks. In this workshop you will learn to import, process and effectively analyze large amounts of data. You will learn the basic SQL techniques and how to efficiently model mass data. Additionally, you will learn how to integrate external business logic directly into PostgreSQL.
This course is aimed at data analysts and developers who already know the basics of SQL and who face the challenge of having to deal with complex problems or large amounts of data efficiently.
This course can be held in English and German.
- Preparing data structures for analysis
- Data structures for data warehousing
- Normalization vs. denormalization
- Handling faulty data
- Bulk loading
- LOGGED vs. UNLOGGED tables
- Tuning imports
- GROUP BY and HAVING
- Optimizing aggregations
- Ordered sets and hypothetical aggregates
- Optimizing the order of aggregation
- GROUP SETS (ROLLUP, CUBE, etc.)
Analytics and windowing functions
- Simple windows (rank, dense_rank, etc.)
- Frame clauses and sliding windows
- Performance tuning
- Storing timeseries data efficiently
- Frame clauses and sliding windows
- Anomaly detection
- Partitioned time series
- Timeseries prediction and forecasting
- Optional: Diving into MobilityDB
- Handling and analyzing GPS tracks
- Storing tracking data in PostgreSQL
Serverside business logic
- Including server side modules
- Data mining and external modules
- Writing your own aggregation functions
- 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
GIS ESSENTIALS – „GETTING SPATIALLY ENABLED“
PostgreSQL High Availability & Patroni Cluster Manager
PostgreSQL in Kubernetes
Machine Learning for decision makers
Introduction to Machine Learning
Introduction to PostGIS
PostgreSQL Administration and Performance Tuning
Introduction to SQL
We offer these services
9/5 Basic Support
CYBERTEC 9/5 Basic Support includes all Product Support services and on top also performance tuning and extended troubleshooting. 9/5 means that we’re here for you from Monday to Friday from 9am to 5pm (CET/MEZ). Other timezones on request. CYBERTEC provides all bug fixes for the most used platforms, processors or architectures. This includes not only […]
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 […]