| Fast Facts |
| Course Number:
| RDB147 |
| Course Duration:
| 4 days | |
|
|
| Topic: |
 |
Installation, operation, capabilities, and features of Red Hat Database
| Audience: |
|
IT professionals using Red Hat Database or PostgreSQL
| Price: |
|
| UK | GBP | 1,295 * | | | EUR | 2.000 * |
* all prices excluding VAT
|
|
To have a sales rep contact you about
any of our Products and Services, click here:
|
|
|
| |
RDB147 - Red Hat Database Essentials
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.
| Goal: |
|
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.
| Course Objectives |
|
- 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
|
