Day 1 Topics include:
Installation and configuration
Databases and Schemas
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
Transactions and Locks
Day 3 Topics Include:
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
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
Or email email@example.com
Posted by Modern Course (firstname.lastname@example.org).
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.