Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - Db2: Transition Version 9

Home

distance-learning center

Distance-learning Distance-learning_Building

Professional Distance-learning

IT Training Services

MFRDB54

 Db2: Transition Version 9
DURATION: 3 days

FEE: $1,635

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 Programmer
  • System Analyst
  • IT Professional
  
   

DATES:

 CONTENT AND OBJECTIVES:
    1. SQL Changes
      • Become knowledgeable with MERGE and TRUNCATE statements and features.
    2. Database XML Enhancements
      • Learn the new XML functions and their usage including the sqlquery, XMLQuery, XMLtable, and XMLExists.
    3. Programming Environment Changes
      • Acquire proficiency with the new built-in functions for OLAP: Online Analytical Processing applications, including the RANK, DENSE_RANK, and ROW_NUMBER functions.
    4. Native SQL Procedures
      • Examine the new Native SQL Procedure Language, including support for the versioning of procedures, debugging of the procedures, and the deployment of procedures.
    5. Database Administration Enhancements
      • Learn the new restart improvements.
    6. Database, Storage Group, and Tablespace New Features
      • Demonstrate tablespace partitioning by growth.
    7. Utility Enhancements
      • Acquire proficiency with FlashCopy and tape.
    8. System Administration
      • Learn how to use the space index and in memory data cache method.
    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.