Object and Data Labs
  Certificates   Free Newsletter   What's New   Contact
              Sitemap
Main Areas
Onsite Training
Courses
Class Schedule
Registration
Tuition Discounts
Technology Library
Our Instructors
Our Customers
Why Object & Data Labs?

Hot New Courses:
XML: A Comprehensive Introduction
Disaster Recovery Planning

How students rate us

Free Newsletter
Visit our technology library and sign up to receive the latest word in technology from industry specialist.

Certification Available
Visit our certification page to see how you can be on the fast track to certification in advanced technologies.
  Home > Courses > Course Descriptions Print Page
Course Description

PostGresSQL Hands-On Course

Course Objective

In-House Training for as few as 3 Attendees >>

Or Call Toll Free
1-888-230-9052

Getting a PostgreSQL server up and running is not difficult. Making a secure, high-performance, reliable database is. This PostgreSQL course will give you hands-on knowledge of PostGresSQL Administration & Tuning. Learn from our instructors many years of experience and get productive in just one week.

What will you learn

  • Ten basic steps for installing PostgreSQL
  • Understanding tables and types in PostGreSQL
  • Building psql and graphical clients
  • Setting up ODBC and JDBC drivers
  • Simple and complicated psql hacks
  • Advanced table structures, Arrays, Indices, transactions and cursors
  • Authentication and Encryption
  • Adding PL/pgSQL to your database
  • Starting, Stopping and Maintaining your PostgreSQL
  • Backing up and restoring data
  • Running the SLONY-1 Replication System
  • Optimizing PostgreSQL and benchmarking
  • Replication with SLONY-I
  • OO Database Concepts

Who should attend

Anyone interested in getting up and running with PostgreSQL administration and programming

Prerequisites

This class assumes you are familiar with basic Linux or Unix administration and simple SQL & programming concepts. It would be useful if you have some familiarity with simple PostgreSQL installation and administration.

 

Onsite Training  Class Schedule  Registration

 

  Home | Courses | Class Schedule | Registration | About Us | Contact Call us TOLL FREE at 1-888-230-9052
Copyright 2003-2013, Object & Data Labs All Object & Data Labs Courses are certified courses with UC Berkeley & UCSC extension 

Website by Howard Pugh Web Design
Website maintained by Ann T. Comey