PostgreSQL for Administrators - 3 Days Certificate for Renz Tulagan
Certificate ID:
748251
Authentication Code:
080b3
Certified Person Name:
Renz Tulagan
Trainer Name:
Andres Mujica
Duration Days:
3
Duration Hours:
21
Course Name:
PostgreSQL for Administrators - 3 Days
Course Date:
11 December 2023 13:00 to 13 December 2023 21:00
Course Outline:
Introduction
- Overview of PostgreSQL features and architecture
- Basics of database administration
Getting Started
- Installing PostgreSQL
- Configuring a pgAdmin 4 client
- Creating a database user
- Creating a database
Database Operations
- SQL syntax, functions, and operators
- Data definition and data types
- User-defined data types
- Table schemas
- Creating and modifying tables
- Manipulating data in tables
- Querying and filtering data
- Exploring constraints
- Conversion functions
- Joining multiple tables
- Combining queries
- Indexes and full-text search
- Concurrency control
- Regular expressions
Database Server Administration
- Security and encryption
- Access roles and permissions
- Backup and restore
- Upgrading PostgreSQL
- High availability
- Load balancing and replication
- Statistics and monitoring
High Performance Tuning
- Resource management
- Monitoring query performance
- Parameter tuning
- Index optimization
- Query optimization
- Scalability and partitioning
External Tools for Monitoring and Observability
- pgAdmin
- pgBadger
- pgbench
- node-exporter Prometheus, Grafana
- Zabbix
Troubleshooting
Summary and Next Steps