Managing Ingres / ActianX Installations and Databases


Code: IngresDBM
Ingres Version: ActianX (11.0)

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 installation under Linux, UNIX, VMS, or Windows.
It covers all aspects of planning, installation, configuration, and day to day running of the Ingres installation. It also covers all aspects of database administration including: managing database objects such as tables, indexes, applications etc.; data integrity; security; backup and recovery; table maintenance and optimization.
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.

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

IngresSQL training, or equivalent experience and skill

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
Rules Files
The Master Database
User maintenance
Location maintenance
Environment variables
Customising Backup and Recovery
Creating and destroying databases
System catalogs
Unloading and reloading databases
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
Recovering databases
Maintaining and optimizing databases
Optimizer and statistics
Benchmarking queries
Maintenance scripts
Managing disk space