Consult our trainings :

Digital
Technologies

Management
Personal Development

Business
Administration

> formation Technologies numériques > formation SGBD > formation MySQL, PostgreSQL et autres SGBD > formation PostgreSQL, administration

PostgreSQL, administration Training

Name: Formation PostgreSQL, administration
SKU: PGA

Stage pratique

Best

Duration : 3 days

Ref : PGA

Price 2020 : 1840 € excl. taxes

Free breaks and lunches

Program
Participants / Prerequisite
Intra/Tailored

Program

Instructional goals

Learning objectives

Installing the PostgreSQL DBMS
Determining the main features of PostgreSQL database administration
Creating and managing a database
Managing access to users
Managing database security.
Participants

PROGRAM

» Overview of PostgreSQL

Overview of projects and tools.
Comparison with other RDBMS engines.

» Installation

Steps of installation.
Linux distributions: From RPM or source code.
Binaries for MS-Windows. Installation wizard. Preparing the operating system.

» Initializing and executing an instance

Principle. Shutting down and rebooting the server.
Server process architecture.
Creating additional instances.

» Connections and administrative tools

Sessions. Server side (pg_hba.conf). Security (SSL, etc.).
Access rights Role management (users and groups). Granting and revoking privileges.
Comand line and graphical tools. psql (shell SQL). PgAdminIII, phpPgAdmin, Pgpool.

» Defining data

Creating schemas, tables, indices, domains, etc.
Types of data, operators, and functions.

» Programming for administration

Server side Stored procedures. PL/pgSQL. PL/Perl. C extensions. Triggers.
Stored functions.
Client side. PHP Web applications. PostgreSQL and PDO drivers. Java Web applications.

» Routine administration

Defining files. Creating namespaces (tablespaces, files).
Directory tree and server files.
Server administration. Configuration. Binary logs and memory.
The statistics collector and activity logs.
Maintenance and operating tasks. Analyzing queries with Explain.
Analyzing and cleaning up table and index spaces with Vacuum.
Reconstructing indexes with Reindex.

» Backups and restores

Backups with pg_dump and pg_dumpall.
Restores with pg_restore and psql.
Binary logs: Write Ahead Logging (WAL).

PDF

Send

Participants / Prerequisite

» Participants

Prerequisites

» Prerequisite

TRAINING PROGRAM

Intra/Tailored

For how many persons*

Preferred Cities*

Preferred Dates*

Comments

Contact Informations

Gender*

Name*

Surname*

Company*

Establishment

Department*

Address*

City*

Zip code*

Country*

Phone*

Professional email*

By checking this box, I certify that I have read and accepted the conditions for the use of my data regarding the General Data Protection Regulation (GDPR).

You can at any time modify the use of your data and exercise your rights by sending an email to rgpd@orsys.fr

By checking this box, I agree to receive commercial and promotional communications from ORSYS Training*. You can unsubscribe at any time by using the link included in our communications.

Book your place

Click on a session for reserving.

Time schedule

Generally, courses take place from 9:00 to 12:30 and from 14:00 to 17:30.

However, on the first day attendees are welcomed from 8:45, and there is a presentation of the session between 9:15 and 9:30.

The course itself begins at 9:30. For the 4- or 5-day hands-on courses, the sessions finish at 15:30 on the last day