Training PostgreSQL: administration
PostgreSQL has all the power of a classic SGBDR (sub-selection, transactional engine, views, triggers, etc.), and all the features generally unpublished among its competitors (query optimization engine, table inheritance, concept of naming scheme, etc.).
PostgreSQL is used worldwide in many important applications. Its community of users and contributors is also international.
PostgreSQL, thanks to its extension mechanism, can also be used as the basis of more specific modules such as PostGIS or PgRouting.
Dates and locations
- Trainings can take place in our offices
- Private training sessions can also be organized across Europe upon request
- Here you can find the schedule of inter-company sessions for the current year and for 2022
Target audience and prerequisites
- DBA wanting to discover/learn PostgreSQL, Developers with PostgreSQL administration needs
- Good level in SQL 92, good general knowledge in SGBD
Goals
- Learn the specifics of PostgreSQL administration
- Be autonomous in the installation, configuration and daily administration tasks of PostgreSQL
- Identify key issues related to performances
Price
- Public training in France or Switzerland: please contact us
- Private training: please contact us
- From 700 € or 900 CHF / day / trainee (for other currency, please contact us)
Camptocamp curriculum
Lecture content/Topics
Day 1
Presentation of PostgreSQL's technical architecture
- Installation and initial configuration
- Binaries and compilation from sources
- PostgreSQL cluster logic
- Low-level file organization
- Creating database and options
- Using templates
- Locales
Clients
- Psql and options
- Presentation of PgAdmin3
User right management
- Pg_hba.conf
- Postgresql.conf
- Authentication methods
- Recall on GRANT and REVOKE
Day 2
Backup and restore
- Pg_dump and pg_restore
- WAL logs
- Restoring after errors
Administration and maintenance
- Vacuum and autovacuum
- Logs management
- Access to statistics
Tuning and performance
- Query analysis with EXPLAIN ANALYZE
- Query optimization engine
- Performance settings in postgresql.conf
- Partial Indexes
- Saved Indexes
Your Trainer:
Yves Jacolin
Contact and booking
Additional training
This training can be paired with the PostGIS and the PostGIS advanced implementation Training.
Career
Interested in working in an inspiring environment and joining our motivated and multicultural teams?
- Senior Infrastructure Engineer (m/f/d) - Zurich/Olten
- ERP Consultant Odoo Smartcamp (m/f/d) - France
- IT Project Manager (m/f/d) - Zurich/Olten
- GIS Technical Consultant (m/f/d) - Zurich/Olten
- ERP Consultant Odoo Smartcamp (m/f/d) - Zurich/Olten
- Odoo Developer Internship (m/f/d) - Chambéry
- Odoo Developer (m/f/d) - Olten/Zurich/Munich
- ERP Project Manager (m/f/d) - France