Promotions


Free Kindle Fire. Please contact us to get complete details.

Free iPad mini with any 2 virtual live course registration. Please contact us to get complete details.

Register for our Blended CompTIA Security+, Network+, A+ Learning Package and save a bundle

Ask about our complete certcamp packages and $ave
Certain restrictions apply. Contact us for details.

Information Request







The primary objective of the PostgreSql DBA 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 for certification as as CPSDBA (Certified PostgreSQL DBA). Group training discounts available or bring this training onsite. Send us an email at info@certfirst.com for complete program details.

Audience
Database Administrator, Programmers, Developers and Open Source Technology Specialists. This instructor-led hands-on certification training program requires students to have understanding of Linux fundamentals as well as basic SQL.

Pre-requisite knowledge
This course requires students to have understanding of Linux fundamentals as well as SQL.
Become a Certified PostgreSQL Administrator; Candidates are highly recommended to attend extensive hands-on training (4 days). After successful completion of training program, candidates are encouraged to pass the PostgreSQL Administrator exam in order to get certified.

PostgreSQL Course Offering:

Course Detail: Certified PostgreSQL DBA (CPSDBA)
« Back to Course List

Course Name: Certified PostgreSQL DBA (CPSDBA)

Course Number: PG800

Delivery Method: Classroom Instructor, Virtual Live instructor, Group onsite training

Price (US$): Contact

Duration: 4

Description: Untitled 1


Description:
CertFirst is the very first company in the USA to have a complete structured independent certification training program for SQL professionals who would like to get certified in the following PostgreSQL track:

Certified PostgreSQL Administrator (SaiFirst CPSA)
Class room study or hands-on work experience is highly recommended before taking the exam. The exam fee for each exam per attempt is $295. Experienced candidates also have the option to take this training Virtual Live to prepare for the certification exams. For more information.
For more information about the PostgreSQL exams, please review the PostgreSQL training objectives.

Course & Exam Objectives & Outline
I. Getting Started
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
PostgreSQL SDBC 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

Hands-on Labs:

All of the following labs plus much more will be covered during this training program:
•Compile and Install PostgreSQL
•Network Access and Logging
•Manage Roles and Privileges
•Table Inheritance and Partitioning
•Setting up Autovacuum
•Backup using pg dump
•Backup using PITR (Point-In-Time Recovery)
•Explore Statistics and System Tables
•Performance: Creating an Index
•Performance: Configuration Settings for Increased Performance
•Performance: Effect of Moving the Transaction Logs (pg_xlog) (TENTATIVE because of system limitations.)
•Install and Use phpPgAdmin

Audience
•Database Administrator, Programmers, Developers and Open Source Technology Specialists. This instructor-led hands-on certification training program requires students to have understanding of Linux fundamentals as well as basic SQL.

Pre-requisite knowledge
This course requires students to have understanding of Linux fundamentals as well as SQL.
Become a Certified PostgreSQL Administrator; Candidates are highly recommended to attend extensive hands-on training (4 days). After successful completion of training program, candidates are encouraged to pass the PostgreSQL Administrator exam in order to get certified.




Course Schedule | Register

Schedules

Certified PostgreSQL DBA (CPSDBA) Instructor Led hands on Training:

November 18 – 21 2013 Las Vegas, NV Register
November 18 – 21 2013 Virtual Live Register
December 09 – 12 2013 Las Vegas, NV Register
December 09 – 12 2013 Virtual Live Register
January 27 – 30 2014 Orlando, FL Register
February 17 – 20 2014 Instructor led Reston VA/Virtual live Register
February 24 – 27 2014 Instructor Led Virtual live Register
February 10 – 13 2014 Group training [closed] closed
March 24 – 27 2014 Oak Brook, IL /Virtual Live Register
April 21 – 24 2014 Las Vegas/Virtual Live Register
June
30 – Jul 3rd
2014 Oak Brook, IL /Virtual Live Register
July 21 – 24 2014 Oak Brook, IL /Virtual Live Register
July 28 – 31 2014 Las Vegas/Virtual Live Register
August 18 – 21 2014 Oak Brook, IL /Virtual Live Register
September 15 – 18 2014 Las Vegas/Virtual Live Register
October 27 – 30 2014 Orlando, FL Register
November 17 – 20 2014 Las Vegas/Virtual Live Register
December 15 – 18 2014 Orlando, FL Register
For more information on how CertFirst can assist you please Contact Us



PreTest your knowledge, get a free account before you register Call 630-684-0355 or send an email to training@certfirst.com











WIA Program


CertFirst is a State of Illinois WIA approved service provider. The WIA dislocated workers program assists workers who have been laid off or employment has been terminated by providing training in market relevant skills. To learn more, call us at 630-684-0355, or visit our WIA information resource.

Testimonials


"The Instructors are very Knowledgeable, Courteous and focused"

"The instructor was fantastic at explaining new and complicated theories in an easy to understand manner. I appreciated that he was patient, encouraging and accommodating in his teaching methods."



More Testimonials



Clients