Peripheral Links
9.6 Administration Webinar
4 Days of Intense PostgreSQL 9.6 training
Classes offered with live instructor online. To access pre-recorded sessions, call or email us with an inquiry. Webinar times are convenient for students in the US, UK and Australia. ON DEMAND pre-recorded sessions are also available.
Day 1 Topics include:
-
Installation and configuration
-
Using psql
-
Databases and Schemas
-
Tablespaces
-
Users, Groups, and Permissions
-
Logging Server Activity
-
Write-Ahead Log Methods
Day 2 Topics Include:
-
Backing Up and Restoring
-
Monitoring the Server
-
SQL and Querying the database
-
Large Objects
-
Transactions and Locks
Day 3 Topics Include:
-
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
Day 4 Topics Include (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
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-892-5315
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.