4levels teams with the top technology providers to enhance your operations   |   Domains & Hosting   |  Get Support   | My 4levels
GET IN TOUCH
+27 (0)11 848 6229

IBM

4levels-IT-Default-Header

Informix Structured Query Language


Course Description


Overview

In this course, you will learn to write queries using ANSI standard Structured Query Language (SQL) with IBM Informix extensions. You will start with simple queries to select rows from a single table, then advance to more complex queries that involve subqueries or multitable joins. You will learn how to use functions and expressions in SQL statements and how to format the query results. In addition, you will learn how to perform insert, update, and delete operations, and how to select rows that contain large object and other non-standard data types.  

Audience

This is a basic course for database users and applications developers.

Prerequisites

You should have:
  • Basic knowledge of the UNIX or Linux operating system is preferred

Key topics

  • Unit 1: Introduction to Structured Query Language
  • Unit 2: Informix Data Types
  • Unit 3: The Demonstration Database
  • Unit 4: Single Table SELECT Statements
  • Unit 5: SELECT Clauses and Aggregates
  • Unit 6: Built-In Functions: Date and Time Functions
  • Unit 7: Joining Tables in a SELECT Statement
  • Unit 8: Complex Joins
  • Unit 9: Subqueries
  • Unit 10: Temporary Tables
  • Unit 11: INSERT, UPDATE, and DELETE Statements
  • Unit 12: SQL Optimization

Objectives

  • Describe the basic structure of an SQL SELECT statement
  • List and describe the Informix data types
  • Explain the relationship of tables in the Informix demo database
  • Select rows from a single table
  • Use various SELECT statement clauses
  • Obtain query results using aggregate functions
  • Use built-in functions in the SELECT list and ORDER BY clause
  • Write queries that use simple and complex joins between tables
  • Write queries that use subqueries and temporary tables
  • Perform insert, update, and delete operations in a query
  • Control the format of query input and output using functions and operators
  • Use SET EXPLAIN to determine how a query is optimized

Course Duration

3 days
  • Brands we have partnered with to add value to your business


    We are committed to helping our clients reach their business goals

    4levels’ preferred access to the latest technologies, premier technical support and advanced training helps provide you with specialist and customized solutions that help you achieve your business goals.

4levels Solutions sign up form


Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur excepteur sint occaecat cupidatat non

4levels Solutionslogin form