#FN-613 
Structured Query Language
Course Description
This course covers the Data Manipulation Language (DML) portion of
Structured Query Language. Learn to create SELECT, INSERT, UPDATE, DELETE,
LOAD, and UNLOAD statements, simple and complex joins, and subqueries.
Your New Skills
- Use SQL Data Manipulation Statements (DML) to query and modify data
in an Informix database
- Write simple SELECT statements including joins, subqueries, temporary
tables, and unions
- Write complex SELECT statements including outer joins, self-joins,
and correlated subqueries
- Add and modify data using the INSERT, UPDATE and DELETE statements
- Use LOAD and UNLOAD for bulk data operations
Who Should Attend: Application developers, database and systems
administrators, system analysts, project leaders, technical support
personnel
College Credit: This course has been recommended for college
credit by the American Council on Education.
Prerequisites: FN-611 Relational Database
Design or equivalent knowledge
Length: 3 days
Format: Lecture and hands-on exercises
Course Number: FN-613
Recommended Next Course:
|