PostgreSQL camp

PostgreSQL DBA 8 Certification Training CertCamp

Date: 2008-08-20 – 2008-08-24 (This is a training event)
Location: Sydney, Australia

ATTEND THIS POSTGRESQL CERTCAMP & GET A FREE iPOD Video!
Register 3 or more candidate(s) for the same class and all three gets a FREE new iPhone, call us for more details!

To Master IT, Learn IT from the Masters!
100% satisfaction & certification Guarantee.
CertFirst Trainers are experts and specialized in their given domains. All our PostgreSQL trainers are also certified in Linux, PostgreSQL DBA and as well as in many other leading technologies. CertFirst uses nothing but the best equipment, A+ grade classroom with the state of the art labs that includes dual core processor computers with minimum of 2-4 GB RAM. For quality assurance purposes, average class size is limited to about 6-8 students.

Course & Exam Objectives & Outline

I. Getting Started

1. Installing PostgreSQL
Compiling and Installing PostgreSQL on Linux/Unix
Post-Installation Setup
The PostgreSQL Windows Installer

2. Creating a Database and Testing the Server
Initializing a Cluster
Creating a Database
Starting the Database Server
The psql Client
Startup Failures and Client Connection Problems

II. Basic PostgreSQL Administration

3. Overview of PostgreSQL Architecture
Configuration Files
Physical Storage and File Layout
Tablespaces
System Catalogs
Logging Parameters

4. Roles and Privileges
Roles and Their Attributes
Privileges
Role Membership

5. Security
Securing TCP Connections with SSL
Create Secure SSH Tunnels
Client Authentication
Encryption Options

6. Backup and Recovery
Overview of Backup Methods
Performing an SQL Dump and Restore
Filesystem Backup

7. Maintenance and Monitoring
Routine Maintenance Tasks
Monitoring Database Activity
Monitoring Disk Usage

8. Client Connections
pgsqlODBC and OpenOffice
Windows ODBC and Microsoft Access
Perl DBI

III. Advanced Administration Topics

9. Performance Tuning
10. Continuous Backup and PITR
11. Warm Standby Servers for High Availability
12. Asynchronous Replication with Slony-I
13. Procedural Languages
14. Contrib Modules

Prerequisite knowledge
This course requires students to have understanding of Linux fundamentals as well as SQL.


Corporate on-site:
For a group of 5 or more it may be a cost effective and convenient for corporate to outsource the whole program to CertFirst Professionals to come and bring the training at their own location. This course is available @ your site for as low as $9,500 for a group of 5 candidate(s). Price includes course-ware, classroom lab set up including hardware & software can also be provided at no additional cost for the duration of the training program; client only pays for shipping and handling. Contact us for more information

Education and Government Institute(s)
CertFirst offers special discount pricing for all Educational and Govt. Institutes.

CertFirst Integrated CertPak:
The most cost effective and the convenient way to study and prepare at your own convenience. CertPak comes with the best resources to study for the exam including Official Study Guide and the exam prep tools with many other certification exam prep tools.