The Knowledge Academy Logo
The Knowledge Academy Logo
+60 1800812339 - Available 24/7

Send us your message.

X

DB2 SQL Training

Key points about this course


Duration: 2 Days*

Dates & Prices Enquire
  • Learn how to use SQL arithmetic operations.
  • Learn how to use scalar and column functions.
  • Learn how to use UNION and UNION ALL.

Available delivery methods for this course

Classroom Icon

Classroom

Onsite Icon

In-house

Virtual Icon

Live Virtual

Course Information

DB2 SQL Training Overview

This 2-day workshop looks at how to use the SQL language within IBM DB2 database systems to interact with and manipulate data.  It provides universal instruction which covers the use of SQL in all DB2 environments, including z/OS, VM/VSE, iSeries, Linux, UNIX and Windows. By the end of the course, you will understand how SQL works and how to write basic queries to retrieve data and carry out arithmetic operations.

DB2 SQL Training Outline

The course covers the following topics:

  • 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

By the end of the course, you will be able to:

  • 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

 

Who should attend this IBM Training Course?

The course is aimed at end-users, programmers, application designers, database administrators, system administrators and anybody else requiring basic knowledge of SQL.

Prerequisites

You should have basic PC skills and editing skills before attending.

You should have basic PC skills.
No, no exam is necessary.
Your instructor will be an expert with SQL and using IBM DB2.
The course will begin at 9am and finish at 5pm each day.

What's included in this IBM Training Course?

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor
  • Refreshments

Dates & Prices

Select your preferred delivery method

Choose a Region

Choose a Location

Choose a Month

Office Icon Attend your course from the office or home
Trainers Icon Interactive support from experienced trainers
Simple Icon Simple to setup and easy to use on any device
VirtualLive Virtual
Thu 13th Jun 2019
Places available
$3565
VirtualLive Virtual
Thu 11th Jul 2019
Places available
$3565
Kuala Lumpur
Thu 18th Jul 2019
Places available
$4625
VirtualLive Virtual
Thu 15th Aug 2019
Places available
$3565
VirtualLive Virtual
Thu 12th Sep 2019
Places available
$3565
Kuala Lumpur
Thu 19th Sep 2019
Places available
$4625
VirtualLive Virtual
Thu 10th Oct 2019
Places available
$3565
VirtualLive Virtual
Thu 7th Nov 2019
Places available
$3565
Kuala Lumpur
Thu 21st Nov 2019
Places available
$4625
VirtualLive Virtual
Thu 5th Dec 2019
Places available
$3565

Complete the steps below to receive a quote or more information

How will you be funding your training?

Self funding

Company funding

Not sure

Key points about this course


Duration: 2 Days*


Why choose TKA logo


Gold Tag

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

Delivery Icon

Various delivery methods

Flexible delivery methods are available depending on your learning style.

Resource Icon

Resources

Resources are included for a comprehensive learning experience.

Thames Water Logo

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

Google Logo
Samsung Logo
Shell Logo

"...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."

Diane Gray, Shell

bannerimg

Click here to save up to 55%!