Training objectives
- Understand the PostgreSQL architecture
- Installing PostgreSQL from source
- Understand what is common to and what is different from other databases such as Oracle
- Create databases
- Get used to the command line interface: psql
- Understand backup and restore procedures in PostgreSQL
- Understand extensions in PostgreSQL
- Create a hot standby database
- Understand the optimizer, statistics and vacuum
- Understand monitoring tools
- Upgrades in PostgreSQL
PostgreSQL Training Topics
- PostgreSQL installation methods: from source code, using operating systems vendor packages, using graphical installers
- PostgreSQL architecture: processes, cluster, instance, database
- How PostgreSQL organizes the files on disk
- Dumping, restoring, point in time recovery
- Standby databases
- Optimizer statistics
- Vacuum
- MVCC: Multiversion concurrency control
- ACID
- psql, the flexible command line interface
- Extentions: pl/pgsql, pl/perl, pl/python
- Tablespaces
- WAL, the write ahead log
- The client authentication system
Training Method
- Presentation with numerous exercises, case studies, and live demos
- Discussions and networking during coffee break, lunch, and apéro on last day (included in price, except for on-site workshop courses)
Target groups
- Database administrators (DBA) as well as network, system and application administrators responsible for or supporting PostgreSQL databases
Language & documentation
- The workshop will be held in French in Lausanne and Geneva and in German in Basel, Zurich and Bern.
- Documentation: content details, scripts, case study solutions as PDF file (in English
Equipment
- On-site training: As this training is provided on a Cloud platform, participants must be equipped with a laptop in order to access the Cloud infrastructure through an ssh client.
For your information
- IT performance management : review and tuning
- Testimonials : what customers are saying about dbi services
- Our expertise in database management