Course Code: psdbabspk
Duration: 14 hours
Prerequisites:
  • Basic Linux, SQL and Administering Oracle minimum of 3 years

Audience

  • Oracle DBA and MS SQL Server DBAs.
Course Outline:
  • Architecture
  • Installation
  • Backup/Recovery
  • Replication
  • Security
  • Create database, users, and database objects.
  • Monitoring user sessions/Queries - useful extensions / tools
  • Index types (btree, gist, gin, brin)
  • Transaction isolation
  • Maintenance routine (vacuum)
  • Information Schema
  • Query optimization
  • Database upgrade

As part of the course, we will be also covering differences between Oracle and PostgreSQL.