Informix SQL Part 2 Course
Course Description
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.
Course pre-requisites:
Delegates should have attended the Relational Database Design and Informix SQL Part 1 courses or have equivalent knowledge.
Topics covered on the 2 day Informix SQL Part 2 course
- Review of SQL basics
- The SQL optimizer
- Influencing the optimizer
- Transactions
- Concurrency control
- Managing cursors
- Performance issues
- Introduction to stored procedures & triggers
This is an instructor led training course taught in a classroom based environment.
Course Classification:
Technical Training Course
Course Fee = £760 (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
|
