I. Getting Started -Installing PostgreSQL -Compiling and Installing PostgreSQL on Linux/Unix -Post-Installation Setup -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 -Configuration Files -Physical Storage and File Layout -Tablespaces -System Catalogs -Logging Parameters -Roles and Privileges -Roles and Their Attributes -Privileges -Role Membership -Security -Securing TCP Connections with SSL -Create Secure SSH Tunnels -Client Authentication -Encryption Options -Backup and Recovery -Overview of Backup Methods -Performing an SQL Dump and Restore -Filesystem Backup -Maintenance and Monitoring -Routine Maintenance Tasks -Monitoring Database Activity -Monitoring Disk Usage -Client Connections -pgsqlODBC and OpenOffice -Windows ODBC and Microsoft Access -Perl DBI
III. Advanced Administration Topics
-Performance Tuning -Continuous Backup and PITR -Warm Standby Servers for High Availability -Asynchronous Replication with Slony-I -Procedural Languages -Contrib Modules
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.