Ingres Database for Oracle DBAs

Code: DBM_ORA
Days: 3
Ingres Version: 9.2

You will learn:

At the end of this course you will be able 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 Style

This course is aimed at delegates who will be responsible for managing an Ingres database and have previous similar experience with Oracle.

It covers basic aspects of planning, installation, configuration, and day to day running of the Ingres installation. It also covers basic aspects of database administration including: managing database objects such as tables, indexes, backup and recovery; table maintenance and optimisation.

The course employs lectures, demonstrations and practicals to reinforce the course contents.

The course does not focus on a particular operating system but uses examples for the Linux, Unix, Windows and VMS operating systems throughout the course material.

Who Should Attend

This course is for Database and System Administrators with previous Oracle experience who are responsible for the maintenance of Ingres databases.

Prerequisites

Working knowledge of Oracle RDBMS.

Key Topics

• 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
• The Recovery System
• Logging and the Recovery Server
• The DBMS Server
• Configuring Ingres
• The Master Database
• User maintenance
• Location maintenance
• Environment variables
• Creating and destroying databases
• System catalogs
• Unloading and reloading databases
• Managing tables, secondary indexes, views
• Backing up databases
• Journaling
• Recovering databases

Agenda - Day 1

• Installing Ingres (covers Linux/UNIX & Microsoft Windows)
• Ingres architecture
• Query Tools
• Databases
• Tables
• Table Management

Agenda - Day 2

• Storage Structures
• Secondary Indexes
• Logging and Recovery
• The Locking System
• Other Database Objects

Agenda - Day 3

• Data Security (overview)
• Data Integrity (overview)
• Database Backup and Recovery
• The DBMS Server
• Configuration (overview)
• Optimisation (overview)

Next Topic

Ingres Performance (PERF)

Class Dates