" rel="stylesheet">
Skip Main Navigation
Page Content

Save This Event

Event Saved

PostgreSQL DBA Hands-on Virtual Live Training & Certification Program

CertFirst Integrated Knowledge Solutions

Monday, October 24, 2016 at 9:00 AM - Thursday, October 27, 2016 at 5:00 PM (EDT)

PostgreSQL DBA Hands-on Virtual Live Training &...

Ticket Information

Ticket Type Sales End Price Fee Quantity
Early Bird Special   more info Oct 23, 2016 $1,995.00 $79.80

Share PostgreSQL DBA Hands-on Virtual Live Training & Certification Program

Event Details

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.

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

PLUS Hands-on Labs

To Request Schedules and Additional Course Details send an email to Training@certfirst.com or call 1-630-684-0355.

Have questions about PostgreSQL DBA Hands-on Virtual Live Training & Certification Program? Contact CertFirst Integrated Knowledge Solutions

Save This Event

Event Saved

When & Where


Tennessee (Memphis)
5100 Poplar Avenue
Suite 2700
Memphis, Tennessee 38137

Monday, October 24, 2016 at 9:00 AM - Thursday, October 27, 2016 at 5:00 PM (EDT)


  Add to my calendar

Organizer

CertFirst Integrated Knowledge Solutions

Exposure to cutting-edge technology and effective skills is a must in today’s competitive global economy to be successful. CertFirst, a global integrated knowledge solution company has partnered with leading vendors to provide high quality and effective professional training solutions in the several areas of critical importance to enterprises including Project Management, Open Source, Software and Application Development, Information Security including Biometrics and others. World-class companies continuously examine business processes, employee performance and aggressively apply solutions to help them improve in training their employees to keep up with the technology and stay effective in an everchanging technology environment. CertFirst can assist you in achieving and maintaining your competitive edge.

To Request Schedules and Additional Course Details send an email to Training@certfirst.com or call 1-630-684-0355.

  Contact the Organizer
PostgreSQL DBA Hands-on Virtual Live Training & Certification Program
Things to do in Memphis Class Science & Tech

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.