Training Classes | Learning and Development Resources | Training Directory | New Training Seminars | New Training Providers | Site Map | Promote Training Seminars | Training Keywords | Training Seminars | Training Providers | Regions | Training Search | Advertise Training Seminars | Login
Provided by: Serebra Learning Corporation

DB2 Application Programming I Rel 4 x

Click here for more information or to take this course 		Serebra Learning Corporation
  home  : Computer  : Databases and SQL  : DB2
Get More Information
Search for Training
Find Your Genius!
What do you want to learn about?

Training Provided by Serebra Learning Corporation

This course teaches students how to use embedded SQL in their applications to retrieve and update information contained in DB2. Application developers.

Training Avaliability and Delivery

This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Contact Serebra Learning Corporation for more information
Schedule:5 hours
Training Presented in:English
Related Keywords:  mainframe   ibm   db2   database   system 4   application   programming   i rel 

Training Program Details

Audience

Application developers.

Topics

Overview

  • What is a Database?
  • DB2
  • Functions of a Database
  • Increasing Data Independence
  • Decrease Redundancy
  • Increase Data Security
  • Maintaining Data Integrity
  • DB2 Structure
  • Relational Database System
  • DB2 Table Structure

SQL Data Retrieval

  • Retrieving Data with the SELECT
  • The SELECT Statement
  • SELECT all Data
  • Column Selection and Ordering
  • Eliminating Duplications
  • Arithmetic Calculations
  • The WHERE Clause
  • Comparison Operators
  • Multiple Search Criteria
  • OR and IN Comparison Operators
  • BETWEEN and AND Operators
  • The LIKE Clause
  • Sample Application of the LIKE Clause
  • SELECT ... ORDER By Clause
  • Ordering Results (ASC, DESC)
  • Intersecting Tables
  • Combining Data from Multiple Tables
  • Joining Two Tables in a SELECT<

Objectives

About Serebra Learning Corporation - Training Provider

Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
More IBM Training from Serebra Learning Corporation
Click here for more information or to take this course
Training Directory | New Training Seminars | New Training Providers | Search | Site Map | Promote Training | Login | Links
Training-Classes.com by Skillbox® 07/18/08
Copyright 1998-2008 skillbox, inc. All rights reserved		 Connecting people who want to learn with people who love to teach
 Are you a Mainframe training provider?
You could be on this page today - for FREE!
This page was last updated on sb5 - 07/18/08 at 04:37:55 - 02:45:44