Informix SQL Part 1 Course
- this course is no longer scheduled to run. Please refer to schedule for current course titles.
Course DescriptionThis 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.
|
£ 3 day course Scheduled Dates: |
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
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