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 » Power Systems Curriculum » IBM i Query Series

Database Basics and the Need for Query

Duration
4 hours

Overview

Description

The Database Basics and the Need for Query course describes the IBM Query for i sort, report and analyze capabilities providing examples on how IBM Query for i is used to create business reports. Basic concepts relating to database structure and the data that can be accessed by IBM Query for i are explained in detail.

Audience

Personnel requiring knowledge about creating reports with the IBM Query for i facility.

Prerequisites

Knowledge of IBM i concepts.

Objectives

After completing this course the student should be able to:

  • Describe the tasks that can be performed by IBM Query for i
  • Identify the components that comprise a database
  • Explain how database files and records are configured

Course Content

What is Query?

The purpose of IBM Query for i

Report Formats

Database Concepts

Physical and Logical Files

Records

Record Fields

Field Types

Primary Keys

How Files are Defined to the System

Data Description Specifications

Defining Record Formats

Field Specifications

Record Configuration Examples

Description of the Example Database

Example Database Need

File Structure

Record Values

Keys

How the Database is Used

Database Basics and the Need for Query Mastery Test

Course Catalog » Power Systems Curriculum » IBM i Query Series
 
 
 
  © All rights reserved. Interskill Learning Pty Ltd.
website designed & developed by blueapple
  HomeAbout UsProductsDemonstrationCourse CatalogDistributorsSite Map
    AOL Logo Interskill IBM