COURSE SEARCH
 
   HOME > COURSES > INFORMIX SQL ADVANCED MEMBERS LOGIN 
UNLIMITED ACCESS TO OVER 575 ONLINE TRAINING COURSES FOR ONE ANNUAL PAYMENT OF ONLY $149 USD
BUY NOW
  HOME     COURSE LIBRARY     QUESTIONS & ANSWERS     CONTACT US
There are many excellent online courses. This has been hugely beneficial in my day to day work.
- Louise Nolan


Informix SQL Advanced




Course Aims
This course will provide the reader with the knowledge to control database security and integrity, perform advanced database queries, optimise query efficiently and control the database within the UNIX environment
Assumed Knowledge
Readers will require a thorough knowledge of INFORMIX-SQL basics, a working knowledge of the UNIX operating system and the vi full-screen editor
Course Audience
Experienced Informix users who wish to know more about this product and its uses.

This course can be found in the following categories:
Courses > Databases > Informix

Table of Contents
Index Theory
  		• Index Structure
  		• Types of Index
  		• Composite Indexes
  		• The Do's and Don'ts of Indexing
  		• Creating an Index
  		• Clustered Indexes
  		• Indexes
     
    Advanced SELECT Statements
  		• Conditions with a Subquery
  		• Outer Joins
  		• Union
  		• The Intersection and Difference Set Operators
  		• Self Joins
  		• Synonyms
  		• Advanced Select
     
    Query Optimisation
  		• The Informix Query Optimiser's 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
     
    Database Security and Privileges
  		• User Privileges
  		• Views
  		• Transaction Logging
  		• Audit Trails (Standard Engine only)
  		• Database Security
     
    Concurrency Control
  		• Locks
  		• Data Maintenance Locks
  		• The Lifespan of a Lock
  		• Types of Lock
  		• Lock Granularity
  		• Isolation (OnLine Engine only)
  		• Set Lock Mode
  		• Concurrency
     
    Command Line Interface to Informix-SQL
  		• Invoking the Complete Menu System
  		• Using isql Without Any Menus
  		• Invoking an isql Sub-menu
  		• Invoking a Sub-menu Option
  		• Running Forms and Reports
  		• The dbschema Utility
  		• Using the Command Line
    Environment Parameters
  		• Both Standard and OnLine Engines
  		• Standard Engine
  		• OnLine Engine (All Versions)
  		• OnLine Engine (Version 6+)
     
    The System Catalogue
  		• Introduction
  		• sysblobs (OnLine only)
  		• syschecks
  		• syscolauth
  		• syscoldepend
  		• syscolumns
  		• sysconstraints
  		• sysdefaults
  		• sysdepend
  		• sysindexes
  		• sysopclstr (OnLine only)
  		• sysprocauth
  		• sysprocbody
  		• sysprocedures
  		• sysprocplan
  		• sysreferences
  		• syssynonyms
  		• syssyntable
  		• systabauth
  		• systables
  		• systrigbody
  		• systriggers
  		• sysusers
  		• sysviews
  		• Informix-Sql Specific System Tables
  		• upscol Specific System Tables
     
    Appendix - Course Database
  		• Appendix - Course Database
    TRY BEFORE YOU BUY BECOME A RESELLER TERMS & PRIVACY
    Monday 21st May 2012  © COPYRIGHT 2012 - website design by Website Design by Visualsoft