PURPOSE :
This course provides an introduction to the SQL language and applies to the entire DB2 Family.
It is appropriate for customers working in an OS/390, VM/VSE, AIX, Windows, or OS/2 environment.
AUDIENCE :
Everyone needing to perform SQL queries in practice, for example, end-users, programmers, application designers, database administrators, and system administrators who do not yet have knowledge of the SQL Data Manipulation Language (DML).
PREREQUISITES :
Basic computer literacy
Basic editing skills
No database skills are required
OBJECTIVES :
After completing this course, you should be able to:
Write basic SQL statements
Use (write) SELECT, INSERT, UPDATE, and DELETE statements
Use simple CREATE TABLE and CREATE VIEW statements
CONTENTS :
This course covers the following major topics:
Structure and Elements of SQL
SQL Queries
Retrieving Data from Multiple Tables
Scalar Functions and Arithmetic
Column Functions and Grouping
Combination of Multiple Result Tables
Using Subqueries
Maintaining Data
This is a version-specific reference outline. Confirm the current syllabus and delivery arrangements with EIEIO.