Dismiss

DB2 Application Programming training course

Attend A DB2 Course - Get More From Your IBM Corporate Data

4.8 out of 5 average

(see feedback)

Overview

Our DB2 training course client feedback shows that delegates will best engage when they can relate course topics to their own day-to-day practices and requirements. Where possible, we run this course as a consultative, workshop-style event, in which discussion of relevant topics takes place in relation to the delegates' own applications and scenarios.

To facilitate this type of event, a subject matter expert leads the training, hands-on labs and discussions to ensure course topics are covered in a meaningful, relevant and timely manner. Delegates may be able to bring their own practical requirements and work to the course if the subjects and course topics are suitable.

more...

TAILOR-MADE
Click to get a quote

PUBLIC COURSES
Next on 20th Jun 2022

Highlights Course detail Who should attend Feedback Prices/Dates Related courses

Highlights

Understand the concepts of Relational Tables, Normalisation, Database Design, Primary & Foreign Keys.
List the main data types available.

Recognise some DDL and DML statements.

Describe the main DB2 objects and their relationships.

Discuss the need for program preparation and the DB2 catalog.

Discuss authorisation concepts.

Understand the need for locking and define some of the associated terminology.

Recognise some utilities and their uses.

Use SPUFI to edit SQL statements to access tables.

Code and test some SQL statements to perform simple selection from a single table

Code and run SQL statements that perform selection from 2 tables

Code and run SQL using some column and scalar functions including date manipulation.

TAILOR-MADE
Enquire & get a quote

PUBLIC COURSES
Next on 20 Jun - see prices

Course Details

DB2 for z/OS Overview

DB2 Introduction
Relational database
Tables
DB2 database design
Entity relationships
Attributes
Normalisation
Physical database design
Table relationships
Data types
Null values
DB2 interfaces
Major components of DB2
DB2 objects
Tables and Storage
Tablespaces, Tables & Views
Storage Groups & Databases
Tablespaces & Tables
Indexes
Views
Referential Integrity
DB2 catalog
Accessing data
Application programs
Program Preparation
DB2 sub-systems
Statement syntax

SPUFI

Accessing DB2 Interactive
DB2I defaults
SPUFI panel
Using SPUFI
SPUFI defaults

SQL

SQL statements
Retrieving data
SELECT statement syntax
Selection of columns
Selection of rows (WHERE)
Logical expressions
NOT, BETWEEN & IN
LIKE
NULL conditions
Literals & arithmetic expressions
Concatenating columns
Arithmetic expressions in the WHERE clause
CURRENT DATE & TIME
DISTINCT
Sorting (ORDER BY)
Table names
Synonyms

Built in functions

SQL column functions

Expressions in column functions

COUNT

GROUP BY

HAVING

SQL scalar functions

SUBSTR

VALUE

Joining tables

Qualified column names

Cartesian products