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

Home

distance-learning center

Distance-learning Distance-learning_Building

Professional Distance-learning

IT Training Services

MFRDB46

 Db2: Database Administration - Windows
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. Db2 and the Relational Model
      • Design a simple model for an employee system.
    2. Db2 Components and Concepts
      • List the components in Db2 that affect the Db2 administrator.
    3. Db2 Installation
      • Use the Db2 Installer graphical interface - db2setup to install a copy of Db2 on a server.
      • 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.
    4. Creating Objects
      • Create databases, tables, indexes and aliases.
      • Alter a table and recreate an index.
    5. Moving and Loading Data
      • Move a table from one Db2 instance to another instance.
    6. Backup, Logging, and Recovery
      • Backup a database.
      • Restore a table.
    7. SQL for Administrators
    8. Scaling the Database
      • Increase the volume space associated with a tablespace.
    9. Application Considerations
      • Given a partial application model, determine the indexes, and the type of indexes needed for the application.
    10. Connectivity Considerations
      • Connect a client on a different machine to the server.
    11. Security
      • Create users and a group for application developers.
    12. Concurrency
      • Determine whether concurrency is being used effectively on that Db2 instance.
    13. Performance Measurement and Tuning
      • Given several execution plans, determine whether a performance problem exists and what is the solution.
    14. Optimizer
      • Given a number of SQL queries, determine if the queries can be optimized based on the table organization, predicates, and filters.
    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.