Scheda corso
NovaNext Training / Database, Bigdata, Data Science & Machine Learning / Computer Science / Preparazione al 'PostgreSQL Essentials Certification Exam v16

Preparazione al 'PostgreSQL Essentials Certification Exam v16

Codice
NOVPOSTPRE
Durata
2 Giorni
Prezzo
1.150,00 € (iva escl.)
Lingua
Italiano - Inglese
Modalità
Virtual Classroom
Corso in aula
       

 

Schedulazione
Luogo Data Iscrizione
A Richiesta

Learn the essentials of administering enterprise-scale data solutions using the different tools available in PostgreSQL; providing the skills required to design, implement, and manage PostgreSQL This understanding will prepare you to install, configure, manage, and maintain PostgreSQL as well as manage large, highly available databases and their security requirements with confidence. 

 

Prerequisiti
  • Basic experience in database administration
  • Intermediate knowledge of RDBMS concepts
  • Basic understanding of SQL
  • Basic experience with the use of the Linux operating system is helpful

 

Destinatari
  • DBAs
  • Other IT Professionals

 

Contenuti
  • Introduction and Architectural Overview
  • System Architecture
  • PostgreSQL Installation
  • User Tools - Command Line Interfaces
  • Database Clusters
  • Configuration
  • Data Dictionary
  • Creating & Managing Databases
  • Database Security
  • Monitoring and Admin Tools
  • SQL Primer
  • Backup, Recovery and Point-in Time Recovery
  • Routine Maintenance Tasks
  • Moving Data
  • Replication and High Availability Tools