Administración de PostgreSQL y ajustes de Performance
Fechas
¡Consulta las fechas disponibles para el curso!
Si no hay fecha y hora disponibles para cierta capacitación que le interesa, comuníquese con nosotros. contacto.
Ver fechas >>
Este curso dura 3 días con 8 horas cada uno (cursos presenciales) o 5 horas cada uno (cursos online).
La única diferencia es que habrá menos ejercicios prácticos en los cursos online. Sin embargo, se los entregaremos y los podrán hacer por su cuenta y pedir ayuda a nuestros consultores o realizar comentarios en caso de ser necesario.
AUDIENCIA
Este curso está dirigido principalmente hacia administradores de bases de datos (Linux / Windows / Solaris / Mac OS X) y sysadmis. Nos enfocaremos en temas relacionados con la administración de bases de datos y los ajustes de performance.
Contenido
Day 1
- The PostgreSQL projekt, support, community, release management
- Architecture – overview
- Installation, starting and stopping the server, connection to the client
- Basics about “psql”
- Indexing with B-Tree indexes
- EXPLAIN
- Transactions: Atomicity, Isolation, Locking
Day 2
- Transactions: optimistic vs pessimistic locking
- Multiversioning
- VACUUM
- Autovacuum
- Logical Backup, data export and import (pg_dump)
- Physical Backup, Transaction log archiving
- Point-in-time Recovery
Day 3
- Configuration parameter
- Logging
- Resource m anagement
- Parameter tuning
- User management, authentification
- Remote access
- Role management
- Security
- Upgrade
- Statistics and monitoring
REGISTRESE AL CURSO
Other courses that might interest you
We offer these services
PostgreSQL Optimization & Security
Is your database not running smoothly or are you struggling with security issues? Our experts will analyze problems & optimization potentials within a health check or security audit.
PostgreSQL Infrastructure
PostgreSQL Setup & Installation, automation with Kubernetes and database architecture: We’ll find the optimal setup and make sure that your PostgreSQL Infrastructure meets your needs and expectations.
PostgreSQL Setup & Installation
Get started with PostgreSQL by using our Setup & Installation service. We fully focus on your personal needs and infrastructure. In addition to the configuration itself, you also benefit from the knowledge of our experts in the field of database design.