Training

Advanced SQL

A practical Advanced SQL course — indexing, advanced SELECT and subqueries, query optimisation, and security & integrity.

Indexing

Index Structure

The Dos and Don'ts of Indexing

Creating an Index

Clustered Indices

Advanced Select

Advanced Select

Subqueries Returning Multiple Values

Using the EXISTS Condition

The Intersection and Difference Set Operators

Query Optimisation

Query Optimisation

Optimiser Requirements

The SET OPTIMIZATION Statement

The Informix Query Optimisation Process

The SET EXPLAIN Statement

The Order of SELECT Statement Clause Processing

Database Optimisation

User Optimisation of a Query

Security & Integrity

Security and Integrity

Database Access

Object Level Privileges

Transaction Work