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
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.