Accessing the DB2 UDB For iSeries Database for SQL (OL37)

Format

Classroom

Duration

3.0 Day(s)

Description

SQL is a very powerful programming and database language that is widely used in business today. For example, SQL can be used to perform interactive database queries as well as to extract data from a server and pass that data to a Java applet running on a client PC. SQL is frequently used in AS/400 high level languages as an alternate means to access the database.
This course is designed to teach AS/400 programmers and users how to access AS/400 database files using the SQL language. Students will learn how to create, maintain and query the database using the interactive SQL interface and Operations Navigator.
Query Manager, a tool for SQL users, that allows you to design and store SQL queries, will also be covered.

Audience

This course is designed for experienced AS/400 programmers and AS/400 users who want to learn how to use the SQL programming language as a means to access the "DB2 UDB for AS/400" database.
This course is not recommended for users who want to perform simple queries.
Query/400 is a better end user tool for this purpose. You can learn about Query/400 by attending OE14V2/S6114.

Prerequisites

Objectives

After attending this class, the student should be able to:
* use Data Definition Language (DDL) to describe tables and views
* use UPDATE, INSERT, ALTER and DELETE to modify SQL tables
* use the SELECT statement to extract data from tables and views
* code SQL queries that include column and scalar functions
* code SQL queries that include inner and outer joins
* use SQL Query Manager to design and maintain SQL queries

Contents

1. SQL Concepts
2. SQL Objects and Data Definition
3. Extracting Data Using SELECT
4. Functions
5. JOIN and UNION
6. SubSELECTs
7. SQL Query Manager