PostgreSQL Advanced DBA
Corso
A Milano
Hai bisogno di un coach per la formazione?
Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.
Descrizione
-
Tipologia
Corso
-
Luogo
Milano
This training is designed for Database Administrators and Architects who want to learn the tools and techniques for implementing High Availability and Database Security in PostgreSQL.
You will also learn how to find slow queries, monitor database performance and tune PostgreSQL for Performance.
Sedi e date
Luogo
Inizio del corso
Inizio del corso
Profilo del corso
It is recommended to attend this training only if you have a prior knowledge of PostgreSQL or have attended PostgreSQL Essentials Training
Opinioni
Materie
- Security
- PostgreSQL
Programma
- Introduction
- Database Security
- Users and Groups
- Access Control
- Row Level Security
- Host Based Access Control
- Data Encryption using pgcrypto
- Demos and Labs
- Performance Monitoring and Tuning
- Monitoring Slow Queries
- SQL Tuning
- Table Partitioning
- Operating System Best Practices
- Parameter Tuning
- Extensions
- Benchmarking
- Monitoring Best Practices
- Demos and Labs
- High Availability
- Transaction Log Archiving
- Streaming Replication
- Connection Pooling and HA setup using pgpool-II
- Installation
- Configuration
- Pool Setup
- HA Setup
- Demos and Labs
- Database Upgrades
- PostgreSQL Versioning
- Plan for Upgrade
- Upgrade using pg_dump
- Upgrade using pg_upgrade
- In Place or Not-in Place Upgrade
- Post Upgrade Tasks
Hai bisogno di un coach per la formazione?
Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.
PostgreSQL Advanced DBA