Wir beraten Sie gerne!
+49 40 253346-10     Kontakt

Foundations of PostgreSQL Administration (FPA)

 

Course Overview

Get started with PostgreSQL by taking the Foundations of PostgreSQL course. In only a few days, you will receive comprehensive training to maximize your understanding and usage of PostgreSQL, the #1 enterprise-class open source database.

Prerequisites

  • Basic experience in database administration and knowledge of RDBMS concepts
  • Basic experience with the use of the Linux operating system is helpful

Course Objectives

In this course you will 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. It is designed for people with experience in database administration who are new to Postgres.

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 track.

Course Content

All Topics covered in this course enable you to cope with a PostgreSQL DBA’s skill requirements. In addition, EnterpriseDB, a leading global provider of Postgres, can certify your PostgreSQL skills with the PostgreSQL Associate Certification exam.

  • PostgreSQL System Architecture
  • Installation and Getting Started
  • Configuration
  • Creating and Managing Databases
  • User Tools - Using PSQL
  • GUI Tools - Using pgAdmin 4
  • Security Basics
  • SQL Primer
  • Backup and Recovery
  • Routine Maintenance
  • Postgres Data Dictionary
  • Moving Data
Online Training

Dauer 3 Tage

Preis (exkl. MwSt.)
  • 1.950,– €

Sprache der Kursunterlagen: Englisch

Classroom Training

Dauer 3 Tage

Preis (exkl. MwSt.)
  • Deutschland: 1.950,– €
inkl. Verpflegung

Sprache der Kursunterlagen: Englisch

Kurstermine

FLEX Classroom Training (Hybrid-Kurs):   Kursteilnahme wahlweise vor Ort im Klassenraum oder online vom Arbeitsplatz oder von zu Hause aus.
Deutsch
Zeitzone: Mitteleuropäische Zeit (MEZ)   ±1 Stunde
Online Training Zeitzone: Mitteleuropäische Zeit (MEZ)
Online Training Zeitzone: Mitteleuropäische Sommerzeit (MESZ)
FLEX Classroom Training (Hybrid-Kurs):   Kursteilnahme wahlweise vor Ort im Klassenraum oder online vom Arbeitsplatz oder von zu Hause aus.
Deutschland
Frankfurt
Frankfurt

Fast Lane Flex™ Classroom Ist der für Sie passende Termin oder Ort nicht dabei? Wir bieten Ihnen noch weitere FLEX Trainingstermine an!