PostgreSQL for business intelligence and big 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 course takes 3 days – 8 hours per day (on site) or 5 hours per day (online).
The only difference is that there will be less practical exercises in an online course. However, we can share them with you so you can do them on your own. You can ask our consultants for feedback or help, if needed.
Summary
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.
Audience
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.
Available Languages
This course can be held in English and German.
COURSE CONTENT
DAY 1
Database Design
- Preparing data structures for analysis
- Data structures for data warehousing
- Normalization vs. denormalization
- Handling faulty data
Importing data
- Bulk loading
- LOGGED vs. UNLOGGED tables
- Tuning imports
Aggregating data
- GROUP BY and HAVING
- Optimizing aggregations
- Ordered sets and hypothetical aggregates
- Optimizing the order of aggregation
- GROUP SETS (ROLLUP, CUBE, etc.)
DAY 2
Analytics and windowing functions
- Simple windows (rank, dense_rank, etc.)
- Frame clauses and sliding windows
- Performance tuning
Timeseries analysis
- 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
DAY 3
Serverside business logic
- Including server side modules
- Data mining and external modules
- Writing your own aggregation functions
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
PostgreSQL Optimization & Security
Is your database not running smoothly or are you struggling with security issues? Our experts will analyze problems & optimization potentials within a health check or security audit.
PostgreSQL Infrastructure
PostgreSQL Setup & Installation, automation with Kubernetes and database architecture: We’ll find the optimal setup and make sure that your PostgreSQL Infrastructure meets your needs and expectations.
PostgreSQL Setup & Installation
Get started with PostgreSQL by using our Setup & Installation service. We fully focus on your personal needs and infrastructure. In addition to the configuration itself, you also benefit from the knowledge of our experts in the field of database design.