IBM Db2 11.1 Quickstart for Experienced Relational DBAs
Who Can Benefit
This is an intermediate course for experienced DBAs and technical individuals, with experience on other relational database platforms, who plan, implement, and maintain Db2 11.1 for Linux, UNIX, and Windows databases. These skills can also be utilize to support cloud based databases using Db2 on Cloud or Db2 Hosted environments.
Prerequisites
Participants should have the following skills:
o Perform basic database administration tasks on a relational database system
o Use basic OS functions such as utilities, file permissions, hierarchical file system, commands, and editor
o State the functions of the Structured Query Language (SQL) and be able to construct DDL, DML, and authorization statements
o Discuss basic relational database concepts and objects such as tables, indexes, views, and joins
o These skills can be developed by taking:
- DB2 SQL Workshop
- DB2 Fundamentals
Outline
Topics Covered:
- Overview of Db2 11
- Command Line Processor (CLP) and GUI Usage
- The Db2 Environment
- Creating Databases and Data Placement
- Creating Database Objects
- Moving Data
- Backup and Recovery
- Locks and Concurrency
- Database Maintenance, Monitoring and Problem Determination
- Security
- Database Rebuild Support
- Db2 Database and Table Space Relocation
- Using Explain Tools
- Using Indexes for Performance
- Advanced Monitoring
Sorry! It looks like we haven’t updated our dates for the class you selected yet. There’s a quick way to find out. Contact us at 502.265.3057 or email info@training4it.com
Request a Date