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

Send us your message.

X

DB2 SQL Training

Key points about this course


Duration: 2 Days

Dates & Prices Enquire
  • Highly recommended for End-users and Programmers
  • Gain knowledge on Scalar Functions and Arithmetic
  • There are pre-requisites prior to attending this course

Available delivery methods for this course

Classroom Icon

Classroom

Onsite Icon

In-house

Online Icon

Online

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?

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.

There is no exam with this course.

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

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

Trustpilot