PRIVATE GROUP FEE:
$ Based upon a class size of six students.
Scheduling can be adjusted to employee work hours and incorporate client assignments.
SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.
AUDIENCE:
Programmer
Database Administrator
System Analyst
System Programmer
IT Professional
DATES:
CONTENT AND OBJECTIVES:
Fundamentals of Db2
Examine the architecture and functionality of Db2.
The Db2 components and using DDL: Data Definition Language to create objects.
Use DDL to create components including a database, tablespace, tables, views, and indexes.
Structured Query Language
Use the SPUFI and other IBM tools to execute DDL and DML.
Configure the SPUFI tool.
Compile a COBOL program.
Develop a COBOL program that retrieves values from a table and handles exceptions.
Retrieval and Update Operations
Code and execute basic queries for retrieving data.
Become familiar with and apply the functionality of cursors to programming.
Create several queries for retrieving data from existing tables.
Modify a program that opens a cursor and fetches rows from the cursor.
Perform basic joins on multiple tables.
Join data from two tables using an inner join and a full outer join.
SQL Functions
Code queries using Db2 built-in functions and mathematical expressions.
Code and execute SQL for performing arithmetic on data using functions and constants.
Table and View Design
Execute a CREATE TABLE with a primary key and associated CREATE INDEX.
Embedded Retrieval and Update Operations
Code a program with multiple DML statements that will modify tables.
Update single rows, multiple rows, and all rows.
Insert a single row and perform a multiple row insert.
Delete a single row.
Db2 Architecture
List the characteristics of the different isolation levels.
Locking
Code programs implementing locking and monitor locks on Db2 tables.
Execute two programs that will lock each other out.
Monitor the locks.
Manage the lock attributes and the lock duration using Db2 system commands.
Performance
Modify query predicates to improve performance by using the indexes or minimizing sorts.
EXPLAIN Command
Given a number of queries, run the EXPLAIN and review the PLAN_TABLE.
Query Management Facility
Navigate the QMF panels and create a saved report.
Create a query and modify the default report.
Perform break processing and save the report and its associated data.
Virtual Classroom
Blended Learning
↓
Synchronous Instruction
Asynchronous Instruction
Effective February 27, 2012, the course dates listed on the CETi schedules only will be available based upon approved and authorized user ID.
Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. CETi makes no representation regarding ownership in any of the software products that we train on.
CETi courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the CETi course and that the employer has a licensed version of the software.
Certain courses only should be taught by the source software company training company and open source purveyor.
