Course description: DB2 SQL Workshop - Updated

This course provides an introduction to the SQL language.

This course is appropriate for customers working in all DB2 environments, namely, z/OS, VM/VSE, iSeries, Linux, UNIX, and Windows.

View this course in other countries

Roadmaps that contain this course are:

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

Back to top

This basic course is for everyone who needs to write, support, or understand SQL queries. This includes but is not limited to end-users, programmers, application designers, database administrators, and system administrators who do not yet have a knowledge of the SQL Data Manipulation Language (DML).

Back to top

You should have:

• Basic computer literacy
• Basic editing skills

Database skills are not required.

Back to top

• Code SQL statements to retrieve data from a DB2 table, including the SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY clauses
• Code inner joins and non-correlated subqueries
• Use SQL arithmetic operations
• Use scalar and column functions
• Use UNION and UNION ALL
• INSERT, UPDATE and DELETE rows
• Code simple CREATE TABLE and CREATE VIEW statements

Back to top

• Introduction
• Simple SQL Queries
• Retrieving Data from Multiple Tables
• Scalar Functions and Arithmetic
• Column Functions and Grouping
• UNION and UNION ALL
• Using Subqueries
• Maintaining data

Back to top

Practical Work:

This course is structured in a lecture/lab format. The hands-on sessions form a vital and integral part of the course.

February 2013

V6.1

Back to top