Introduction to the Ingres Product and Ingres SQL
Training
In Leeds
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
Start date
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.
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
Introduction to the Ingres Product and Ingres SQL