The course is designed for PostgreSQL users who want to expand their administrative knowledge. Various approaches to optimizing database use will be explained and practiced through different examples.
By the end of the course, participants will be able to create, manage, and tune their own database servers, databases, and users. They will also be able to acquire the necessary information independently and will be familiar with the most important platforms and documentation.
The following topics will be covered:
- Introduction to PostgreSQL
- Server Configuration (on Linux)
- Database Administration
- Database User Administration
- Rights and Security
- Maintenance
- Monitoring
- Performance Analysis (Tips and Tricks)
- Indexing
The two-day course costs xxx CHF per person. The course fees include professional support during the course as well as two lunches.
One instructor for 4 to 8 participants and two for 9 to 14 participants.
