|Kurskode||1X131NO||Leveringsform||Web Based Training|
NOK 2 994,00 u. moms
NOK 2 994,00 m. moms
This is a self-paced online course. The average amount of time to complete this course is 32 hours. Once you receive your access information, you will have 1 year to complete this course.
Please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access the course.
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.
The self-paced format gives you the opportunity to complete the course at your convenience, at any location, and at your own pace. The course is available 24 hours a day. Once you have accessed the course, instructor help is available via the course forum Monday through Friday; questions will be responded to within 24 hours.
Introduction to Structured Query Language
Informix Data Types
The Demonstration Database
Single Table SELECT Statements
SELECT Clauses and Aggregates
Joining Tables in a SELECT Statement
INSERT, UPDATE, and DELETE Statements
Other SQL Features