RDB147 - Red Hat Database Essentials

Course Summary

Red Hat Database Essentials is an intensive four-day course for a variety of IT professionals that provides four days of instruction and hands-on lab activities on Red Hat Database, an object-relational database powered by PostgreSQL.

RDB147 Red Hat Database Essentials Description

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:

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