Interskill Learning Mainframe Training

American English British English Brazilian Portuguese French German Italian Russian Spanish (European) Spanish (Latin American)
+44 (0) 1625 441120

The Online Mainframe Training Specialists
Search   Course Catalog   Live Chat!  
Return to Catalog Home     Return to Curriculum Listing

DB2 SQL Fundamentals V11

Duration

4 hours

Overview

The DB2 SQL Fundamentals course looks at some of the more common SQL statements used by programmers when starting out. It addresses the code used to obtain DB2 table data, sort it, as well as methods used for inserting, deleting, updating and merging table data.

Audience

Programmers, DBAs, business analysts, and any other personnel that require SQL coding skills to manage DB2 data.

Prerequisites

Completion of the 'Manage Data Definitions' course, or equivalent knowledge.

Objectives

After completing this course, the student should be able to:

  • Code Simple SQL SELECT statements used to obtain DB2 table data
  • Describe how data can be sorted
  • Describe how to insert, update, and delete DB2 data by using SQL

Course Content

SQL - Selecting Data

Using the SELECT Statement to Obtain Data
Coding Predicates (WHERE Clauses)
Coding Simple Column Arithmetic
Coding for the Effects of Null Values

SQL - SCALAR and COLUMN Functions, ORDER BY Clause

Scalar Functions
Aggregate or Column Functions and Groupings
Coding the ORDER BY Clause

SQL - The INSERT, DELETE, UPDATE, and MERGE Statements

Inserting Rows into Tables
Deleting Rows from Tables
Modifying the Values of Columns in Rows

DB2 SQL Fundamentals Mastery Test

Looking for more information about Interskill Learning Products?
Contact our Learning Consultants or call us at +44 (0) 1625 441120