Informix SQL Course

This 3-day course is for software developers, analysts, designers, and programmers who will be developing Informix database applications.

Database Development

  • Creating tables, indexes, and databases
  • Implementing referential integrity
  • Controlling data security

SQL Basics

  • Selecting data from a database
  • Specifying records using operators, pattern matching
  • Summarizing records using the "group by" clause
  • Selecting rows from multiple tables
  • Processing NULL values
  • Using outer joins and subqueries
  • Inserting new records
  • Updating and deleting selected data

Embedding SQL

  • Using SQL statements in programs
  • Using the SQLCA structure
  • Retrieving multiple rows with cursors
  • Developing programs with dynamic SQL
  • Executing SQL statements
  • Using record locking and concurrency

SQL Query Optimizer

  • Reading the query plan
  • Improving queries

Contact Us

This course is scheduled by request.

More Info