PostgreSQL for DB Developers

Course code: POSQLD

This course provides programmatic interaction with PostgreSQL databases. Learn techniques, syntaxes and structures needed to develop quality applications using PostgreSQL backend. This training also covers SQL Tuning covering best practices for writing efficient SQL.

620 EUR

750 EUR including VAT

The earliest date from 08.04.2024

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: 08.04.2024

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 620 EUR

Register

Starting date: 03.06.2024

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 620 EUR

Register

Starting date: 12.08.2024

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 620 EUR

Register

Starting date: 07.10.2024

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 620 EUR

Register

Starting date: 02.12.2024

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 620 EUR

Register

Starting date: Upon request

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 620 EUR

Register

Starting
date
Place
Type Course
duration
Language Price without VAT
08.04.2024 In-person/Virtual 2 days en/cz 620 EUR Register
03.06.2024 In-person/Virtual 2 days en/cz 620 EUR Register
12.08.2024 In-person/Virtual 2 days en/cz 620 EUR Register
07.10.2024 In-person/Virtual 2 days en/cz 620 EUR Register
02.12.2024 In-person/Virtual 2 days en/cz 620 EUR Register
Upon request In-person/Virtual 2 days en/cz 620 EUR Register
G Guaranteed course

Didn't find a suitable date?

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

Contact

Course structure

The SQL Language

  • SQL Syntax
  • Data Definition
  • Data Manipulation
  • Queries
  • Data Types
  • JSON
  • Functions and Operators
  • Type Conversion
  • Indexes

Transactions and Concurrency

  • Transactions and Isolation
  • Multi-Version Concurrency Control

Server Programming

  • Extending SQL
  • Triggers
  • The Rule System
  • Procedural Languages
  • PL/pgSQL – SQL Procedural Language
  • Error Handling
  • Cursors

SQL Tuning

  • Logging in PostgreSQL
  • Query Plans
  • Optimizing Queries
  • Statistics
  • Parallel Query Scans
  • SQL Best Practices
  • Indexes

Follow-up courses

MongoDB Developer en/cz

Vendor: EDU Trainings

Area: Databases

Price from

885 EUR without VAT

MongoDB Administration en/cz

Vendor: EDU Trainings

Area: Databases

Price from

885 EUR without VAT

MySQL Administration en/cz

Vendor: EDU Trainings

Area: Databases

Price from

620 EUR without VAT

MySQL Performance en/cz

Vendor: EDU Trainings

Area: Databases

Price from

620 EUR without VAT

PostgreSQL Administration en/cz

Vendor: EDU Trainings

Area: Databases

Price from

620 EUR without VAT

PostgreSQL Performance en/cz

Vendor: EDU Trainings

Area: Databases

Price from

620 EUR without VAT

SQL for beginners en/cz

Vendor: EDU Trainings

Area: Databases

Price from

460 EUR without VAT

SQL for intermediate users cz/sk en/cz

Vendor: EDU Trainings

Area: Databases

Price from

460 EUR without VAT

MS SQL Server administration comprehensively and efficiently en/cz

Vendor: EDU Trainings

Area: Databases

Price from

1 210 EUR without VAT

Optimization and monitoring of T-SQL queries en/cz

Vendor: EDU Trainings

Area: Databases

Price from

790 EUR without VAT

ComGate payment gateway MasterCard Logo Visa logo