PostgreSQL Server 16 Application Development: Advanced Course
Course ID : PS-DEV2
Duration In-class (в days) : 4 days
Duration Online : 4 days
Сurriculum : Virtual Instructor-Led Training - ONLINE
Overview
This course introduces the PostgreSQL architecture, installation, basic configuration, and launch of the DBMS.
Audience for this course
- Database Developers
- Database Administrators
Prerequisites for this course
- General information about PostgreSQL architecture
- Introduction to PostgreSQL as part of the PS-DBA1 course “PostgreSQL Administration. Basic Course”
- Basic knowledge of working in Unix
Outcomes
Upon completion of this course, students will acquire the skills to:
- Understand the internal organization of the server
- Fully utilize the capabilities provided by PostgreSQL to implement application logic
- Use advanced DBMS capabilities to solve specific problems
Outline
Introduction
Module 1. Architecture
- Isolation
- Multiversioning
- Scrubbing
- Logging
- Locking
Module 2. Tutorial
- Bookstore 2.0
Module 3. Extensibility
- Connection pooling
- Large value types
- User-defined data types
- Operator classes
- Semi-structured data
- Background processes
- Asynchronous processing
- Create extensions
- Programm languages
- Aggregate and window functions
- Full-text search overview
Module 4. Replication
- Physical replication overview
- Logical replication overview
Module 5. External data
Overview
