Nabídka tohoto termínu kurzu již není aktuální. Podobné kurzy naleznete zde.

PostgreSQL Administration

David Solnař

Kurzem Vás provede David Solnař

Základní info

Popis kurzu

This course is intended for beginning and intermediate users and administrators who will learn everything needed to use this database system effectively and will also prepare students for the daily management of PostgreSQL databases, backup, recovery, replication, monitoring and optimization.

Cíle kurzu

  • Understand the architecture of the database system
  • Perform installation and implementation of the database system
  • Necessary and recommended steps leading to optimal configuration
  • Create and manage databases
  • Use custom command line tools and GUI
  • Properly configure and ensure the required level of security
  • Use help and illuminate basic concepts
  • Theory and practical implementation of backup and recovery of databases
  • Maintenance tasks to ensure efficient system operation
  • Perform data moving
  • Understand metadata

Určeno pro

IT specialists who want to learn how to effectively manage the PostgreSQL database system.

Obsah kurzu

  • PostgreSQL database system architecture
  • Introduction to administration - installation, cluster creation, connection to the server
  • Configuration - connection, authentication, WAL, log and other settings
  • Creation and administration of databases - databases, schemas, roles, users, groups
  • Using pgAdmin
  • Security basics - configuration, access control, ownership
  • SQL Primer - data types, basic queries, functions, constraints, views, indexes
  • Maintenance - Query plan, statistics, vacuum, index maintenance
  • Transactions and competitive approach
  • Extension modules
  • Data transfer
  • Backup and recovery - backup types and strategies
  • Point in Time Recovery
  • High availability and replication
  • Monitoring
  • Performance tuning

Studijní materiály

Materials in electronic form

Návaznosti

PostgreSQL Programming

PostgreSQL Administration

Vybraný termín:

10.5.2021 –  12.5.2021  ONLINE

Cena
16 000 Kč + 21% DPH

Kontaktovat dodavatele


Kontrola proti spamu. Kolik je pět a pět ? Součet zapište číslicemi.