PostgreSQL Practice Workshop

Level:

Intermediate

Date:

On demand

Duration:

3 days

Dates

Buenos Aires (Argentina):

31.08. – 02.09.2020

 

PostgreSQL trainings and workshops can be held at your location – and anywhere else in the world. Please contact us for details. Contact >>

Audience

This course is especially suitable for database administrators (Linux / Windows / Solaris / Mac OS X) and sysadmis, with less time, who cannot attend the 5 days training.

 

Contact us to sign up for this course >>

Content

Installing PostgreSQL

  • Creating database instances
  • Creating databases
  • Encoding issues

Using indexes

  • Simple btree indexes
  • Full Text search

Understanding transactions

  • Concurrency issues
  • Using savepoints
  • PostgreSQL locking behavior
  • Transaction isolation

MVCC and space management

  • Understanding MVCC
  • PostgreSQL disk layout
  • VACUUM: Reclaiming space
  • Autovacuum

PostgreSQL monitoring

  • Understanding PostgreSQL system tables
  • PostgreSQL system statistics
  • Creating logfiles

Windowing and analytics

  • Analyzing data
  • Using analytics

PostgreSQL performance tuning

  • Tweaking checkpoints
  • Configuring shared_buffers
  • Additional memory parameters

Backup and recovery

  • Running backups

PostgreSQL stored procedures

  • Writing SQL functions
  • Using PL/pgSQL
  • Working with triggers

 

 

Contact us to sign up for this course >>