Introduction to PostgreSQL

Introduction to PostgreSQL

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.

Information about the course

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
Course price: € 2,000 excluding VAT

Course content

Day 1

 
  • 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
Jakub Zemanek

Jakub Zemanek

Technical consultant & DBA
Jakub's main interests in the OpenSource world are advanced PostgreSQL configuration and database troubleshooting, followed by automation using Ansible, and last but not least the ELK Stack (LOG Management) and the security product Wazuh (SIEM). As Jakub likes to say about himself: "I'd rather do it best than somehow." This is also why he is constantly educating himself and pushing the boundaries of his capabilities.

Additional information

Each participant will be provided with a PDF of the presentations

Certificate

  • After successfully passing the exam, you will obtain the official Cybertec certification
initMAX - certificate

Course Gifts

Registration

"(Vyžadováno)" indicates required fields

GDPR(Vyžadováno)
This field is for validation purposes and should be left unchanged.