kurs >
SQL-programmering > RLPG201 - PostgreSQL Advanced DBA
Kurs: RLPG201 - PostgreSQL Advanced DBA
Redpill Linpro AS
Dette kurset har ikke oppført noen dato for studiestart. Bruk skjemaet under for å kontakte leverandør for nærmere informasjon.
This three-day course provides everything included in the standard DBA, with some more depth.
It also covers topics like replication, high availability clustering and tuning.
Course Format
This class is 90% theory and 10% informal labs. The course is held in Swedish or English. Documentation is only provided in English.
Agenda
Day 1:
- Introduction and Architecture
- Installation of PostgreSQL
- PgAdmin and psql
- Data design and Data types
- Using large objects
- MVCC in PostgreSQL
Day 2:
- Basic configurations
- Security
- Logging and Monitoring
- Routine maintenance
- Indexing and fulltext indexing
Day 3:
- Partitioning
- Backup and recovery
- Performance and tuning
- Basic high availability
- Warm standby and Slony
- SQL Optimization
Forkunnskaper
SQL, basic knowledge about database administration in any RDBMS.
Målgruppe
DBAs who administer and maintain installations of PostgreSQL.
Påmelding
RLPG201 - PostgreSQL Advanced DBA
RLPG201 - PostgreSQL Advanced DBA
Start her
100% sikkert skjema
Tar ett minutt å fullføre
Hurtig respons
Felt som er merket med * må fylles ut
Åpen deltakerdiskusjon om kurset eller emnet
Del gjerne din erfaring eller tanker om dette kurset eller temaet med andre!