Course Style

This course provides you with all the knowledge and skill you need to:

undertake the Ingres Application Development and Database Management courses

understand and assess the role of Ingres in your organisation.

It has 3 sections: day 1 focuses on Ingres principles and hands-on experience of all the Ingres database and development tools; days 2-4 cover all the essential aspects of Ingres SQL; day 5 covers Database procedures, rules, events, and integrity features. The course is a mixture of lecture and demonstrations with hands on practical exercises for all key topics.

Who Should Attend

This course is an essential prerequisite for anyone undertaking other Ingres training: IngresDBM, OpenROAD, IngresABF, ReportWriter, Performance. Others who will benefit from attendance on this course are:

Managers or IT staff who need to understand or assess the Ingres principles, tools and capabilities (for those who only need this, attendance on Day 1 is sufficient).

IT or other staff who need to use Ingres SQL to retrieve or change their database data.

Database or development staff who need to work with Ingres database procedures, rules, events, integrities.

Prerequisites

No knowledge of Ingres or SQL is assumed.

Key Topics

Day 1: Ingres Overview

Introduction to Ingres

Relational Concepts and Ingres

Ingres Basic Tools: ISQL, Tables, QBF, ReportWriter

Ingres Visual Tools: VSQL, IVM, VDBA, IMP

Ingres Development Tools: OpenROAD, ABF/Vision

Day 2-4: Ingres SQL

Controlling output

Restricting rows

Functions

Combining Tables

Sub-queries

Views, unions and outer joins

Building tables

Inserts, Updates and Deletes

Importing and exporting data from Ingres

Transaction processing

Day 5: Ingres Server SQL

Database procedures

Rules

Database Events

Integrity

Next Course

We have clear learning paths, so there is an appropriate course whatever your current expertise and knowledge. You can continuously advance your understanding and skills with Actian solutions by following the learning paths below.

Whether you are new to Ingres or an old hand, our education courses are designed to make sure you learn how to make best use of the advanced features and functionality in the latest release. For inquiries about our education programs, please email education@actian.com, or formations@actian.com (FR).

The Ingres Instructor-Led Online Training environment is an alternative to our traditional in-class training, without the need for expensive travel.

Ingres ILO Environment

Our ILO environment provides

Interactive, instructor led training

Live demos

Pre-configured remote lab environment

Classes available to suit your timezone

PDF handouts of course material

"Closed" ILO Class

Efficient training for coworkers across multiple locations. If your team is geographically dispersed you can also request that our instructor-led online format be delivered as a "Closed" course for your company.