RDB147 - Red Hat Database Essentials - PostgreSQL

Goal:

Become a DBA, system administrator, or developer with a solid understanding of the installation, operation, capabilities, and features of Red Hat Database.

Audience:

IT professionals using Red Hat Database or PostgreSQL, including database administrators, system administrators, application developers, and web developers.

Prerequisites:

• RH033 Red Hat Linux Essentials or equivalent experience at a minimum.
• RH133 Red Hat Linux System Administration desirable.
• Previous experience with a relational database is beneficial, but not required.

Duration: 4 days (32 Hrs.)

What you will learn:

• Types of databases
• Database terminology
• Features and architecture of Red Hat Database (PostgreSQL)
• Installation
• Creating a new database
• Adding users
• Authentication and host access
• Catalogs
• Run-time parameters and options
• SQL syntax and usage
• psql query utility
• Data types and operators
• Transactions
• Locking
• Multi-version concurrency control
• Write-ahead logging
• Indexes
• Cursors
• Table manipulation
• User-defined types
• Stored procedures and triggers
• Storage clustering
• Performance tips
• Backup/Restore considerations