IBM DB2 SQL Workshop

Course information
Price: € 1,295.00
Day(s): 2
Course Code: CE121G
GTC: 14

Overview

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.

Pre-Requisites

You should have:

  • Basic computer literacy
  • Basic editing skills
  • Database skills are not required

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

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

Target Audience

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).

Schedule
Course Details
07 Jun - 08 Jun, 2017
Virtual Training
05 Jul - 06 Jul, 2017
Virtual Training
20 Sep - 21 Sep, 2017
Virtual Training
22 Nov - 23 Nov, 2017
Virtual Training

Key to symbols +

  • gauranteed Indicates a guaranteed course
  • special offer Indicates a special offer
  • late availability Indicates a late availability course
  • GTC What are GTCs?

Course description

Download a PDF document of the complete course description: IBM DB2 SQL Workshop

All course dates
Date & Location Language Ver
July
05 Jul - 06 Jul, 2017 Arrow ECS - Global Knowledge Leeds Public Classroom
05 Jul - 06 Jul, 2017 Arrow ECS - Birmingham Public Classroom
05 Jul - 06 Jul, 2017
Virtual Training
Virtual Learning
05 Jul - 06 Jul, 2017 Arrow ECS - Manchester Public Classroom
05 Jul - 06 Jul, 2017 Arrow ECS - Dublin Public Classroom
05 Jul - 06 Jul, 2017 Arrow ECS - London Dowgate Hill Public Classroom
September
07 Sep - 08 Sep, 2017
Virtual Training
EN Virtual Learning
07 Sep - 08 Sep, 2017 Zoetermeer (Centrum West 21) EN Public Classroom
07 Sep - 08 Sep, 2017
Virtual Training
EN Virtual Learning
07 Sep - 08 Sep, 2017
Virtual Training
EN Virtual Learning
11 Sep - 12 Sep, 2017 RUEIL ATHENEE Public Classroom
20 Sep - 21 Sep, 2017 London - Old Broad Street Public Classroom
20 Sep - 21 Sep, 2017 Leeds Public Classroom
20 Sep - 21 Sep, 2017
Virtual Training
Virtual Learning
20 Sep - 21 Sep, 2017 Manchester Public Classroom
20 Sep - 21 Sep, 2017 Birmingham Public Classroom
November
22 Nov - 23 Nov, 2017 London - Old Broad Street Public Classroom
22 Nov - 23 Nov, 2017 Leeds Public Classroom
22 Nov - 23 Nov, 2017
Virtual Training
Virtual Learning
22 Nov - 23 Nov, 2017 Manchester Public Classroom
22 Nov - 23 Nov, 2017 Birmingham Public Classroom

This item has been added to your basket