EDB Postgres Distributed
Duration: 12 hours
Learn the essentials of Postgres high availability using EDB Postgres Distributed. This course provides the skills required to design, deploy, and manage a highly available Postgres database using EDB Postgres Distributed (PGD). This understanding will prepare you to install, configure, manage, and monitor EDB Postgres Distributed and understand real-time data integration and replication in mission-critical systems
EDB Postgres Advanced Server
Duration: 11 hours
Learn the essential skills for application development with a EDB Postgres Advanced Server backend. Learn about Postgres data types, database objects, indexes, transactions, connectors, client tools, extensions, foreign data wrappers and various other SQL functionalities. Also included is a multi-step plan for SQL tuning and an overview of Oracle PLSQL compatible stored procedure language (SPL) in EDB Postgres Advanced Server. This understanding will prepare you to design and implement EDB Postgres Advanced Server databases for applications while applying Postgres features.
Duration: 7.5 hours
Learn the essentials of administering enterprise-scale data solutions using the different tools available in EDB Postgres Advanced Server, gaining the skills required to design, implement, and manage EDB Postgres Advanced Server. This understanding will prepare you to install, configure, manage and maintain EDB Postgres Advanced Server as well as manage large, highly available databases and their security requirements with confidence.
Duration: 6.5 hours
Are you an Oracle DBA who wants to quickly learn Postgres? You will learn the fundamental concepts of EDB Postgres Advanced Server including system architecture and configuration, a detailed comparison of various Postgres features to Oracle, and migration of Oracle Objects to Postgres. You will also learn the key differences with EDB Postgres and apply your existing knowledge to manage EDB Postgres database systems for the Enterprise.
Duration: 10.5 hours
Learn how to best fulfill the more advanced DBA responsibilities including database tuning and benchmarking, monitoring, setting up high availability and replication, and more. The concepts and architecture that support these more in-depth topics, along with the options available to carry them out, are covered in detail. This includes how to make the best use of tools available to perform these tasks more efficiently.
Duration: 18 hours
Learn how to best fulfill the more advanced DBA responsibilities including database tuning and benchmarking, monitoring, setting up high availability and replication, and more. The concepts and architecture that support these more in-depth topics, along with the options available to carry them out, are covered in detail. This includes how to make the best use of tools available to perform these tasks more efficiently.
Duration: 7 hours
Learn practical, safe, and highly efficient ways to optimize the performance of a Postgres Server. Topics include finding issues affecting the performance of the database and the applications that use it, tuning major database performance parameters, performance monitoring, tuning tools and how to use them to monitor and tune your Postgres database instances. You will learn how to trace SQL queries that are slowing down the database response and learn about database maintenance and proactive monitoring. This course is also a module in Advanced EDB Postgres.
Duration: 11 hours
Learn the essential skills for application development with a EDB Postgres Advanced Server backend. Learn about Postgres data types, database objects, indexes, transactions, connectors, client tools, extensions, foreign data wrappers and various other SQL functionalities. Also included is a multi-step plan for SQL tuning and an overview of Oracle PLSQL compatible stored procedure language (SPL) in EDB Postgres Advanced Server. This understanding will prepare you to design and implement EDB Postgres Advanced Server databases for applications while applying Postgres features.
Duration: 8 hours
Learn the essentials of administering enterprise-scale data solutions using the different tools available in EDB Postgres Advanced Server; providing the skills required to design, implement, and manage EDB Postgres Advanced Server. This understanding will prepare you to install, configure, manage, and maintain EDB Postgres Advanced Server as well as manage large, highly available databases and their security requirements with confidence.
Duration: 8 hours
Learn the essentials of administering enterprise-scale data solutions using the different tools available in EDB Postgres Advanced Server; providing the skills required to design, implement, and manage EDB Postgres Advanced Server. This understanding will prepare you to install, configure, manage, and maintain EDB Postgres Advanced Server as well as manage large, highly available databases and their security requirements with confidence.
Duration: 30 hours
Learn 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. 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.
Duration: 6 hours
This class will teach practical, safe, and highly efficient ways to optimize the performance of a Postgres Server. Topics include finding issues affecting the performance of the database and the applications that use it, tuning major database performance parameters, performance monitoring, tuning tools and how to use them to monitor and tune your Postgres database instances. You will learn how to trace SQL queries that are slowing down the database response and learn about database maintenance and proactive monitoring.
PostgreSQL
Duration: 11 hours
Learn the essential skills for application development with a PostgreSQL backend. Learn about PostgreSQL data types, database objects, indexes, transactions, connectors, client tools, table partitioning and various other SQL functionality. Also included is a multi-step plan for SQL tuning and an overview of PL/ogSQL in PostgreSQL. This understanding will prepare you to design and implement PostgreSQL databases for applications while applying PostgreSQL features.
Duration: 20 hours
Learn the essential details of PostgreSQL administration including architecture, configuration, maintenance, monitoring, backup, recovery, and data movement. It will also introduce you to enterprise class tools for Postgres administration and will prepare you to handle real time, production environments. This class conveys the knowledge you will need to perform your duties as a PostgreSQL DBA and is the foundation for the advanced courses that follow in the DBA learning journey.