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:
Featureset
Allocate SHOW.SQL.
Set the defaults.
Create a default JOB card.
Indicate the default space requirements.
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.
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.
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.
Batch Facility
Perform a batch extract from a table to a dataset.
Load a dataset into a table.
SQL Development and Analysis
Create all the Plan tables needed for SQL Analysis.
Analyze a variety of SQL statements.
Flush the EXPLAIN tables.
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.