Informix Structured Query Language (SQL) IX131G

 

Czas trwania – 24 Hours

Basic

Informacje o szkoleniu

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.

Co warto wiedzieć przed szkoleniem?

You should have:

Basic knowledge of the UNIX or Linux operating system is preferred.

 

 

Dla jakiej grupy odbiorców jest dedykowane szkolenie?

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

 

Zagadnienia

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