P o l y m o r p h i c S o l u t i o n s

Home > Education > Course Outlines > Ingres

Education

Ingres II Database Administration Course Outline

Duration

4 days

Overview

This course is aimed at students who will be responsible for managing an Ingres database (Ingres DBMS). It covers all aspects of database administration including:

managing database objects such as tables, indexes, applications and others
data integrity
security
backup and recovery
table maintenance and optimisation

The course does not focus on a particular operating system but uses examples for VMS, UNIX and Windows/NT operating systems throughout the course material. The workshops are performed under UNIX and sometimes under Windows/NT. Students in this course should strongly consider following with the "Ingres II System Administration" course.

Upon completion of this course students will be able to:

Describe the underlying database concepts such as architecture basics, transaction management and managing access control
Define the tasks peculiar to database administrators
Have a fundamental understanding of the Ingres II architecture
Enforce data integrity and security
Perform the backup and recovery of the database

Audience

Database and systems administrators responsible for the maintenance of Ingres databases.

Prerequisites

Completion of the Introduction to Ingres II (OI145) and Using Ingres II SQL (OI130) courses, or equivalent experience, together with experience of using an Ingres DBMS are the prerequisites for this course. A good understanding of the chosen operating system is also beneficial.

Format

Instructor-led class consisting of lectures, demonstrations and hands-on lab exercises.

What will you Learn?

Roles of the Ingres DBMS Systems and Database Administrator
Overview of Ingres DBMS Architecture
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
Journaling
Recovering Databases
Maintaining and Optimising Databases
Overflow
Optimiser and Statistics
Benchmarking Queries
Maintenance Scripts
Managing Disk Space

Want more information?

View course dates, register on-line, or for more information (or a registration form) email the Education Manager, or call our office on +61 7 3236 5588.

Announcements

The Mental Health Council of Australia chooses ChilliDB as its enterprise CRM February 2010
The Mental Health Council of Australia (MHCA) is the peak, national non-government organisation representing and promoting the interests of the Australian mental health sector, committed to achieving better mental health for all Australians.
More...

Events

SQL & Databases Training Courses Brisbane Queensland
The course offers end-users a sound background on the concepts of a Relational Database Management System.
More...

Newsletters

Poly News - May 2010
Our third News Letter features the following articles, A Report on Technology Capacity in Australia's Not-For-Profit Sector in 2008, QCOSS Conference, ChilliDB 2.6 Release, Tips & Tricks of the Month, Staff Profile and our Upcoming Public Courses.
More...

Press Releases

Campbell Page chooses ChilliDB as its enterprise CRM
Campbell Page is an Australian, award winning, not-for-profit organisation operating from over 80 locations.
More...