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: | English |
Available online: | Yes |
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
Technical Consultant & DBAAdditional information
Certificate
- After successfully passing the exam, you will obtain the official Cybertec certification