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.
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