> > > EDB210 Detailed outline

Postgres Plus Advanced Database Administration (EDB210)

Course Description Schedule Course Outline

Detailed Course Outline

  • Postgres Plus Advanced Server Features and Tools Overview
  • SQL Tuning - Common Issues, the Tuning Process and How to Steps
  • Performance Tuning - Techniques, OS and Server Parameter Tuning, Monitoring with PEM
  • DRITA - Configuring and Using
  • Performance Benchmarking - How, Why, Tools, Testing
  • Routine Maintenance - Tools, Statistics, Vacuuming, Reindexing
  • Job Scheduling and using pgAgent
  • Extensions - Installing and Using Available Extension Modules
  • Table Partitioning - Benefits, Methods/Types, Syntax
  • Connection Pooling - pgpool II, pgbouncer, Configuration and Use
  • Materialized Views - Creating and Using
  • SQL/Protect - Details for Projecting against Injection Attacks
  • Cloning a Database
  • WAL Archiving - Process and Configuration
  • Streaming Replication - Type and Use
  • xDB Replication - Types and Use
  • Monitoring - Collecting Statistics, Monitoring Processes, Using PEM Stored Procedural Languages - PL/pgSQL, SPL Details
  • EDB Wrap - Using the Utility and Obfuscating Source Code

Accessing our website tells us you are happy to receive all our cookies. However you can change your cookie settings at any time. Find out more.   Got it!