Foundations of PostgreSQL Administration

PostgreSQL3
Duration 4 days
40 ITK points
5 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.

The primary audience for this course is individuals who administer and maintain PostgreSQL databases

Understand database architecture
How to install and implement database system
How to configure database system
Create and maintain databases
How to work with user command line tools and GUI tools
How to secure database system
Understand basic database system terms and help
Create Backup and restore strategy
Design and implement database maintenance
How to move data
Using metadata

Intermediate knowledge of RDBMS concepts
Basic understanding of SQL
Basic experience with use of the Linux operating system (helpful)

System Architecture
Installation
Configuration
Creating and Managing Databases
User Tools: Command Line Interface
GUI Tools
Security
SQL Primer
Backup and Recovery
Point in Time Recovery
Routine Maintenance Tasks
Postgres Data Dictionary
Moving Data

Download PDF detail
Download PDF detail (no terms)

The prices are without VAT.

Foundations of PostgreSQL Administration

GOPAS Praha

GOPAS Brno

GOPAS Bratislava

Business details

Foundations of PostgreSQL Administration

Next courses

GOPAS Praha

GOPAS Brno

GOPAS Bratislava

Business details