Informix SQL Part 1 Course
- this course is no longer scheduled to run. Please refer to schedule for current course titles.
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
Course Classification:
Technical Training Course
This is an instructor led training course taught in a classroom based environment.
Scheduled course dates
| September 2010 | October 2010 | November 2010 | December 2010 | January 2011 |
| - | - | - | - | - |
Print / Download PDF Version of full course schedule
If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite Database Training and bespoke Database courses