Details
PostgreSQL is a sophisticated open source relational database management system. PostgreSQL supports the structured query language (SQL) with a wide variety of data types and support for: triggers, a number of embedded programming languages, and full transactional processing.
Instructor led training course on the administration of the PostgreSQL Relational Database Management System. You will be able to develop and maintain powerfull PostgreSQL servers.
Cost
$529.10 If you are currently resident in South Africa you will need to pay VAT at 15%.Duration:
2 DaysBrochure:
Delivery Method
Instructor Led classroom based training. Scheduled classes are normally held in Woodmead - near to Sandton in Johannesburg, Gauteng, South Africa. Stationary and textbook included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided for full time courses. Contact hours are between 9am to 4pm.
Audience
Database administrators, developers, IT support staff.
Pre-Requisites
SQL course or equivalent knowledge.
Linux Essentials course or experience with using the Linux command line.
Course Outline / Curriculum
-
Introduction to PostgreSQL
-
A Brief History of PostgreSQL
-
Getting Started
-
Installation
-
Architectural Fundamentals
-
Using the psql terminal based client
-
-
PostgreSQL SQL Language specifics
-
Creating a Database
-
Accessing a Database
-
Inheritance
-
-
Server Setup and Operation
-
The PostgreSQL User Account
-
Creating a Database Cluster
-
Starting the Database Server
-
Server Start-up Failures
-
Client Connection Problems
-
Shutting Down the Server
-
-
Server Configuration
-
Setting Parameters
-
File Locations
-
-
Security
-
Preventing Server Spoofing
-
Encryption Options
-
Connections and Authentication
-
Connection Settings
-
Security and Authentication
-
The pg_hba.conf file
-
Username maps
-
Authentication methods
-
Trust authentication
-
Password authentication
-
Authentication problems
-
Database Roles
-
Role Attributes
-
Privileges
-
Role Membership
-
-
-
Resource Consumption
-
Memory
-
Kernel Resource Usage
-
Cost-Based Vacuum Delay
-
Background Writer
-
Asynchronous Behavior
-
Write Ahead Log
-
Settings
-
Checkpoints
-
Archiving
-
-
Error Reporting and Logging
-
Where To Log
-
When To Log
-
Message severity levels
-
What To Log
-
Using CSV-Format Log Output
-
Run-Time Statistics
-
Query and Index Statistics Collector
-
Statistics Monitoring
-
-
Vacuum
-
Automatic Vacuuming
-
-
Backup and Restore
-
SQL Dump
-
Restoring the dump
-
Using pg_dumpall
-
Handling large databases
-
Use compressed dumps.
-
Use split.
-
Use pg_dump's custom dump format.
-
File System Level Backup
-
Continuous Archiving and Point-In-Time Recovery (PITR)
-
Setting up WAL archiving
-
Making a Base Backup
-
Recovering using a Continuous Archive Backup
-
Recovery Settings
-
Timelines
-
Tips and Examples
-
Standalone hot backups
-
archive_command scripts
-
Record-based Log Shipping
-
Incrementally Updated Backups
-
Migration Between Releases
-
-
Monitoring Database Activity
-
Standard Unix Tools
-
The Statistics Collector
-
Statistics Collection Configuration
-
Viewing Collected Statistics
-
Viewing Locks
-
Dynamic Tracing
-
Compiling for Dynamic Tracing
-
Built-in Probes
-
Using Probes
-
Defining New Probes
-
Monitoring Disk Usage
-
Determining Disk Usage
-
Disk Full Failure
-
Schedule Dates and Booking
There are currently no scheduled dates.
Please note that this course needs a minimum of 6 delegates to schedule a course. You can choose to be added to the waiting list by clicking the button below and we will contact you when we have enough delegates interested. Should we not get enough delegates, we will refund or credit your paid booking.
Should you need this course urgently, the following options are available:
- Pay for 6 delegates (whether you have them or not) and we will schedule the course as soon as possible.
- If you have fewer delegates and cannot pay for 6, we can negotiate a shortened course where some of the time will be spent in blended learning - watching videos and doing tutorials and exercises with some contact time with the trainer. We would want to discuss what your core needs are so that we cover those aspects. You need to have paid for 3 delegates at least.