PostgreSQL Training

Posted by admin - 03/11/09 at 10:11 pm

Installing & Configuring PostgreSQL

• Host access control with pg_hba.conf
• Configuring PostgreSQL for secure access with OpenSSL

Using the psql client
Creating & Managing Indexes

• Creating Indexes
• Indexes on expressions
• Partial indexes

Transactions and Concurrency
Managing database privileges

• Understanding PostgreSQL roles
• User Roles
• Assigning users to roles
• Understanding role access

Access control with GRANT
PostgreSQL data organization

• PostgreSQL storage
• Managing table space usage
• PostgreSQL log directories
• Other directories
• Managing PostgreSQL clusters

Creating & Managing PostgreSQL tablespaces and databases
PostgreSQL Schemas
PostgreSQL logging
Backup and recovery
Performing Point-in-time recovery (PITR)

• PostgreSQL Write-ahead logs
• Performing PITR backups
• Performing PITR recovery

Writing triggers & stored procedures with PL/pgSQL
Understanding the PostgreSQL query optimizer

• Using explain and explain analyze to optimize queries & indexes

Server monitoring & performance tuning
Using PostgreSQL modules & add-ons

• Connection pooling with pgpool
• Database replication with Slony
• Full Text indexing with tsearch2

This entry was posted on Tuesday, November 3rd, 2009 at 10:12 pm and is filed under lamp courses. The entry is tagged under PostgreSQL, Postgresql Learning, Postgresql Microsoft SQL, Postgresql MySQL Training, Postgresql Online Courses, Postgresql Online Training. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.