AI & Data

SQL Language in PostgreSQL Database Training

The SQL Language in PostgreSQL Database training is a practical course that comprehensively introduces the world of relational databases using PostgreSQL.

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 Developers and database administrators who want hands-on SQL skills on PostgreSQL.
3 IT specialists responsible for preparing data for analytics and reporting.
4 Individuals with basic programming knowledge and familiarity with tabular data, looking for a solid foundation for further learning PostgreSQL and its advanced features.
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.

✓

Fundamentals of PL/pgSQL programming and data security management.

Program · 6 modules

What we actually do

M01
Module 1: Introduction to PostgreSQL and SQL Basics
  • · Installation and configuration of PostgreSQL environment.
  • · Basic SELECT queries — filtering, sorting, aliases.
  • · Data types, operators, built-in functions.
  • · The role of SQL in data management, characteristics of PostgreSQL.
  • · Working in pgAdmin.
M02
Module 2: Data Manipulation and Basic Structure Creation
  • · DML operations: INSERT, UPDATE, DELETE; handling NULL values.
  • · Creating and modifying tables: CREATE, ALTER, DROP.
  • · Integrity constraints and primary keys.
  • · PostgreSQL data types (e.g., text, numeric, date/time).
M03
Module 3: Advanced SELECT Queries
  • · SELECT filtering (WHERE), sorting (ORDER BY), pagination (LIMIT, OFFSET).
  • · JOINs — internal, external, cross joins, non-standard join methods.
  • · Subqueries — correlated and uncorrelated; using them in different parts of queries.
  • · Set operators and aggregate functions (GROUP BY, HAVING).
M04
Module 4: Analytical and Window Functions
  • · Window functions: ROW_NUMBER, RANK, LEAD, LAG and their applications.
  • · Extended aggregations: ROLLUP, CUBE, GROUPING SETS.
  • · Working with text and date/time functions.
M05
Module 5: Query Optimization and Indexes
  • · Introduction to the Query Planner and optimizer.
  • · Analyzing query plans (EXPLAIN, EXPLAIN ANALYZE).
  • · Creating and choosing indexes — B-tree, hash, GiST, GIN.
  • · Optimization techniques and transaction management.
M06
Module 6: Advanced Objects and PostgreSQL Programming
  • · Views, materialized views, and partitioned tables.
  • · Introduction to PL/pgSQL — functions, procedures, and triggers.
  • · Basics of permission/privilege management and data security
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 →