Informix SQL Part 1 Course
Course Description
This course teaches you the Data Manipulation Language (DML) statements for the Structured Query Language (SQL), including SELECT, INSERT, UPDATE and DELETE. You will discuss simple and some complex ways of joining data. This course includes abundant hands-on exercises. At the end of the course, you will be able to query and modify data in an Informix database.
Course pre-requisites:
Delegates should be familiar with relational databases.
Topics covered on the 3 day Informix SQL Part 1 course
- Introduction to SQL
- Single table SELECT statements
- SELECT clauses and aggregates
- Time functions
- String functions
- Additional functions
- Joins
- Complex joins
- The UNION operator
- Subqueries
- INSERT, UPDATE, DELETE, LOAD and UNLOAD
This is an instructor led training course taught in a classroom based environment.
Course Classification:
Technical Training Course
Course Fee = £1140 (excl.VAT)
Scheduled course dates
| September 2008 |
October 2008 |
November 2008 |
December 2008 |
| - | - | - | - |
|
|
If you want to attend the course but can't make the dates published then click here for details of our one-to-one training packages.
PTR Associates Limited
21A Peach Street, Wokingham, Berkshire, RG40 1XJ, United Kingdom
Tel: 0118 979 4000 Fax: 0118 979 4035
Email: training@ptr.co.uk
|