Course description: DB2 SQL Workshop (self-paced virtual class)

Once the id and password are provided, the course must be completed in 60 days.

Note: This course is actually a self-paced virtual class. The average time to complete the course is 30 hours. Once you register, you have 60 days to complete this course.

Once you are enrolled in this course, you will not be able to cancel your enrollment.

This is the Internet-delivered, self-paced virtual class version of our classroom course:

• DB2 SQL Workshop (CF120)

Learn about Structured Query Language (SQL) and how it applies to the entire DB2 UDB Family. This course is appropriate for individuals working in an OS/390, VM/VSE, AIX, or Windows environment. Complete extensive hands-on exercises to develop your skills to use the SQL you learn.

The self-paced format gives you the opportunity to complete the course at your convenience, at any location, and at your own pace. The course is available 24 hours a day, but access must be scheduled in advance. Once you have accessed the course, online instructor help is available Monday through Friday from 9:00 a.m. to 5:00 p.m. ET.  

Online Enrollment:

Before enrolling, review the Machine Requirements to be sure your system meets the minimum hardware requirements for this course.

Within 48 hours after you submit the online form, you will receive a confirmation e-mail. It will contain your online link, your ID and password, and additional instructions for starting the course.

Start the course at any time. Once you start the course, you have 60 days to complete the program. You are billed for the course when you submit your enrollment form.

Course Materials

The course materials cover DB2 UDB for z/OS Version 8 and DB2 UDB for Linux, UNIX and Windows Version 8.

Hands-On Labs

Seven labs are included to address using DB2 UDB for z/OS Version 8 and DB2 UDB for Linux, UNIX and Windows Version 8.

Certification

Prepare for IBM Certification Test 512: DB2 UDB V7.1 Family Fundamentals and IBM Certification Test 700: DB2 UDB V8.1 Family Fundamentals.

Training Paths that reference this course are:

• DB2 for z/OS
• QMF
• Data Servers Cross Product Overview

Back to top

This is a basic course for individuals who need to perform SQL queries in practice. This includes end users, programmers, application designers, database administrators, and system administrators, who do not have knowledge of the SQL Data Manipulation Language (DML).

Back to top

You should complete:

• DB2 Family Fundamentals (CF030, CF03G) or
• DB2 Family Fundamentals (self-paced virtual class) (C03A1)
• or have equivalent experience

What's Next

Use the link to the Training Path in the course description for easy access to prerequisite courses, and other courses that might be of interest to you.

Back to top

Write basic DML SQL statements

• SELECT
• INSERT
• UPDATE
• DELETE

Write basic Data Definition Language (DDL) SQL statements

• CREATE TABLE
• CREATE VIEW

Back to top

Introduction

• define the terms database, table, row, column, and view
• list the most commonly used SQL statements in Data Definition Language (DDL), DML, and Data Control Language (DCL)
• state the more common DB2 UDB data types
• state three null characteristics and their meaning

Simple SQL queries

• describe four SELECT statement clauses (SELECT, FROM WHERE, and ORDER BY) and their purpose
• retrieve all rows of a table
• retrieve specific columns
• order the resulting rows in a desired sequence
• retrieve rows based on comparisons to numeric or alphanumeric column values
• use the keywords BETWEEN, IN, LIKE, and DISTINCT

Retrieving data from multiple tables

• explain multiple table data retrieval
• author SELECT statements for basic JOIN operations
• specify JOIN predicates
• query more than 2 tables using JOIN operations
• use correlation names in queries
• perform self-JOIN queries

Scalar functions and arithmetic

• use arithmetic in the SELECT and WHERE clauses
• work with null and decimal values
• specify basic scalar functions such as COALESCE/VALUE, DECIMAL, and SUBSTR
• reformat date and time data with scalar functions
• perform calculations on date and time data with arithmetic functions
• split and CONCAT character string data

Column functions and grouping

• describe the difference between scalar and column functions
• list the most common DB2 UDB column functions
• describe the various SELECT clauses
• explain the execution order of the SELECT statement and its clauses
• group rows into sets based on one or more columns
• apply the GROUP BY clause

Union

• describe the concept of uniting results tables
• produce a single result table containing data from more than one query
• state the UNION rules
• state the difference between UNION and UNION ALL
• demonstrate the proper syntax and usage of UNION and UNION ALL
• manipulate the UNION results

Using subqueries

• use subqueries in the WHERE and HAVING clauses
• code subqueies using basic predicates
• code subqueries using the IN keyword

Maintaining data

• create a simple table for testing DML statements
• create a simple view
• insert rows into a table
• update data in a table
• delete rows from a table
• drop a table

Back to top

To access the course, your workstation must meet the following requirements:

• Processor: Pentium 133 MHz or better
• Operating System: Windows 9X or better
• RAM: 64 Mb or better
• Video resolution: 800 x 600 minimum, 256 colors
• Sound Card
• Speakers
• Mouse or other pointing device
• Internet connection (56 kbps or better)
• Browser: Internet Explorer 5, Mozilla Firefox 2 or better
• Plug-ins: TechSmith Video CODEC (available upon first site access)

To view the multimedia presentations, your system must be configured with an AVI video player (Real Player or Windows Media Player)

e-Labs:

To attend remote e-Labs, the following ports must be opened:

• 443
• 80
• 5800
• 5900

Chats:

eTutor support is available daily from 08:00 to 17:00 EST daily Monday to Friday. To allow access to the chat server the following ports must be open:

• 8080
• 8082

Options:

• For Flash multimedia presentations, the Flash plug-in is required. Typically, you are prompted to download upon encountering the presentation. If you are not, you may download the player from http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash
• Access to simulations requires that the library files for the simulation be downloaded to your machine. Typically this will take only a few seconds.

Java Runtime Environments:

It is recommended that the 1.4.2_x Runtime supplied by Sun Microsystems be used. This runtime can be downloaded at http://java.sun.com/j2se/1.4.2/download.html for the particular operating system that is needed. Once the Runtime Environment is downloaded it is recommended that the currently installed Runtime Environment be uninstalled before the new Runtime Environment is installed.

Back to top

• Edit your profile

Easy ways to get the answers you need.

• Online text chat

or call us at
Call 1-800-426-8322

Open M-F 9AM-7PM ET.

• My enrollments

• My training plan

• How to get to class

• Subscribe to IBM Training RSS feeds

• Training paths will help you decide

• Subscribe to IBM Training News

• IBM Training Flyer (98KB)

• Certification flyer (355KB)

• Training special offers

• IBM Education Pack

  Save on training

• Get Adobe® Reader®