Workshop
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
Course facts
Key Learnings
- Understanding the architecture and configuration of PostgreSQL
- Installing PostgreSQL
- Maintaining PostgreSQL databases
Content
- 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
Target audience
This workshop is specifically designed for Oracle DBAs who are also expected to support PostgreSQL databases.
Requirements
The prerequisite is a sound knowledge of Oracle databases – from terms like tablespace, schema, instance to backup and recovery.
Download
Questions
We currently do not have any dates scheduled.
But we can arrange one for you. We will be happy to advise you individually on your course planning.
Contact us