The primary objective of this SaiFirst PostgreSql DBA certification hands-on Instructor-led training is to cover the latest PostgreSQL database topics. The course is designed for both administrators and developers. This program also prepares individual to get certified as as CPSDBA (Certified PostgreSql DBA).
|
This program is structurally designed for Postgresql DBA's and Developers to get a solid grip on critical Postgresql topics.
|
This course requires students to have understanding of Linux fundamentals as well as SQL.
|
Price does not include lodging, airfare and local travel
Your Price: Please call us at 630.684.0355 for special
discounts.
Group Discounts and corporate on-site Training available.
North America: e-mail us at Certcamp@certfirst.com
Europe: e-mail us at Certcampeurope@certfirst.com
Asia/Middle east/Africa: e-mail us at Certcampasia@certfirst.com
|
Please call us at 877-724-3477 for the current schedule.
Can't find a schedule in your city?
Ask us about our on-site training option or CertFirst CertCamp Plus package deal.
|
CertCamps:
To get the hands on experience with equipment from the industry's leading
vendors, taking the Linux CertCamp is highly recommended.
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 Linux exam
including Linux Official Study Guide and the Linux exam prep tools with many
other certification exam prep tools.
|
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
Onsite Training: Please note price for onsite training may vary.
|
