Managing Ingres Installations and Databases



Delegates who are responsible for managing an Ingres database, will be trained in all aspects of planning, installation, configuration, and day to day running of the Ingres installation. The most powerful operating platforms available will act as the foundation for covering all aspects of database system administration.

Experience Ingres' own fantastic presentation, demonstrations and practicals to reinforce the course contents. Manage database objects such as tables, indexes, applications, data integrity, security, backup and recovery, table maintenance and optimization.

Recommended for:

This course is for professional Database System Administrators who are responsible for the maintenance of Ingres databases.

You will learn how to:

Build, reconfigure and monitor your Ingres installation

Be aware of the vital tasks that need to be performed to ensure the efficient running of the installation

Understand the roles within Ingres

Use the DBA tools

Understand the major tasks that need to be performed to ensure the efficient running of your Ingres databases

Course outline:

Lesson

Description

Day 1

Roles of the Ingres systems and database administrator

Ingres architecture components

Planning an Ingres Installation

Performing an Ingres Installation

Starting and stopping Ingres

Communications facilities

Logging system

Locking system

Day 2

The Recovery System

Logging and the Recovery Server

The DBMS Server

Configuring Ingres

Configuration-By-Forms

Rules Files

The Master Database

Day 3

User maintenance

Location maintenance

Environment variables

Customising Backup and Recovery

IMA

Creating and destroying databases

System catalogs

Unloading and reloading databases

Day 4

Managing tables, secondary indexes, views

Managing user interface objects

Data integrity and security

Database object access

Authorising and monitoring access

Database and installation privileges

Backing up databases

Day 5

Journaling

Recovering databases

Maintaining and optimizing databases

Overflow

Optimizer and statistics

Benchmarking queries

Maintenance scripts

Managing disk space