DB2 SQL Workshop - On-Demand Course

The DB2 SQL Workshop course is a 2-day course that is designed to provide students an introduction to the SQL language.

Note: This course is appropriate for learners working in all DB2 environments, that is, z/OS, VM/VSE, iSeries, Linux, UNIX, and Windows. It is also appropriate for learners working in an Informix environment.

?

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

This introductory course is for students needing 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 knowledge of the SQL Data Manipulation Language (DML).

• Basic computer literacy
• Basic editing skills

Note: Database skills are not required.

• 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

• Basic computer literacy
• Basic editing skills

Note: Database skills are not required.