PostgreSQL for Administrators Training Course

Description

• Type

  Course

• Methodology

  Online

Description

This course covers the administration and performance tuning of PostgreSQL databases.
Target audience includes system administrators and database architects. Attendees will learn the use of specialised PostgreSQL (AKA Postgres) modules such as replication, connection pooling and full text searching.

About this course

Requirements

A basic working knowledge of SQL

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

Send

We will only publish your name and question

Request information

We are verifying your question adjusts to our publishing rules. According to your answers, we noticed you might not be elegible to enroll into this course, possibly because of: qualification requirements, location or others. It is important you consult this with the Centre.

Thank you!

We are reviewing your question. We will publish it shortly.

Or do you prefer the center to contact you?

Request information

Reviews

Have you taken this course? Share your opinion

Subjects

• Monitoring
• Server
• Database
• SQL
• Database training
• Installation
• Statistics
• Syntax
• Shipping
• Network Training

Course programme

What is PostgreSQL?

• A Brief History of PostgreSQL
• Conventions
• Further Information
• Bug Reporting Guidelines

Introduction to PostgreSQL

• Installation and Creating Database
• The SQL Language
• Advanced Features

The SQL Language

• SQL Syntax
• Data Definition
• Data Manipulation
• Queries
• Data Types
• Functions and Operators
• Foreign Data Wrappers
• Type Conversion
• Indexes
• Triggers
• Full Text Search
• The Information Schema
• PL/pgSQL - SQL Procedural Language
• Concurrency Control
• Performance Tips
• How the Planner Uses Statistics

Server Administration

• Source Code vs Distribution-Provided Packages
• Installation from Source Code
• Installation from Source Code on Windows
• Deployment of Binaries Obtained by Compiling Source Code
• Server Setup, Operation
• Database Physical Storage
• Filesystem Durability Requirements and Required Mount Options
• Server Configuration
• Special Considerations for Container-Based Deployments
• Client Authentication
• Database Roles
• Managing Databases
• Localization
• Routine Database Maintenance Tasks
• Backup and Restore
• Recovery Configuration
• Monitoring Database Activity
• Monitoring Disk Usage
• Reliability and the Write-Ahead Log
• Regression Tests
• Installation of Third-Party Server Extensions

High Availability, Load Balancing, and Replication

• Brewer's CAP Theorem
• Synchronous vs Asynchronous Replication
• Log Shipping (Warm Standby)
• Streaming Master-Slave Replication (Hot Standby)
• Trigger-Based Master-Slave Replication with Slony
• Trigger-Based Multi-Master Replication with Bucardo
• Connection Pooling and Synchronous Replication with Pgpool
• Failover Configurations using DRBD
• Replacing a Failed Server
• Recovering from Network Partition

Additional information

14 hours (usually 2 days including breaks)

See related categories

• Monitoring courses
• Distance learning Monitoring courses
• Server courses
• Distance learning Server courses
• Electrical installation courses
• Cctv installation courses
• Solar panel installation courses
• Monitoring evaluation courses
• Meter installation courses
• Oracle sql courses
• Shipping management courses
• Shipping finance courses
• Fire alarm installation courses
• Bathroom installation courses
• Solar energy installation courses
• Gas installation courses
• Data cable installation courses
• SQL Server courses
• Distance learning SQL Server courses
• Distance learning Course
• Nobleprog Limited courses