|
Provided by: Serebra Learning Corporation DB2 Application Programming I Rel 4 xDB2 |
 |
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.
|
|
||||||||||
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...
