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.
CONTENT AND OBJECTIVES:
Db2 and the Relational Model
Design a simple model for an employee system.
Db2 Components and Concepts
List the components in Db2 that affect the Db2 administrator.
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.
Create databases, tables, indexes and aliases.
Alter a table and recreate an index.
Moving and Loading Data
Move a table from one Db2 instance to another instance.
Backup, Logging, and Recovery
Backup a database.
Restore a table.
SQL for Administrators
Scaling the Database
Increase the volume space associated with a tablespace.
Given a partial application model, determine the indexes, and the type of indexes needed for the application.
Connect a client on a different machine to the server.
Create users and a group for application developers.
Determine whether concurrency is being used effectively on that Db2 instance.
Performance Measurement and Tuning
Given several execution plans, determine whether a performance problem exists and what is the solution.
Given a number of SQL queries, determine if the queries can be optimized based on the table organization, predicates, and filters.
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.