Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
PostgreSQL DBA 8 Certification Training Camp
Date: 2008-07-21 – 2008-07-25
(This is a training event)
Location: Oak Brook, IL, United States
ATTEND THIS POSTGRESQL CERTCAMP & GET A FREE iPOD VIDEO!
Course & Exam Objectives & Outline
I. Getting Started
1. Installing PostgreSQL
Compiling and Installing PostgreSQL on Linux/Unix
Post-Installation Setup
The PostgreSQL 8.2.1 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. Peformance 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.
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.
CALL USA: (877) 724-3477; INTERNATIONAL: 1-630-684-0355 for more details and also ask for our special on-site group Discount offer.
Posted on 2007-10-25
Posted by sonia@CertFirst.com
Note: The PostgreSQL Global Development Group does not endorse any events or training courses run by third parties. No guarantee of the quality of events or courses is offered whatsoever.
Location: Oak Brook, IL, United States
ATTEND THIS POSTGRESQL CERTCAMP & GET A FREE iPOD VIDEO!
Course & Exam Objectives & Outline
I. Getting Started
1. Installing PostgreSQL
Compiling and Installing PostgreSQL on Linux/Unix
Post-Installation Setup
The PostgreSQL 8.2.1 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. Peformance 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.
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.
CALL USA: (877) 724-3477; INTERNATIONAL: 1-630-684-0355 for more details and also ask for our special on-site group Discount offer.
Posted on 2007-10-25
Posted by sonia@CertFirst.com
Note: The PostgreSQL Global Development Group does not endorse any events or training courses run by third parties. No guarantee of the quality of events or courses is offered whatsoever.