Managing Ingres Installations and Databases
Training
In Leeds
Description
-
Type
Training
-
Location
Leeds
-
Duration
5 Days
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. Suitable for: Professional Database System Administrators who are responsible for the maintenance of Ingres databases.
Facilities
Location
Start date
Start date
Reviews
Course programme
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.
You will experience Ingres’ own fantastic 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.
Course outline: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
Managing Ingres Installations and Databases