Format

Classroom

Duration

3.0 Day(s)

Description

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 (DM).

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