Introduction to the Ingres Product and Ingres SQL

Northern Technology Institute (nti) Leeds

Training

In Leeds

£ 1,999 + VAT

The best SQL Server courses

See all

See all

Description

  • Type

    Training

  • Level

    Beginner

  • Location

    Leeds

  • Duration

    5 Days

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 features of Ingres SQL. Make full use of Ingres Database Procedures, Rules, Events, Integrity features. Suitable for: Anyone undertaking other Ingres training: IngresDBM, OpenROAD, IngresABF, ReportWriter, Performance. 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 dataDatabase or development staff who need to work with Ingres database procedures, rules, events, integrities.

Facilities

Location

Start date

Leeds (West Yorkshire)
Old Broadcasting House, 148 Woodhouse Lane, LS2 9EN

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

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

  • Use Ingres SQL in your batch interfaces, reporting, ad-hoc querying, applications
  • 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.
Course outline:

Day 1

Lesson 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 1 Ingres SQL

  • Controlling output
  • Restricting rows
  • Functions

Day 3

Lesson 1 Ingres SQL

  • Combining Tables
  • Sub-queries
  • Views, unions and outer joins
  • Building tables

Day 4

Lesson 1 Ingres SQL

  • Inserts, Updates and Deletes
  • Importing and exporting data from Ingres
  • Transaction processing

Day 5

Lesson 1 Ingres Server SQL

  • Database procedures
  • Rules
  • Database Events
  • Integrity

See related categories

Introduction to the Ingres Product and Ingres SQL

£ 1,999 + VAT

The best SQL Server courses

See all

See all