I. Getting Started
Compiling and Installing PostgreSQL on Linux/Unix
The PostgreSQL Windows Installer
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
Overview of PostgreSQL Architecture
Physical Storage and File Layout
Roles and Privileges
Roles and Their Attributes
Securing TCP Connections with SSL
Create Secure SSH Tunnels
Backup and Recovery
Overview of Backup Methods
Performing an SQL Dump and Restore
Maintenance and Monitoring
Routine Maintenance Tasks
Monitoring Database Activity
Monitoring Disk Usage
pgsqlODBC and OpenOffice
Windows ODBC and Microsoft Access
III. Advanced Administration Topics
Continuous Backup and PITR
Warm Standby Servers for High Availability
Asynchronous Replication with Slony-I
This course requires students to have understanding of Linux fundamentals as well as SQL.
For a group of 5 or more it may be a cost effective and convenient for corporate to outsource the complete training project to CertFirst Professionals to come and bring the training at their own location. This course is available @ your site for as low as $9,995 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 at 630-684-0355 for more information.
Education and Government Institute(s)
CertFirst offers special discount pricing for all Educational and Govt. Institutes. Call 1-877-724-3477 (USA) or 1-630-684-0355 (Global) for more details.
CertFirst Virtual Live Training:
The most cost effective and the convenient way to study and prepare at your own convenience. CVLT provides you with the most cost effective and convenient way to gain hands-on live instructor-led training.
To Register, Visit: www.CertFirst.com or send an e-mail to sonia@CertFirst.com.
Posted by CertFirst (firstname.lastname@example.org).
Note: The PostgreSQL Global Development Group does not endorse any events run by third parties. No guarantee of the quality of events is offered whatsoever.