Peripheral Links
PostgreSQL 9.X DBA CertCamp Instructor-led Training & Certification
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
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 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.
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.