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 BigAnimal
Duration: 25 minutes
Introduction to a Cloud Database, its key features, and the role it can provide for an Enterprise. Learn the characteristics a Cloud Computing service provides and what a DBaaS offering is. Learn the key features that EDB BigAnimal DBaaS offering provides and its typical use cases.
Duration: 14 minutes
Learn how to Create an EDB account and access the BigAnimal trial. Using the BigAnimla trial we will step through creating a single node cluster, make cluster property changes, and connect to the cluster using psql remotely. With the psql utility while accessing the biganimal cluster we will create a postgres database, create a database table, load the database table, make database table data changes, drop the database table, and use BigAnimals restore cluster capability.
Duration: 22 minutes
Learn what the core BigAnimal account administration activities are and the Responsibility Model for the BigAnimal Platform. We will specifically cover Identity Provider configuration options, roles for role-based access control, projects for resource management, regions availability, cloud providers, and the Activity log.
Duration: 22 minutes
Learn the three cluster types supported by BigAnimal and the property configuration categories needed to create the clusters using the BigAnimal Portal. We will additionally cover the Cloud Provider deployment options and the properties needed for each of the cluster types.
Duration: 12 minutes
Learn the role BigAnimal has with Postgres database authentication configuration. In addition we will learn the Faraway replica functionality, backup and restore cluster functionality, and learn the options for monitoring metrics and logging.
Duration: 6 minutes
Learn the security features BigAnimal provides as well as the compliance and certification standards BigAnimal has achieved. Additionally, we summarize the data isolation, data encryption, access control, and logging/auditing capabilities BigAnimal provides.
Duration: 12 minutes
Learn the functionality the BigAnimal CLI utility provides and how to get started using it. Learn the CLI utilities management and configuration commands that are supported.
EDB Postgres Advanced Server
Duration: 35 minutes
This course will focus on the new features of EDB Postgres Advanced Server version 16. Learn how to install and configure EDB Postgres Advanced Server and try out new features and enhancements of version 16.
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: 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: 3.75 hours
Learn how to implement and manage highly available and resilient databases with EDB Postgres. Business continuity is one of the top priorities in IT. With practical insight on how backup and recovery works in EDB Postgres, you can easily develop a reliable disaster recovery plan. You will also learn how to build a complete high availability solution based on best practices, using streaming replication and EDB Postgres Failover Manager.
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: 12 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: 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 essentials of administering enterprise-scale data solutions using the different tools available in PostgreSQL; providing the skills required to design, implement, and manage PostgreSQL This understanding will prepare you to install, configure, manage, and maintain PostgreSQL as well as manage large, highly available databases and their security requirements with confidence.
Duration: 11 hours
Learn how to best fulfill the more advanced DBA responsibilities including database tuning and benchmarking, monitoring, 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: 12 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/pgsql in PostgreSQL. This understanding will prepare you to design and implement PostgreSQL databases for applications while applying PostgreSQL features.
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/pgsql 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.
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.