Download PDF
of this course

IBM DB2 SQL Workshop (CE121G)

  • Overview
  • Who Should Attend
  • Certifications
  • Prerequisites
  • Objectives
  • Content
  • Schedule
Course Overview

Course Duration 2 days.
IBM DB2 SQL Workshop - course replaces course SQL Workshop (CE120). This is the Classroom version of Instructor-led online course SQL Workshop - Instructor Led Online (3E121). This course provides an introduction to the SQL language. This course is appropriate for customers working in all DB2 environments, that is, z/OS, VM/VSE, iSeries, Linux, UNIX, and Windows. It is also appropriate for customers working in an Informix environment.

Who Should Attend

  • This basic course is for everyone 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).

Course Certifications

This course is part of the following Certifications:

Prerequisites

You should have:
  • Basic computer literacy
  • Basic editing skills
Database skills are not required.

Course Objectives

  • Code SQL statements to retrieve data from a DB2 or Informix 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

Course Content

  • 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

Course ID: CE121G


Show Schedule for 1 Month  3 Months  All 
Date Country Location Register