IT Training Courses > Database Training Courses > Informix Courses

Informix SQL Part 2

Further info / book course

Please review the course spec for the Informix SQL Part 2 training course.

Informix SQL Part 2 training course summary
Course Location: Wokingham, Berkshire	Course Duration: 2 days
Course Price: £750.00	Course Reference:

Informix SQL Part 2 Course Outline
This course covers some of the more complex options in SQL querying such as outer joins, self-joins and correlated subqueries. The effects of transaction logging and SQL transactions will be examined. You will look at the query plans created by the optimiser and use them to understand how the query is performed. You will learn how to use optimiser directives available in Informix Dynamic Server. You will be introduced to cursors, stored procedures and triggers. Extensive hands-on experience will be provided. The course will provide you with some ideas of analysing and improving the performance of queries.

Delegates should have attended the Relational Database Design and Informix SQL Part 1 courses or have equivalent knowledge.