COURSE SEARCH
 
   HOME > COURSES > INFORMIX SQL 4.X INTRODUCTION 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 4.X Introduction




Course Aims
This course will provide the reader the knowledge to create and maintain an INFORMIX database, access the data via Screen Forms, the Structured Query Language and Reports, and create User-Menus.
Assumed Knowledge
Readers require a working knowledge of the UNIX operating system and the vi full screen editor.
Course Audience
Experienced INFORMIX users who are new to SQL.

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

Table of Contents
Database Principles
  • The Database
  • Data Structuring
  • The Advantages and Disadvantages of Using a Database
  • Centralisation
  • The Database Management System
  • Types of Database
  • Relational Database Design
  • Normalisation
     
    Informix-SQL Overview
  • Informix-SQL Facilities
  • The Informix Engines
  • Database Structure
  • Starting Informix-SQL
  • Main Menu Options
  • Sub-Menus
  • Help Facility
     
    Creating a Database
  • Database Options
  • Database Names
     
    Creating a Table
  • Table Options
  • Table Names
  • Column Structure
  • Build the Table
     
    Creating a Default Screen Form
  • A Single-Table Screen Form
  • A Multiple-Table Screen Form
  • The Default Screen Form
  • The Sections of the Default Screen Form
     
    Using a Screen Form
  • Add a Row
  • Alter an Existing Row
  • Add/ Update Control Commands
  • Delete a Row
  • Search for a Row
  • Query Options
  • The Active Table (Multiple-Table Forms)
     
    Screen Customisation
  • Entering the Modify Mode
  • Modifying the Screen Display
  • Modifying the Column Attributes
  • Attribute Parameters
  • Joining Columns
  • Verify Column Join
  • Lookup Joins
  • Instructions Section
  • Composite Joins
  • Column Mask Delimiters
  • Master/Detail Relationships
  • Control Blocks
  • Displayonly Columns
  • Accessing a Form Outside Informix-SQL
    The SELECT Statement
  • Accessing the Structured Query Language
  • Statement Syntax and Comments
  • The Select Statement
  • The Select Clause
  • The From Clause
  • The WHERE Clause
  • The Group By Clause
  • The Having Clause
  • The Order By Clause
  • The Into Temp Clause
  • Functions
     
    The ACE Report Writer
  • Creating a Report
  • The Default Report
  • Sections of the Default Report
  • Modifying a Report
  • The Define Section
  • The Input Section
  • The Output Section
  • The Select Section
  • The Read Section
  • The Format Section
  • Control Block Statements
  • Format Section Control Blocks
  • Aggregate Functions
  • Accessing a Report Outside Informix-SQL
  • OnLine Data Types
     
    Appendix A: Exercise Solutions
  • Appendix A: Exercise Solutions
     
    Appendix B: ANSI Reserved Words
  • Appendix B: ANSI Reserved Words
    TRY BEFORE YOU BUY BECOME A RESELLER
    Thursday 17th May 2012  © COPYRIGHT 2012 - website design by Website Design by Visualsoft