57

POSTGRESQL FOR IMPLEMENTATION & ADMINISTRATION

Course Duration: 40 hours/5 days (8 hours/day)

Working hours: 09.00-17.00

Price: 1800 Euros/person + VAT

The price includes: course support in electronic format, lunch, coffee break, ANC and ANC diploma exam.

The course is accredited according to the standard-occupational ANC Programmer-351201 CHORUS. The diploma is recognized by the Ministry of labour, family and social protection and the Ministry of education, research and innovation and professional skills of all attest to this occupation

The exam lasts two hours and the ANC consists of a theoretical sample (quiz) and a practice.

Course syllabus:

Day 1

Server setup and configuration

Database roles and client authentication

SQL-date types, functions and operations, type conversions

SQL-Date definition views

Day 2

SQL-Queries, joins, aggregates

SQL-data access, indexes, optimisations

Inheritance, partitioning, disk volumes

Full text search, GIN/GIST indexes, JSON types

Day 3

Concurrency Control, transactions, locking

Functions, using regular expressions for finding date

SQL and PLPgSQL functions

Triggers

Day 4

Information log and audit oriented strategies for creating tables

Using the PostgreSQL clients from a scripting language

Database maintenance using command line utility-psql

Monitoring database activity using pgAdmin

Day 5

Managing Databases, maintenance tasks

Database export and import

Backup and Restore

High Availability, Load Balancing, and Replication

Each lesson has a two-hour presentation of the theoretical and practical test, then exercises carried out by each student.

Book a seat at the course

Please fill out the form to book a place at this course:

Invalid Input
Invalid Input
Invalid Input
Invalid Input
Invalid Input
Invalid Input
Invalid Input
Invalid Input