OSS401 - PostgreSQL Administration

OSS401 - PostgreSQL Administration

This course aims at providing the student with the knowledge to exploit and administer a PostgreSQL database.

Syllabus

  •  PostgreSQL Presentation
    1. Concepts
    2. Installation
    3. Create a database
    4. Connection to PostgreSQL and SQL introduction
    5. Tables management
    6. Data types
    7. Postgres SQL language
    8. Configuration
  • Programming with PostgreSQL
    1. Server side
    2. Client side
  • PostgreSQL Administration
    1. Authentication systems, privileges and security
    2. Users management
    3. Backup and restore
    4. Administration tools
  • Log files
  • Optimization
  • Replication
  • Add-ons (XSLT, PostGIS, etc...)

Audience

This course is for anyone who has to administer a PostgreSQL database

Prerequisites

Knowledge of Linux System Administration, SFL201 recommended.

Class training

  • Duration : 2 day(s)
  • Price : 895 $CAD
  • Register : Calendar