Course Description

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.

What you will learn:

Course Outline

• 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

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.

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.

Volume discounts:

If your company needs to train more than one employee at the same time, take advantage of our multi-student discounts.

Class times:

• Monday through Thursday
  • Start: 9:00am
  • End: 4:30 to 5:00pm (depending on class progress)