Skip site navigation (1) Skip section navigation (2)

Intense PostgreSQL Training

Date: 2013-11-11 – 2013-11-14
Location: Ontario, California, United States
Language: English

In this course you will gain working knowledge and skills needed to perform PostgreSQL Administration tasks including: PostgreSQL architecture, configuration, maintenance, backups, recovery, writing functions, replication, and monitoring.

4 Days of Intense PostgreSQL 9.3 training covering:

  • Building and installing PostgreSQL
  • Creating databases and schemas
  • Users and access control
  • Logs
  • Window Functions
  • Writing effective PostgreSQL code
  • Modifying SQL
  • Using views and rules
  • Understanding indexes
  • Connection Pooling
  • Administration
  • Server side programming (PL/pgSQL, C)
  • Window Functions
  • Backups
  • Monitoring
  • Large objects (Blobs)
  • Transactions (including serializable snapshot isolation)
  • Concurrency issues
  • Views
  • Triggers
  • Rules
  • Query plans and basic optimization
  • Importing and exporting data
  • VACUUM
  • Write-Ahead Log and Checkpoints
  • Replication (Hot Standby)
  • User rights

After being lectured on a topic, students will gain hands-on experience by doing exercises on the presented material.

Prerequisites: Students should be familiar with working in a Linux environment and have basic SQL skills.

For more information visit moderncourse.com

call 1-866-365-4911

Or email training@moderncourse.com

Posted by Modern Course (training@moderncourse.com).

Note: The PostgreSQL Global Development Group does not endorse any events run by third parties. No guarantee of the quality of events is offered whatsoever.


Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group