- Basic knowledge in database administration
- Familiarity with SQL language
Audience
- Database administrators
- System administrators
PostgreSQL (also known as Postgres) is an open source relational database management system or RDBMS. It is built to handle large data workloads while maintaining stability, reliability, and optimal performance.
This instructor-led, live training (online or onsite) is aimed at intermediate-level database professionals who wish to deepen their understanding and skills in managing and optimizing PostgreSQL databases.
By the end of this training, participants will be able to:
- Install and configure PostgreSQL.
- Manage databases and users.
- Secure and optimize databases.
- Perform database maintenance.
- Use tools for monitoring and load balancing.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
Introduction to PostgreSQL
- System architecture
Installing PostgreSQL
- CLI user tools
- PostgreSQL Catalog
- PostgreSQL layout
Server configuration
- Connection parameters
- Authentication parameters
- Memory limits
- Checkpoints
- Autovacuum
Database management
- Databases
- Tablespaces
- Schemes
Users Management
- Users and roles
- Setting up a specific role
Database Object Types
- Boards
- Indices
Permissions and security
- Logical backups
- Graphical tools
Monitoring
- Connections and locks
- Cache and disk usage
- Slow queries
- pgbadger
- pg_stat_statements
Performance management
- Explain analyze
- Advanced indexing
- Partitioning
- Parallelism
- Denormalization
- Other parameters
Advanced maintenance
- VACUUM
- Freezing and avoid Wraparound
- Reindex
- Schedulers
Connection pool and load balancing
- pgbouncer
- pgpool