Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - File-AID: Db2 - Compuware

Home

distance-learning center

Computer-Device_Tethered-Distance-learning Distance-learning-Building

Professional Distance-learning

IT Training Services



MFUTD09

File-AID: Db2 - Compuware
DURATION: 1 day

FEE: $595

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

DATES:

CONTENT AND OBJECTIVES:
    1. Featureset
      • Allocate SHOW.SQL.
      • Set the defaults.
      • Create a default JOB card.
      • Indicate the default space requirements.
    2. Browse/Edit
      • Perform a browse in table and row mode.
      • Practice a number of primary and line commands.
      • Process two related tables.
      • Demonstrate locking during an edit.
    3. Related Table Browse and Edit
      • Create a relationship dataset.
      • Build a relationship on three tables.
      • List all the relationships for a table.
      • Automatically generate relationships from the Db2 catalog.
    4. Utilities
      • Create a table with associated indexes.
      • Create a clustering index.
      • Define and test a trigger.
      • Code and define a function.
      • Perform a table copy operations.
      • Copy one table to another table with a subset of columns.
      • Copy one table to another applying a filter to the rows.
      • Perform a batch extract from a table to a dataset.
      • Load a dataset into a table.
    5. Batch Facility
      • Perform a batch extract from a table to a dataset.
      • Load a dataset into a table.
    6. SQL Development and Analysis
      • Create all the Plan tables needed for SQL Analysis.
      • Analyze a variety of SQL statements.
      • Flush the EXPLAIN tables.

 
 
    Web-based Training   Blended Learning    
Synchronous
Instruction
Asynchronous
Instruction
 

 

Effective February 27, 2012, the course dates listed on the SYS-ED 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. SYS-ED makes no representation regarding ownership in any of the software products that we train on.

SYS-ED 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 SYS-ED course and that the employer has a licensed version of the software.