Informix SQL training – 2 days – private courses from £1790 + vat

Informix SQL training uk

This is a two day Informix SQL course for application developers and end users who have a working knowledge of Informix-SQL. Practical exercises are a significant feature of this course and are used throughout to consolidate the theory.

Informix SQL Training Course Objectives

On completion of this Informix SQL course delegates will be able to:

Understand relational database terminology
Understand the structure of Informix database tables
Query and maintain data
Develop queries based on one or more tables in a database

Informix SQL Training Course Content

Basic concepts of relational database design
Entities, attributes, Primary and Foreign Keys
Connecting to a database
Understanding the structure of database tables
Informix data types, indexes and NULL values
Constructing Informix SQL statements
Running, modifying and saving SQL scripts
Re-directing the output of queries
Building a simple query
Using aggregate functions AVG, MAX, MIN, SUM, COUNT
Building expressions into the select list
Using display labels
Applying filter conditions using the WHERE clause

Using LIKE, MATCHES, BETWEEN and IN
Using the ORDER BY clause to sort the output of data
Understanding the GROUP BY clause
Selecting data into a temporary table
Selecting data from more than one table in the database
Simple and outer table joins
Inserting, updating, and deleting data
In-built functions: USER, TODAY, and CURRENT
Date manipulation functions
Introduction to transaction logging
Using the BEGIN/COMMIT/ROLLBACK WORK statements
Unloading data and loading data using ascii files

Informix SQL Course Prerequisites

Familiarity with the windows environment and relatonal database concepts.

Informix SQL Training Recommended Reading

Programming Informix SQL/4GL - Cathy Kipp – buy from amazon

home book this course resources 01273 622272 info@siliconbeachtraining.co.uk