Custom Search

DB2 Application Programming I Rel 4 x

DB2

Serebra Learning Corporation
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.
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
Duration:5 hours
Training Presented in:English
DB2 Application Programming I Rel 4 x

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 The Training Provider: Serebra Learning Corporation
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...
Want to Sell More application training?
tcw11-gfc-v396M-10/25/09-10:41:05-()[A]-[B]-[A] -21:27:59