RDB147 Red Hat Database Essentials

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