Hatha

PostgreSQL 9.3 Webinar

The Modern Course offers the most comprehensive PostgreSQL training available anywhere. This class has something to offer everyone!
The course spans 4 Days, covering installation, system administration, and database development. Students may choose the days that they attend. After being lectured on a topic, students will gain hands-on experience by doing exercises on the presented material. Students may purchase access to all four days or any combination of the offered training days.

The class runs from 8:00 am - 12:00 pm PST/PDT daily.

Connection details will be emailed 7 days before the start of the webinar.

All of our courses can be tailored and delivered at your worksite. For groups of four or more, we offer affordable on-site training. Call us today for more information. 1-866-365-4911

Length in Days:

This course is offered on PostgreSQL 9.3. PostgreSQL is an exceptional relational DBMS that supports most SQL constructs, including subselects, transactions, triggers and user-defined types and functions. It is by far the most useful open-source database available, and The Modern Course offers the most comprehensive PostgreSQL training available anywhere.

Time

The classes run from 8am - 12pm

Pricing

The cost of the day training is $197.00
The four days are $749.00
After you register you may pay online, by phone, or print an invoice. Registering online will reserve your online seat for the specified webinar date.

Prerequisites

This course is for anyone who is tasked with administering a PostgreSQL database. Students attending this course should be familiar with SQL and feel comfortable working in a Linux/UNIX -type environment.

Course Outline

Day 1 (Monday):

PostgreSQL Installation and Configuration

* Installation and configuration
* Using psql
* Databases and Schemas
* Tablespaces
* Users, Groups, and Permissions
* Logging Server Activity
* Write-Ahead Log Methods

$197

Day 2 (Tuesday):

PostgreSQL Administration Topics of Interest:

* Backing Up and Restoring
* Monitoring the Server
* SQL and Querying the database
* Large Objects
* Transactions and Locks

$197

Day 3 (Wednesday):

PostgreSQL Administration Continued:

* Concurrent Indexing
* Full Text Indexing and Searching
* Understanding Query Plans
* Indexes & Advanced Optimization
* Vacuum and the Free Space Map
* Streaming Replication
* Session Pooling
* Views/Rules



$197

Day 4 (Thursday):

PostgreSQL For Developers

* Extending the Server with SQL and PL/pgSQL Functions
* Extending the Server with C
* Extending the Server with Java
* Extending the Server with Perl
* Window Functions
* Triggers and Rules
* Accessing PostgreSQL Using libpq



$197

All 4 days offered at $749

Class Schedule

Guarantee

" Our classes have no minimum amount of students and are guaranteed to run"

Chris Ulloa

Technical Director


Onsite Request

Number of Students:
1-5     6-10     11+