Training » All Courses » SQL Database » PostgreSQL

Course Summary

PostgreSQL Administration class is designed for DBAs and developers who are looking to install, administer, and use this powerful database system.

Duration

2 days.

Objectives

This class covers the basics of installing, managing, administering PostgreSQL database system.

Audience

This course is for anyone who is tasked with administering a PostgreSQL database.
Students attending this course should be familiar with SQL and feel comfortable working in a Linux/UNIX -type environment.

Instructors

Outline


PostgreSQL presentation

  • Concepts
  • Installation
  • Create a database
  • Connection to PostgreSQL and SQL introduction
  • Tables management
  • Data types
  • Postgres SQL language
  • Configuration

Programming with PostgreSQL

  • Server side
  • Client side

PostgreSQL Administration

  • Authentication systems, privileges and security
  • Users management
  • Backup and restore
  • Administration tools

Log files

Optimization

Replication

Add-ons (XSLT, PostGIS, etc...)