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


distance-learning center

Application of Classic Teaching Models Mobile Classrooms

Professional Distance-learning

IT Training Services


DB2: Database Administration - Windows
DURATION: 4 days

FEE: $1,980

Based upon a class size of six students.

Scheduling can be adjusted to employee work hours and incorporate client assignments.

There is a surcharge associated with training two or fewer students.


  • Programmer
  • Database Administrator
  • IT Professional


    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
      • Back up 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 if concurrency effectively is being used on that DB2 instance.
    13. Performance Measurement and Tuning
      • Given a number of 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, predicates, and filters.
    Web-based Training   Blended Learning    
Value Added Service

Common Questions



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.