PostgreSQL Immersion

The PostgreSQL Immersion course is a self-contained program, created by combining selected topics from three other comprehensive courses: Administration and Replication; Advanced Development and Performance; and Backup & Disaster Recovery. This course has minimal prerequisites, making it ideal as a speedy introduction to PostgreSQL. It is suitable for a wide range of participants, such as: application developers with working knowledge of databases, system administrators, and database administrators having prior experience with any database software.

Prerequisiti Argomenti Capacità acquisite

- Basics of databases

- Basics of SQL

- Basics of Systems Administration

- Basics of Application Design

- Introduction to PostgreSQL

- OmniDB

- Server Configuration

- Database Administration

- User Administration

- Understanding Database Object Types

- Monitoring

- VACUUM, Freezing & Avoiding Wraparound

- Managing Cloud Databases

- Server Architecture & Server Tuning

- Security

- Database Design Alternatives

- Advanced Development

- EXPLAIN and SQL Execution

- Workload Analysis

- Indexes

- Partitioning

- Replication Architecture

- Point-In-Time Recovery

- Logical Backup

- Logical Replication Overview

- Online Upgrade

- Bi-Directional Replication

- Replication Startup & Setup

- Disconnection & Reconnection

- Switchover, Failover & Failback

- Physical Streaming Replication & Hot Standby

- repmgr

- Physical Backup

- Barman

- Basics of PostgreSQL

- PostgreSQL Database Administration

- PostgreSQL Application Design

- PostgreSQL Tuning and Performance

- PostgreSQL Database Architecture

- Advanced PostgreSQL development

- PostgreSQL Replication

- PostgreSQL High Availability

- PostgreSQL Disaster Recovery

- Basics of PostgreSQL Scalability

Tag: PostgreSQL, Administration, Backup and Disaster Recovery

Durata: 5.00 giorni

Eventi correlati


2ndQuadrant Updates

Tieniti in contatto con noi.

Iscriviti alla nostra newsletter trimestrale: riceverai le ultime notizie su 2ndQuadrant e aggiornamenti sulle tecnologie da noi supportate

La tua privacy è tutelata in base alla normativa vigente (art. 13 D. Lgs. 30.06.2003, n. 196).

2ndQuadrant Updates