1-877-WEBUCATE
(1-877-932-8228)
info@webucator.com
 
Microsoft Training
Java Training
XML Training
Database & SQL Training
PHP, Perl, ASP, Groovy, Grails, Ruby on Rails Training
HTML, JavaScript, Ajax & CSS Training
Adobe CS3 Training
◊ PRIVATE POSTGRESQL TRAINING

Need a private class for your team delivered at your site or a location near you?
For private groups of three or more, Webucator offers completely customizable and cost-effective PostgreSQL classes delivered at your offices or a location near you.

To have someone contact you about these classes, please fill out the form below.

* (Required)
* (Required)
* (Required)
* (Required)
* (Required)
(The number of people requiring training)
(For Federal Government Pricing)
* (Required)

Introduction to PostgreSQL for Developers and Administrators (5 days)

This PostgreSQL class is delivered for private groups onsite at your offices or a location of your choice. It can also be delivered via the Internet for geographically distributed staff.

Introduction to PostgreSQL for Developers and Administrators Overview

The primary objective of this course is to provide an introduction to the PostgreSQL database. The course targets both administrators and developers.

Introduction to PostgreSQL for Developers and Administrators Course Goals

  • Learn about the history of PostgreSQL.
  • Learn where to find PostgreSQL documentation and resources.
  • Understand PostgreSQL Server Architecture.
  • Learn about different popular PostgreSQL clients.
  • Learn to work with PostgreSQL functions.
  • Learn to create your own functions.
  • Learn to program with plpgsql.
  • Learn to install and setup PostgreSQL securely.
  • Learn basic administration tasks such as user creation, cataloging and backing up.
  • Learn about SLONY and PGPOOL.
  • Understand inheritance in PostgreSQL.
  • Learn to partition tables.
  • Learn to use Tablespaces.
  • Learn about database monitoring.
  • Understand the EXPLAIN Statement
  • Learn about PITR
  • Learn to tune the Postgresql Server

Introduction to PostgreSQL for Developers and Administrators Course Prerequisites

Experience in the following areas is required:

  • Oracle SQL as taught in our Introduction to Oracle SQL and Advanced Oracle SQL classes.

Introduction to PostgreSQL for Developers and Administrators Course Outline

  1. PostgreSQL Introduction
  2. History
  3. Documentation and Resources
  4. PostgreSQL Server Architecture
  5. Popular PostgreSQL clients
    1. Psql, The PostgreSQL Command Line Interface
    2. pgadmin
    3. phppgadmin
    4. Using ODBC with other Clients
  6. Functions in PostgreSQL
  7. Functions, user-defined
  8. Procedural languages:
    1. installing, removing
    2. trusted, untrusted
    3. programming with plpgsql
  9. Best practices using plpgsql
  10. Binary Installation (UNIX like, MSWindows)
  11. Source Code Install
  12. Creating a database cluster (initdb)
  13. Server Configuration
  14. Server Security
  15. Running the Server
  16. Creating Users
  17. System Catalogs
  18. Backup Practices
  19. SLONY
  20. PGPOOL
  21. Inheritance
  22. Table Partitioning
  23. Tablespaces
  24. Monitoring The Database
  25. Understanding The EXPLAIN Statement
  26. PITR
  27. Tuning The Postgresql Server

Introduction to PostgreSQL for Developers and Administrators Course Materials

In addition to a comprehensive set of materials, including course notes and all the programming examples, each student will also receive a one-year subscription to Webucator's online reference library, which contains hundreds of the most current electronic technology books - a $149.95 per student value.

Introduction to PostgreSQL for Developers and Administrators Technical Requirements

  1. PostgreSQL
  2. pgAdmin III
home - onsite classes - instructor-led online courses - self-paced online courses - why webucator - partners - contact - sitemap
© 2007 Webucator. All rights reserved. info@webucator.com | Toll Free: 877-WEBUCATE (877-932-8228) | From Outside the USA: 315-446-0560 | Fax: 315-410-5320
Phoenix, AZ | Santa Clara, CA | Santa Clara, CA | Los Angeles, CA | Sacramento, CA | Washington, DC | Atlanta, GA | Chicago, IL | Indianapolis, IN | Muncie, IN
New Orleans, LA Boston, MA | Cambridge, MA | Charlestown, MA | Framingham, MA | Ipswich, MA | Lincoln, MA | Wellesley, MA | Worcester, MA | Bangor, ME | Detroit, MI
Raleigh, NC Winston-Salem, NC | Lincoln, NE | East Hanover, NJ | Eatontown, NJ | Madison, NJ | Parsippany, NJ | Trenton, NJ | Albany, NY | Buffalo, NY | Rochester, NY
New York City, NY | Syracuse, NY | West Babylon, NY | Dayton, OH | Bethlehem, PA | Philadelphia, PA | Pittsburgh, PA | Pittsburgh, PA | State College, PA
Middletown, RI | Rapid City, SD | Austin, TX | Dallas, TX | Houston, TX | Arlington, VA | McLean, VA | Seattle, WA | Toronto, Canada | Ottawa, Canada | Calgary, CA