EDB Postgres Advanced Server v14 Course Overview
The EDB Postgres Advanced Server v14 Course Overview equips database administrators, developers, and IT professionals with advanced skills in managing and optimizing PostgreSQL environments. This course highlights the importance of leveraging advanced server features for performance, security, and compliance, ensuring participants can effectively enhance their organization's data management capabilities.
Course outline & what you'll learn
Overview of PostgreSQL and EDB extensions
- Installation and configuration
- User and role management
- Backup and recovery strategies
- Monitoring and performance tuning
- PL/pgSQL and procedural programming
- Advanced data types and indexing
- Window functions and Common Table Expressions (CTEs)
- Authentication and authorization mechanisms
- Data encryption techniques
- Compliance and auditing features
- Setting up replication and clustering
- Load balancing strategies
- Disaster recovery planning
- Data migration tools and strategies
- Integration with other EDB products
- Working with foreign data wrappers
- Query optimization techniques
- Using EXPLAIN and performance analysis tools
- Configuration tuning for optimal performance
- Common issues and resolutions
- Utilizing EDB support resources
- Best practices for maintenance and troubleshooting
Examples of EDB Postgres Advanced Server in industry
- Discussion on best practices and lessons learned
- Recap of key concepts
- Resources for continued learning and support
Why train with Traincrest
This PostgreSQL course is delivered by Traincrest's certified instructors, live online or in the classroom, with hands-on labs and a 98% exam success rate. Trusted by 500+ companies and 50,000+ students worldwide.