Accessing the DB2 UDB for iSeries Database using SQL (OL37AU)

IBM Australia Ltd
Sydney,Melbourne,PERTH,BRISBANE,CANBERRA CITY, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Duration 2.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 highly skilled 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.

Audience This course is designed primarily for experienced AS/400 programmers. However, very skilled AS/400 users who want to learn how to use the SQL programming language as a means to access the DB2 UDB for iSeries database may also consider attending this class.
This course is Not recommended for users who need to perform simple queries. Query/400 is an end user oriented tool designed for this purpose. You can learn about Query/400 by attending courses OE14AU and OE15AU.

Prerequisites Before attending this class, the student should be able to:
use a Windows based PC
navigate and use a Windows based desktop
navigate AS/400 menus
use AS/400 commands
list the data types that are supported by the OS/400 database
These skills can be gained by attending OL49AU - "iSeries 400 and AS/400e Application Programming Facilities Workshop" or through equivalent experience. For those students who need to learn about the iSeries 400 database features and functions, attendance at OL45AU - " DB2 UDB for OS/400 Fundamentals", prior to this class, is recommended.
AS/400 users who want to attend this class may not have a broad programming background. However, some prior experience in programming would facilitate their learning experience.
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 use column and scalar functions
code SQL queries that use inner and outer joins

Contents Course units:
SQL Concepts
SQL Objects and Data Definition
Extracting Data Using SELECT
Functions
JOIN and UNION
SubSELECTs

...''

Phone:1800 801 088

School Address:

IBM Australia Ltd
Level 13
IBM Centre
601 Pacific Highway
St Leonards NSW 2065.
Tel:1800 801 088

Jobs & Resumes: Sydney, Melbourne, PERTH, BRISBANE, CANBERRA CITY
Houses & Roommates: Sydney, Melbourne, PERTH, BRISBANE, CANBERRA CITY

Enabling Java Support in CICS TS V2 (CI21AU)
CICSPlex System Manager Introduction (CI75AU)
Introduction to Business Intelligence and Data Warehousing (DW03AU)
Data Replication: Basic Usage (DW14AAU)
DB2 DataPropagator Advanced Topics (DW15AAU)
Heterogeneous Data Replication with DB2 Infor Integrator & DB2 DataPropagator (DW16AU)
What’s New with DB2 Version 8 Data Replication (DB2 DataProgator) (DW17AU)
DB2 UDB Data Warehouse Edition Components (DW35AU)
IBM DB2 OLAP Server Up and Running (DW60AU)
IBM DB2 OLAP Server: Administration and Partitioning (DW62AU)
DB2 Family Fundamentals (CF03AU)
DB2 SQL Workshop (CF12AU)
DB2 SQL Workshop for Experienced Users (CF13AAU)
DB2 UDB for OS/390 Data Sharing Implementation Workshop (CF35AU)
DB2 for OS/390 Data Sharing Recovery and Restart Workshop (CF36AU)
DB2 Stored Procedures Programming Workshop (CF71AU)
DB2 UDB Control Centre and GUI Tools for OS/390 DBAs (CF72AU)
DB2 Universal Database Programming Workshop for z/OS (CF82AU)
DB2 UDB for z/OS Database Administration Workshop - Part I (CF83AAU)

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Try the search form on top of each page to find the latest course information, using course topic and location as keywords. Keep the course topic keyword short to get more results.