| Course Name |
Hours |
List Price |
Content |
| DB2110: DB2 11 for z/OS Transition - What Administrators Need to Know |
21.00 |
$1,920.00 |
|
Description: This workshop will prepare you to support the migration to DB2 11 and exploit the new features. The course begins with an overview of the migration process and helps you understand what you need to do in order to be ready. You will then consider many of the most popular new features and be able to exploit and support them in your environment.
# of Days:
Setting:
|
| DB3010: DB2 for z/OS Database Administration |
35.00 |
$3,200.00 |
|
Description: This course provides guidance information for Database and System Administration personnel responsible for the DB2 production and test Data Bases. The course covers creation, utility support, recovery, monitoring and management of DB2 Databases. Physical Database Implementation and control are the key issues addressed by this course.
# of Days:
Setting:
|
| DB3011 - DB2 for z/OS Database Recovery and Advanced Utilities |
21.00 |
$1,920.00 |
|
Description: In this course, you will cover guidance information for all personnel who will be participating in the Recovery of DB2 for z/OS Databases and Applications. Recovery detail includes Unit of Work Recovery, Current point in time and prior point in time recovery, Recovery analysis, Recovery from I/O errors, out of space conditions, building and implementing DB2 Recovery related utilities. Both data sharing and non-data sharing recovery considerations are covered.
# of Days:
Setting:
|
| DB3016: DB2 LUW Administration and Performance |
28.00 |
$2,450.00 |
|
Description: This course makes your life as a DB2 LUW DBA more productive. Over four days, this course covers the roles of the DBA and the activities that are important to the success of DB2. A special emphasis is placed on performance topics. This class uses hands-on and paper exercises to reinforce the topics covered. This class is current to DB2 10.5.
# of Days:
Setting:
|
| DB3052 - DB2 for z/OS Database Performance Tuning |
21.00 |
$1,920.00 |
|
Description: In this course, you will cover detail guidance information for all personnel who will be participating in DB2 for z/OS database performance analysis and tuning. Both data sharing and non-data sharing considerations are covered. Upon successful completion of this course, the student will be able to: Develop a Performance Monitoring Strategy, Reduce overall CPU consumption, Reduce overall lock , contention problems, Improve overall application response times, Identify and tune I/O overhead.
# of Days:
Setting:
|
| DB5001: DB2 for z/OS Installation, Migration and Systems Administration |
35.00 |
$3,200.00 |
|
Description: During this hands-on workshop the attendee will install their own Db2 subsystem, migrate their subsystem to a new release and implement additional Db2 functions. Detailed attention is given to Db2 in a data sharing environment, what facilities are supplied to manage and the recovery of system resources, the Db2 environment and how Db2 relates to the z/OS environment.
# of Days:
Setting:
|
| IBM: DB2 10.1 for Linux, UNIX, and Windows Quickstart for Experienced Relational DBAs |
28.00 |
$2,680.00 |
|
Description: This course teaches you to perform, basic and advanced, database administrative tasks using DB2 10.1 for Linux, UNIX, and Windows. These tasks include creating and populating databases and implementing a logical design to support recovery requirements. The access strategies selected by the DB2 Optimizer will be examined using the DB2 Explain tools. Various diagnostic methods will be presented, including using the db2diag.log file messages to direct your investigation of problems, as well as using the db2pd commands and DB2 traces. You will learn how to implement automatic archival for database logs and how to plan a redirected database restore to relocate either selected table spaces or an entire database. The selection of indexes to improve application performance and the use of SQL statements to track database performance and health will be covered. This course provides a quick start to DB2 database administration skills for experienced relational Database Administrators (DBA).
# of Days:
Setting:
|
| IBM: Db2 11.1 Quickstart for Experienced Relational DBAs (CL487G) |
28.00 |
$3,100.00 |
|
Description: This course teaches you to perform, basic and advanced, database administrative tasks using Db2 11.1. These tasks include creating and populating databases and implementing a logical design to support recovery requirements. The access strategies selected by the Db2 Optimizer will be examined using the Db2 Explain tools. Various diagnostic methods will be presented, including using various db2pd command options. Students will learn how to implement automatic archival for database logs and how to plan a redirected database restore to relocate either selected table spaces or an entire database. The REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces, will be discussed. We will also cover using the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases. The selection of indexes to improve application performance and the use of SQL statements to track database performance and health will be covered. This course provides a quick start to Db2 database administration skills for experienced relational Database Administrators (DBA).
The lab demonstrations are performed using DB2 LUW 11.1 for Linux. For some lab tasks, students will have the option to complete the task using a DB2 command line processor, or using the graphical interface provided by IBM Data Server Manager.
# of Days:
Setting:
|
| OR5460: Introduction to Oracle PL/SQL Programming |
21.00 |
$1,800.00 |
|
Description: The course provides a comprehensive introduction to PL/SQL, Oracles procedural language extension to SQL. PL/SQL is used to write stored procedures, packages, and database triggers. PL/SQL will be of particular interest to individuals developing applications in a client-server or multi-tier environment.This course can be taught for any Oracle version.
# of Days:
Setting:
|
| OR5470: Oracle Advanced PL/SQL Programming |
14.00 |
$1,195.00 |
|
Description: The course provides attendees with the background to develop stored PL/SQL programs including functions, procedures, packages, and triggers.Commonly used predefined packages provided with the Oracle DBMS are examined. Discussions include how these packages could be used as part of in-house applications. Additional PL/SQL features such as overloading programs, collections (arrays), bulk processing and autonomous transactions are also presented. Workshops provide students with the opportunity to use these features and evaluate their potential role in an application. This course can be taught for any Oracle version.
# of Days:
Setting:
|
| OR5475: Troubleshooting, Debugging and Tuning Oracle PL/SQL Programs |
14.00 |
$1,195.00 |
|
Description: This fast-paced, hands-on course helps the student identify performance issues and problem areas within their PL/SQL code using various techniques and packages. Some of the topics covered include Profiling and Tracing, Debugging, Tuning and Exception Handling. These topics include details on the PL/SQL Optimizer, Subprogram Inlining, Subprogram Invocations, Bulk Binding, Pipelined Table Functions, Helpful Pragmas and Native Compilation and Execution of PL/SQL code. A number of useful Oracle supplied packages are covered including DBMSPROFILER, DBMSTRACE, DBMSHPROF, DBMSWARNING and DBMSPARALLELEXECUTE. Oracle versions 11g and 12c are covered.
# of Days:
Setting:
|