Workshop

ODPOST

PostgreSQL for Oracle DBAs («ODPOST»)

In this workshop, which builds on Oracle databases, more advanced functionalities are covered. The topics covered include Tablespace, Schema, Instance through to Backup and Recovery.
Duration 2 days
Price 2'150.–
Course documents Digital courseware
Register

Course facts

  • Understanding the architecture and configuration of PostgreSQL
  • Installing PostgreSQL
  • Maintaining PostgreSQL databases
  • Installation of PostgreSQL
  • Optional: Installation of LLVM
  • Architecture and configuration of PostgreSQL
  • Psql (SQLPLUS für PostgreSQL)
  • Creating and deleting a database for an instance
  • WAL Files and Backup Mode
  • Backup of a PostgreSQL database
  • Restore and recovery of a database
  • Upgrading PostgreSQL
  • Data Dictionary
  • Extensions
  • Users, Roles, Schema
  • Database and object privileges
  • Transaction Concept Basics
  • Network configuration
  • Data types - overview
  • Tables
  • Tables Partitioning
  • Rules & Triggers
  • Index
  • Views
  • Functions
  • Database, tablespaces and what is where
  • Parallel processing
  • Linking of different databases (database links)
  • Execution plan and statement processing
  • Monitoring and performance tuning
  • Programming recommendations
  • COPY

This workshop is specifically designed for Oracle DBAs who are also expected to support PostgreSQL databases. 

The prerequisite is a sound knowledge of Oracle databases – from terms like tablespace, schema, instance to backup and recovery.

Download

Download course details as PDF

Questions

Choose your date