This complimentary hands-on course has been completely redesigned in a new interactive, self-paced format. This new on-demand style is 60% hands-on with new features including drag and drop, true & false, click to learn and quizzes all designed to increase learning retention. The course content has been updated with the new features of EDB Postgres Advanced Server v13. New v13 highlights include Parallel Vacuuming and concurrent build for indexes as well as verify backups using pg_verifybackup.
This foundations course will focus on the essentials of EDB Postgres Advanced Server database administration; providing the skills required to install, configure, manage and maintain EDB Postgres Advanced Server. This understanding will help prepare you to manage large, highly available databases and their technical requirements with confidence.
Audience: DBAs, Architects, System Administrators and IT Professionals responsible for administration and maintenance of EDB Postgres Advanced Server and want to understand how to use the primary features.
Duration: Suggested duration is 30 hours
Introduction to EDB Postgres Advanced Server
EDB Postgres Advanced Server Installation
Creating and Managing Databases
User Tools: Command Line Interface
Backup and Recovery and Point-in Time Recovery (PITR)
Performing Routine Maintenance Tasks
Moving Data Using COPY Command
Migrating Oracle Objects to EDB Postgres Advanced Server
Basic experience in database administration and knowledge of RDBMS concepts
Basic understanding of SQL
Basic experience with the use of the Linux operating system is helpful
This course is the suggested prerequisite to help prepare for the EDB Associate Certification Exam. To become certified, candidates must score a 70% or higher on the 1-hour, multiple-choice exam. Successful candidates will receive a personalized PDF certificate from EDB and a digital badge that can be shared on social media, email and more.
This course is also available in on-demand format for versions 10 and 11.
Foundations of EDB can also be delivered as Private Instructor-led Training, please contact us for pricing and more information.