PostgreSQL Administration and Performance Tuning
Dates & Duration
Vaadake koolituse toimumiskuupäevi! Kui Teid huvitava koolituse infot hetkel avaldatud ei ole, võtke palun meiega ühendust.
VAATA KUUPÄEVI >>
Seda koolitust pakume Teie ettevõttes kohapeal või veebikursusena vaid Teie töötajatele. Muidugi kohandame soovi korral koolituse sisu vastavalt ettevõtte spetsiifilistele vajadustele.
ROHKEM INFOT INDIVIDUAALKOOLITUSTE KOHTA >>
Koolitus kestab3 päeva, iga õppepäev 8 tundi; veebipõhine koolitus toimub 5-tunniste õppetsüklite kaupa.
Kontaktõppe ja veebiõppe ainus erinevus seisneb praktiliste ülesannete hulgas. Sellegipoolest on veebikoolitusel osalejatel ligipääs praktilistele ülesannetele, mida omal käel või koolitaja juhtnööride abil lahendada saab.
Audience
This course is especially suitable for database administrators (Linux / Windows / Solaris / Mac OS X) and sysadmis. We will deal with administration and performance tuning related topics.
Available Language
This course can be held in English, German, Spanish, Polish, Estonian, Ukrainian and Russian.
COURSE CONTENT
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
Contact us to sign up for this course >>
Muud kursused, mis võivad Teile huvi pakkuda
Me pakume neid teenuseid
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.