PostgreSQL Essentials

• DBAs
• Other IT Professionals

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.

• 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

• 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

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

Next courses

Advanced PostgreSQL Administration [PostgreSQL4]