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, [...]
  • PostgreSQL3
  • Duration 4 days
  • 40 ITK points
  • 7 terms
  • Praha (26 400 Kč)

    Brno (26 400 Kč)

    Bratislava (1 400 €)

  • Intermediate

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.

»
  • 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
  • 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

This course includes 1 complimentary attempt/student at the PostgreSQL Associate certification exam/digital badge.

Current offer
Training location
Course language

The prices are without VAT.