self evaluation testing

Existing User




If you are a existing user

click here to login



New User




If you are a new user

click here to register



Other Links





            skills development


            references


            feedback

DB2 courses outline

Introduction

1. Introduction to DB2 Relational Databases and SQL
2. DataBase Architecture
3. Terms used in Relational DataBases
4. Tables, Rows, Columns, Data types, SQL and its Components
5. SQL Queries, Selecting Data from Table, SELECT and FROM clauses
6. The WHERE clause, Different Predicates
7. Performing Arithmetic between Columns
8. Scalar Functions, String Functions, Numeric Functions
9. Column or Aggregate Functions, Counting in DB2 Tables
10. The GROUP BY clause, The HAVING clauses, The ORDER BY clauses
11. Using Sub Selects

Joining DB2 Tables Together

1. Selecting Data from more than One Table
2. Inner Join, Outer Join, Full Outer Join, WHERE used with a Join

Manipulation of Objects in DB2

1. Plan, Creating and Deleting Objects - Create & Drop statement
2. Protecting tables from DROP, The system Catalogue

Updating Data in Table

1. Modifying Data in a Table, UPDATE Statement, DELETE Statement
2. INSERT Statement , Restricting the Rows being Updated Updating
3. Multiple Columns, Setting Columns to Null, Setting Columns to a Value
4. INSERTING DATA INTO A TABLE
5. DELETING ROWS FROM A TABLE
6. DELETE Statement, Restricting the Delete
7. Static and Dynamic SQL's

Embedding SQL in an Application Program

1. Planning, Testing the SQL Interactively
2. Precompile, Compile, Bind, Link, DBRM, PLAN, PACKAGE
3. Execution of a DB2 Program

Manipulating Data and Components of an Application Program

1. The SQLCA, The DCLGENs, Handling Exceptional Conditions
2. SQLCODE, WHENEVER Statement, EXEC SQL Statement

Host variables

1. The cursor Statements
2. DECLARE, OPEN, FETCH & CLOSE the Cursor

Other Keywords / DB2 Objects

1. DISTINCT, UNION, VIEWS,,ALIASES and SYNONYMS
2. SUB-SELECTS AND CORRELATED QUERIES

Support of Refferential Integrity

1. Using DB2 RI Facilities, Primary and Foreign Keys

Cascade Deletes and Updates

1. ON DELETE Statement
2. Restrict, Cascade and Set null options
3. UPDATE Statement

DB2 Administration

System Tables

1. Catalog tables(SYSIBM tables) and DB2 directory

DB2 Utilities

1. Check, Copy, Recover, Load, Reorg, Runstats, EXPLAIN

Security Levels

1. GRANT Statement, REVOKE Statement

Lock Types and Performance

1. Isolation levels RR,CS
2. Locking and Concurrency
3. Share, Exclusive and Update Locks
4. Releasing Locks in Different Environments