Course Outline

Introduction

PostgresSQL Setup and Configuration

Overview of PostgreSQL Architecture and Advanced Features

PostgreSQL Administration

  • Connecting to the Database
  • Overview of PgAdmin III
  • Configuring the Server
  • Setting up and Managing Users
  • Overview of Database Object Types
  • Setting Permissions & Security
  • Querying the Database
  • Monitoring the Database
  • Ensuring Atomicity and Isolation
  • Backing up and Restoring PostreSQL
  • Migrating Data to Another System
  • Working with PostreSQL Logs

Performance Optimization

  • Reducing I/O with HOT
  • Locking & Concurrency
  • Evaluating the Design of the Database
  • Optimizing SQL Queries with EXPLAIN
  • Inspecting the Workload
  • Benchmarking and Profiling
  • Optimzing Joins
  • Using Indexes Efficiently

PostgreSQL Replication

  • Overview of PostgreSQL Replication
  • High Availability in PostgreSQL
  • Streaming Replication
  • Managing Clusters Using repmgr
  • Running Queries on Database in Hot Standby
  • Synchronous Replication
  • File based Log Shipping
  • Trigger-based Logical Replication with Slony & Londiste
  • Connection Pooling
  • Upgrading PostgreSQL
  • Sharding and Scaling PostgreSQL

Summary and Conclusion

Requirements

  • Experience with SQL
  • Experience with the Linux command line
  • Experience with basic UNIX shell programming

Audience

  • Database administrators
  • Systems administrators
  • Developers with database experience
  35 Hours
 

Testimonials (9)

Related Courses

Related Categories