Introduction to the Ingres Product and Ingres SQL


Price:

£1999


Click here to register your interest

Grapple with the leading Open Source relational database management system that offers commercial services support.

An intensive 5 day course will provide you with all the knowledge and skill base you need to understand and intergrate application development and database management in your business.

Day 1. Focus on Ingres principles and hands-on experience of all Ingres database and development tools.

Day 2-4. Cover all essential aspects of planning, installation, configuration, and day to day running of the Ingres database, development tools and Ingres sql business training.

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.

Recommended for:

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 business training 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 management or development staff who need to work with Ingres database procedures, rules, events, integrities.

You will learn how to:

Understand the principles and importance of Relational Databases

Explore each of the principal Ingres database and development tools

Understand the principles and importance of industrial-strength SQL

Make full use of all the retrieval features of Ingres SQL

Make full use of all the data-change features of Ingres SQL

Make full use of all the database management systems features of Ingres SQL

Make full use of Ingres Database Procedures, Rules, Events, Integrity features

Course outline:

Day 1

Lesson

Description

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

Lesson

Description

1

Ingres SQL

Controlling output

Restricting rows

Functions




 

 

Day 3

Lesson

Description

1

Ingres SQL

Combining Tables

Sub-queries

Views, unions and outer joins

Building tables

   

 

Day 4

Lesson

Description

1

Ingres SQL

Inserts, Updates and Deletes

Importing and exporting data from Ingres

Transaction processing

   

 

Day 5

Lesson

Description

1

Ingres Server SQL

Database procedures

Rules

Database Events

Integrity