PostgreSQL, initiation

Ganzatech
Training nature

 

Cycle certifiant

Training duration
4 jours
Training method
Training place

 

Moroni Union of the Comoros

Training Diploma and level
Training teaching type

This course will teach you how to use it efficiently, in particular to create and use a database.

Introduction to PostgreSQL

  • Project history
  • Presentation of projects and tools

 

Secure installation and configuration

  • Installation
  • Installing from sources
  • Installation with a package system
  • Configuration settings

 

User and Group Management

  • Add and remove users
  • Group Management
  • Authentication
  • Granting of privileges

 

Configuring PostgreSQL

  • Installing a Database
  • Starting a database
  • The Postmaster
  • The Postgresql.conf file
  • System Tables

Maintenance of data

  • Importing / exporting data
  • With COPY TO and COPY FROM
  • With Psql
  • Data backup and restore
  • Common Errors
  • Tools pg_dump

Query Optimization

  • The INDEX
  • The PostgreSQL Optimizer
  • The tools EXPLAIN and VACUUM

Public concerné:

  • Developers, operators
  • Anyone who wants to use PostgreSQL or migrate to PostgreSQL.

Others trainings proposed by Ganzatech