Skip to main Content

IBM DB2 SQL Workshop

  • Course Code CE121G
  • Duration 2 days

Additional Payment Options

  • GTC 19 inc. VAT

    GTC, Global Knowledge Training Credit, please contact Global Knowledge for more details

Public Classroom Price

£1,190.00

excl. VAT

Request Group Training Add to Cart

Course Delivery

This course is available in the following formats:

  • Company Event

    Event at company

  • Elearning (Self-paced)

    Self paced electronic learning

  • Public Classroom

    Traditional Classroom Learning

  • Virtual Learning

    Learning that is virtual

Request this course in a different delivery format.

Course Overview

Top

This course replaces course SQL Workshop (CE120GB). This is the Classroom version of Instructor-led online course SQL Workshop - Instructor Led Online (3E121GB).

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.

Course Schedule

Top
    • Delivery Format: Virtual Learning
    • Date: 12-13 August, 2019
    • Location: Virtual

    £1,190.00

    • Delivery Format: Virtual Learning
    • Date: 12-13 August, 2019
    • Location: Virtual

    £1,190.00

    • Delivery Format: Virtual Learning
    • Date: 09-10 December, 2019
    • Location: Virtual

    £1,190.00

    • Delivery Format: Virtual Learning
    • Date: 09-10 December, 2019
    • Location: Virtual

    £1,190.00

Target Audience

Top

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 Objectives

Top
  • 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

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

Course Prerequisites

Top

You should have:

  • Basic computer literacy
  • Basic editing skills
  • Database skills are not required
Cookie Control toggle icon