40 Hrs
3683+ Enrollments
EDB Postgres Advanced Server v14
The EDB Postgres Advanced Server v14 course is a comprehensive training program that covers all the advanced features and functionalities of Postgres Advanced Server. This course is designed to provide hands-on experience with advanced techniques for managing, optimizing, and developing Postgres Advanced Server applications. You will learn how to work with partitioning, replication, performance tuning, security, and backup and recovery.
EDB Postgres Advanced Server v14
Overview of Course
The EDB Postgres Advanced Server v14 course is designed to help you gain expertise in managing, optimizing, and developing applications using Postgres Advanced Server. This course is ideal for database administrators, developers, and IT professionals who want to enhance their skills and knowledge in Postgres Advanced Server.
Course Highlights
Gain expertise in Postgres Advanced Server
Learn advanced techniques for managing, optimizing, and developing applications
Hands-on experience with partitioning, replication, performance tuning, and backup and recovery
Key Differentiators
Personalized Learning with Custom Curriculum
Training curriculum to meet the unique needs of each individual
-
Trusted by over 100+ Fortune 500 Companies
We help organizations deliver right outcomes by training talent
-
Flexible Schedule & Delivery
Choose between virtual/offline with Weekend options
-
World Class Learning Infrastructure
Our learning platform provides leading virtual training labs & instances
-
Enterprise Grade Data Protection
Security & privacy are an integral part of our training ethos
-
Real-world Projects
We work with experts to curate real business scenarios as training projects
Skills You’ll Learn
Advanced database management and optimization techniques
Database partitioning and replication
Performance tuning and optimization
Backup and recovery techniques
Database security and compliance best practices
Training Options
1-on-1 Training
Access to live online classes- Flexible schedule including weekends
- Hands-on exercises with virtual labs
- Session recordings and learning courseware included
- 24X7 learner support and assistance
- Book a free demo before you commit!
Corporate Training
- Everything in 1-on-1 Training plus
- Custom Curriculum
- Extended access to virtual labs
- Detailed reporting of every candidate
- Projects and assessments
- Consulting Support
- Training aligned to business outcomes
Unlock Organizational Success through Effective Corporate Training: Enhance Employee Skills and Adaptability- Choose customized training to address specific business challenges and goals, which leads to better outcomes and success.
- Keep employees up-to-date with changing industry trends and advancements.
- Adapt to new technologies & processes and increase efficiency and profitability.
- Improve employee morale, job satisfaction, and retention rates.
- Reduce employee turnovers and associated costs, such as recruitment and onboarding expenses.
- Obtain long-term organizational growth and success.
Course Reviews
Curriculum
- Overview of PostgreSQL
- Advantages of using PostgreSQL
- History of PostgreSQL
- Licensing and availability
- Understanding PostgreSQL Architecture
- Processes and Memory Management
- Shared Memory
- PostgreSQL Configuration Files
- Creating a database
- Modifying a database
- Dropping a database
- Database objects: Tables, Views, Indexes, and Sequences
- System requirements for installation
- Downloading PostgreSQL
- Installation process
- Post-installation tasks
- Understanding PostgreSQL Configuration Files
- Configuring PostgreSQL
- Configuration options
- Logging in PostgreSQL
- Logging configuration
- Reading PostgreSQL logs
- Introduction to PSQL
- PSQL commands for database management
- PSQL commands for table management
- PSQL commands for user and permission management
- Introduction to pgAdmin III
- Installation and configuration of pgAdmin III
- Using pgAdmin III for database management
- Overview of tablespaces
- Creating tablespaces
- Moving objects to a new tablespace
- Dropping a tablespace
- User and group management
- Password policies
- Encryption options
- Audit logging
- Backup and recovery options
- Disaster recovery planning
- Point-in-time recovery
- Recovery using backups and WAL archives
- System catalogs
- Metadata storage
- Querying system catalogs
- Commonly used system catalogs
- Introduction to APIs
- Accessing PostgreSQL through APIs
- REST APIs and JSON
- Understanding performance tuning in PostgreSQL
- Query optimization
- Indexing
- Resource allocation
- Routine database maintenance
- VACUUM and ANALYZE
- Reindexing
- Vacuum full
- Overview of replication
- Synchronous and asynchronous replication
- Failover and high availability
- Streaming replication
- Overview of table partitioning
- Partitioning strategies
- Creating partitions
- Managing partitions
- Connection pooling in PostgreSQL
- Overview of connection pooling options
- Implementing connection pooling
- Configuring connection pooling
- Monitoring PostgreSQL databases
- Performance metrics
- Monitoring tools
- Proactive monitoring and alerting
- Migrating to PostgreSQL
- Data migration strategies
- Tools for data migration
- Testing and validation after migration
Meet the instructor and learn about the course content and teaching style.- Make informed decisions about whether to enroll in the course or not.
- Get a perspective with a glimpse of what the learning process entails.
Provide your workforce with top-tier corporate training programs that empower them to succeed. Our programs, led by subject matter experts from around the world, guarantee the highest quality content and training that align with your business objectives.
-
1500+
Certified Trainers
-
200+
Technologies
-
2 Million+
Trained Professionals
-
99%
Satisfaction Score
-
2000+
Courses
-
120+
Countries
-
180+
Clients
-
1600%
Growth
Live Chat