55

POSTGRESQL FOR ADMINISTRATION & DEVELOPMENT Course

PostgreSQL course for Administration and Development

Start date: 24.09.2018;

Duration: 40 hours/5 days;

Working hours: 09.00-17.00.

List price: 1,590 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: Install and configure PostgreSQL server access, create users and roles, rights, data types, constraints, classical/special, check, create tables and views and persistent classics

Day 2: Classical and condiționali, index optimization, Query with join-uri, queri, Inheritance, partitioning, disk volumes, special GIN Index/full text search GIST, JSON data,

Day 3: Predefined data/functions, use regular expressions strings, creating and using SQL functions and PL/pgSQL, triggers,

Day 4: Creating data tables-oriented audit log and Use the PostgreSQL database from a programming/scripting language, Use the command line console-psql, Use pgAdmin

Day 5: Large servers configuration for enhanced performance in relation to available memory and existing hardware, Import and export tables, Backup and restore database, Database Replication, high availability, load balancing

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