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
IT Professional
DATES:
CONTENT AND OBJECTIVES:
Database Administration Tasks
Create databases, tables, indexes, and aliases.
Alter a table and recreate an index.
Configure communication protocols to use with the DAS: Db2 Administration Server service and Db2 instances.
Create the necessary userids and groups.
Define an instance at installation time.
Increase the volume space associated with a tablespace.
Improve performance, update statistics, and reorganize the data.
Run the utilities: REORG, RUNSTAT, STOSTAT, COPY, and CHECK.
Db2 Instance Creation
Configure the database instance.
Create a DAS: Db2 Administration Server.
Configure TCP/IP communications for the Db2 instance.
Populating Databases
Exporting data from the database.
Importing data from files into database tables.
Loading data from files into database tables.
Logical Design for Supporting Concurrency
Setting isolation levels.
Handling deadlocks.
Recovery
Backing up a database.
Restoring a table.
File System and Db2
Check the file system caching status.
Authorization
Create users and group for application developers.
Create users and groups for application users.
Operating System Functions
Collect information about the database.
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.
