CÓDIGO: 1X131G
DURACIÓN: 24 Hours
Precio: €450,00
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.
If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course.
http://www.ibm.com/training/terms
This basic course is for basic database users and applications developers.
It is preferred that you have:
Introduction to Structured Query Language
Informix Data Types
The Demonstration Database
Single Table SELECT Statements
SELECT Clauses and Aggregates
Built-In Functions
Joining Tables in a SELECT Statement
Complex Joins
Subqueries
Temporary Tables
INSERT, UPDATE, and DELETE Statements
Other SQL Features
SQL Optimization