To wersja testowa nowego serwisu infoShare Academy — wyświetlane treści i oferta nie są wiążące ani kompletne

Data

SQL language in the PostgreSQL database

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

Duration
24h · 3 days
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

Day 1: SQL Basics and Working with Data

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).

Day 2: Advanced Queries and Aggregations

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.

Day 3: Optimization and Advanced Techniques

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

How we handle your data

We process your business data (name, work e-mail, phone number, company, job title) in order to handle your corporate training inquiry and prepare an offer. The data controller is infoShare Academy Sp. z o.o., Al. Grunwaldzka 472B, 80-309 Gdańsk. Providing the data is voluntary but necessary to receive a response. You have the right to access, rectify, erase or restrict the processing of your data and to object to it. Full information is available in our data processing notice.

Optional marketing consents

The controller of your personal data is infoShare Academy sp. z o.o. The rules for processing personal data are set out in the Privacy Policy and the Data Processing Notice.

Other programs for teams

See all →
Data

Active Directory

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

16h · 2 days →
Data

AI SQL Developer

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

24h · 3 days →
Data

Amazon Redshift - Introductory Training

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

16h · 2 days →