Oninit
Talk to an expert →

Advanced Informix-SQL

A two day course for application developers and end users who have a working knowledge of Informix-SQL. Practical exercises are a significant feature of this course and are used throughout to consolidate the theory.

Course Objectives

On completion of this course the delegate will be able to:

  • Use advanced SQL constructs for queries and data maintenance
  • Optimise slow-running queries
  • Understand the role of indexes and how they are maintained
  • Use views as a security feature or to simplify data retrieval

Prerequisites

Familiarity with Informix-SQL.

Course Content

  • Overview of database structure and terminology
  • Primary Keys, Foreign Keys and relationships
  • Review of SELECT statement
  • More advanced features of SELECT using table aliases, distributed queries, using GROUP BY and HAVING
  • Special relationships between tables, self-joins and outer joins
  • Combining information from queries using UNION
  • Using subqueries
  • Understanding the variations in subquery syntax
  • Co-related subqueries
  • Subqueries in UPDATEs and DELETEs
  • Additional syntax within SELECT
  • The FIRST clause, the CASE test
  • Converting null values and other data within the query
  • Manipulating date and datetime columns
  • Substringing and case manipulation functions
  • The effect of indexes
  • Indexing guidelines
  • Using SET EXPLAIN to diagnose efficiency problems within queries
  • Understanding and using optimiser directives
  • Benefits of using views
  • Creating and removing views on the database
  • Using views as a security feature
  • Multi-table views
  • Restrictions on views
  • Permission issues with using views
  • Running SQL statements directly from Unix
  • Tracking progress of scripts
  • Running dbaccess interactively

Quotes from previous delegates

A very good atmosphere whereby delegates feel relaxed and not afraid to ask questions when experiencing difficulties.

Yet again the lecturer gets 10 out of 5.

If you would prefer a personalised course then please contact us to discuss your requirements. Oninit® will then provide a proposal to ensure that your staff receive the training they need to optimise their performance and your system.