Introduction to PostgreSQL

Course code: INTRSQL

This workshop has been designed for people who want to get familiar with SQL and PostgreSQL. You will learn how to use PostgreSQL and how to write proper SQL statements. We start with basic topics like normalization, foreign keys and work our way step by step to topics like joins, subselects, analytics and co. The aim is to teach the participants SQL needed for working with PostgreSQL using practical examples and thus give them the tools for their daily work.

Designed for the product: PostgreSQL
Group size: Group of up to 15 students
Type of exam: 30 min, theoretical
Requirements: None
Next level: PostgreSQL Professional
Course language: Czech
Course length: 4 DAYS
2 000 EUR

2 420 EUR including VAT

The earliest date from 27.01.2025

Selection of dates
onas
Do you have a question?
+420 731 175 867 edu@edutrainings.cz

Professional
and certified lecturers

Internationally
recognized certifications

Wide range of technical
and soft skills courses

Great customer
service

Making courses
exactly to measure your needs

Course dates

Starting date: 27.01.2025

Type: In-person/Virtual

Course duration: 4 days

Language: en/cz

Price without VAT: 2 000 EUR

Register

Starting date: 24.03.2025

Type: In-person/Virtual

Course duration: 4 days

Language: en/cz

Price without VAT: 2 000 EUR

Register

Starting date: 19.05.2025

Type: In-person/Virtual

Course duration: 4 days

Language: en/cz

Price without VAT: 2 000 EUR

Register

Starting date: 21.07.2025

Type: In-person/Virtual

Course duration: 4 days

Language: en/cz

Price without VAT: 2 000 EUR

Register

Starting date: 29.09.2025

Type: In-person/Virtual

Course duration: 4 days

Language: en/cz

Price without VAT: 2 000 EUR

Register

Starting date: 24.11.2025

Type: In-person/Virtual

Course duration: 4 days

Language: en/cz

Price without VAT: 2 000 EUR

Register

Starting date: Upon request

Type: In-person/Virtual

Course duration: 4 days

Language: cz/sk

Price without VAT: 2 000 EUR

Register

Starting
date
Place
Type Course
duration
Language Price without VAT
27.01.2025 In-person/Virtual 4 days en/cz 2 000 EUR Register
24.03.2025 In-person/Virtual 4 days en/cz 2 000 EUR Register
19.05.2025 In-person/Virtual 4 days en/cz 2 000 EUR Register
21.07.2025 In-person/Virtual 4 days en/cz 2 000 EUR Register
29.09.2025 In-person/Virtual 4 days en/cz 2 000 EUR Register
24.11.2025 In-person/Virtual 4 days en/cz 2 000 EUR Register
Upon request In-person/Virtual 4 days cz/sk 2 000 EUR Register
G Guaranteed course

Didn't find a suitable date?

Write to us about listing an alternative tailor-made date.

Contact

Course structure

Day

  • PostgreSQL installation
  • Usage of pgAdmin4 and similar tools

Day 2 

  • Relational data models
  • Basic SQL commands

Day 3 

  • Aggregate functions
  • Subqueries and CTEs
  • JOIN
  • DATE

Day 4 

  • Windowing and Analytics
  • Views and materialized views
  • Transactions
  • Cursor
  • Indexing
ComGate payment gateway MasterCard Logo Visa logo