AI & Data

SQL Language for Analysts in PostgreSQL Training

The SQL Language for Analysts in PostgreSQL – advanced topics training is an intensive 2-3 day workshop aimed at data analysts and specialists who want to deepen their skills in working with data in a PostgreSQL environment.

Duration
6h
Ask about the program → See all
Who it's for

Ideal for teams that…

1 Data analysts and BI developers working with PostgreSQL who want to develop the ability to write advanced SQL queries.
2 SQL programmers and database administrators seeking knowledge of optimization and advanced techniques for working with large datasets.
3 IT specialists responsible for preparing data for analytics and reporting.
4 People using PostgreSQL in their daily work and wanting to process complex data effectively.
Outcomes after the program

Hands-on AI and data analytics workshops — built around your team's real cases.

✓

How to create and optimize advanced SQL queries in a PostgreSQL environment.

✓

How to use analytical and aggregate functions, complex expressions, and subqueries.

✓

Effective handling of large and complex datasets, including JSON data and partitioned tables.

✓

How to analyze query execution plans and apply best practices in optimization.

✓

Understanding of transaction mechanisms and data security in PostgreSQL.

Program · 3 modules

What we actually do

M01
Day 1: Advanced Queries and Analytical Functions
  • · One-to-one, one-to-many, many-to-many joins, and non-equijoin joins
  • · Logical operators and advanced conditional expressions (CASE, COALESCE, NULLIF)
  • · Correlated and uncorrelated subqueries in SELECT, FROM, and WHERE clauses
  • · Working with CTEs (Common Table Expressions)
  • · Grouping functions (SUM, AVG, COUNT, MAX, MIN)
  • · Advanced grouping (ROLLUP, CUBE, GROUPING SETS)
  • · Window functions and analytical windows (ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, FIRST_VALUE, LAST_VALUE)
  • · Grouping strings with STRING_AGG and using regular expressions
  • · Hierarchical data processing using recursive CTEs
M02
Day 2: Data Processing and Handling Distributed Structures
  • · Handling JSON and JSONB in PostgreSQL – functions and operators
  • · Schema creation and relationships in the database
  • · Temporary tables, materialized views, and table partitioning
  • · Efficient INSERT, UPDATE, DELETE, and MERGE operations
  • · Transactional behavior, locking, and isolation levels in PostgreSQL
  • · Error handling and nested transactions
  • · Data archiving strategies and removing old records
M03
Day 3: Query Optimization and Advanced PostgreSQL Features
  • · Interpreting EXPLAIN and EXPLAIN ANALYZE outputs
  • · Indexes: types, usage, functional, unique, and partial indexes
  • · Performance impact of indexes and server parameter tuning
  • · Autovacuum – configuration, monitoring, and optimization
  • · Working with information schemas and advanced database management
  • · Advanced PL/pgSQL features (optional)
Every module is adapted to your stack and context. The above is a starting point — not a fixed agenda.
How we work

From brief to retro in 30 days.

01

Brief & diagnosis

A call with the team lead + a short survey for participants. We define goals, gap and context.

02

Program customization

We adapt modules, case studies and code examples to your stack. Approval in 5 days.

03

Workshop

Trainer-led sessions, hands-on, code review. Mentor available between sessions too.

04

Retro + report

Outcome report for the team and lead. 30 days of consulting included.

Inquiry

Send a brief. We'll reply within 1 day.

After a short brief we'll prepare a program and a quote. No obligations — it's just a starting point.

✓Quote within 48h of the brief
✓First session within 30 days
✓Pilot before the full decision
✓VAT invoice, payment in instalments possible

Ochrona antyspamowa (Cloudflare Turnstile) zostanie aktywowana po wpięciu klucza.

Other programs for teams

See all →
AI & Data

Active Directory Training

Hands-on AI and data analytics workshops — built around your team's real cases.

AI & Data →
AI & Data

Advanced Power BI Training

Hands-on AI and data analytics workshops — built around your team's real cases.

AI & Data →
AI & Data

Advanced RPA Developer Training

Hands-on AI and data analytics workshops — built around your team's real cases.

AI & Data →