Datatrain
Partners
Login
  Username
  Password
  Partner Login
 
Forgot Password?
Register Now!
Partners
Interskill Mainframe Training Newsletter - April ´17
Interskill Mainframe Training Newsletter - August ´16
Interskill Mainframe Training Newsletter - June ´15
Past Issues

Partners
Mainframe Links
Mainframe Facts - Did you know?



DidYouKnow


More facts...

Course Catalog » Database Curriculum » DB2 Operations Series V11

DB2 Fundamentals V11

Duration
5 hours

Overview

Description

The DB2 Fundamentals course describes what DB2 is, how it is used and the components that comprise its structure. An overview of the SQL language, which is used to communicate with DB2, is provided along with details on how it is used with SPUFI.

Audience

Personnel requiring an introduction to DB2 and SQL

Prerequisites

Basic knowledge of Data Processing concepts

Objectives

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

  • Identify how DB2 is used and by whom
  • Describe conceptually how DB2 processes work
  • Code basic SQL statements
  • Use SPUFI to process SQL statements

Course Content

Overview of DB2

What is DB2 and how is it used?

DB2 Users

Understanding the DB2 Environment

DB2 Components

DB2 Tools

DB2 Internals

How Applications and Programs Access DB2 Data

DB2 and SQL

DB2 Data Structures

DB2 Catalogs and Directories

DB2 Active and Archive Logs

DB2 Buffer Pools

DB2 and the Sysplex

Overview of SQL

Methods used to Execute SQL

SQL Syntax

Accessing DB2 Data Using the SELECT Statement

SQL Functions and Expressions

Filtering and Sorting Data

Creating Tables

Inserting Data into Tables

Deleting Table Data

Updating Existing Table Data

SQL and SPUFI

What is SPUFI?

Accessing SPUFI

Entering Input and Output Requirements into SPUFI

Defining SPUFI Processing Options and Defaults

Interpreting SPUFI Output

Batch SPUFI

DB2 Fundamentals Mastery Test

Course Catalog » Database Curriculum » DB2 Operations Series V11
 
 
 
  © All rights reserved. Interskill Learning Pty Ltd.
website designed & developed by blueapple
  HomeAbout UsProductsDemonstrationCourse CatalogDistributorsSite Map
    AOL Logo Interskill IBM