Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - Db2: Database Administration - Linux

Home

distance-learning center

Distance-learning Distance-learning_Building

Professional Distance-learning

IT Training Services

MFRDB44

 Db2: Database Administration - Linux
DURATION: 4 days

FEE: $1,980

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:
    1. 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.
    2. Db2 Instance Creation
      • Configure the database instance.
      • Create a DAS: Db2 Administration Server.
      • Configure TCP/IP communications for the Db2 instance.
    3. Populating Databases
      • Exporting data from the database.
      • Importing data from files into database tables.
      • Loading data from files into database tables.
    4. Logical Design for Supporting Concurrency
      • Setting isolation levels.
      • Handling deadlocks.
    5. Recovery
      • Backing up a database.
      • Restoring a table.
    6. File System and Db2
      • Check the file system caching status.
    7. Authorization
      • Create users and group for application developers.
      • Create users and groups for application users.
    8. 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.