DB2 - Course List
Search Course
Course ID Course Name Hours Price Content Schedule
0370-100-CO-W
Course Number: 0370-100-CO-W
Course Name: CO1010 - Introduction to COBOL Programming
# of class dates: 0
Description: In this course, you will cover information for provides application developers with basic knowledge in developing COBOL programs in a mainframe environment. Upon successful completion of this course, the student will be able to Code and Test COBOL batch p...
CO1010 - Introduction to COBOL Programming
Course Number: 0370-100-CO-W
Course Name: CO1010 - Introduction to COBOL Programming

# of class dates: 0

Description: In this course, you will cover information for provides application developers with basic knowledge in developing COBOL programs in a mainframe environment. Upon successful completion of this course, the student will be able to Code and Test COBOL batch p...
35 $2475.00
0370-239-ZZ-W
Course Number: 0370-239-ZZ-W
Course Name: DB1000 - DB2 SQL for Everyone
# of class dates: 0
Description: Come prepared to master Structured Query Language on the DB2 platform in this fast paced and hands-on course. The course begins with a discussion of relational concepts and terminology and quickly moves into a very practical discussion of data retrieval an...
DB1000 - DB2 SQL for Everyone
Course Number: 0370-239-ZZ-W
Course Name: DB1000 - DB2 SQL for Everyone

# of class dates: 0

Description: Come prepared to master Structured Query Language on the DB2 platform in this fast paced and hands-on course. The course begins with a discussion of relational concepts and terminology and quickly moves into a very practical discussion of data retrieval an...
21 $1625.00
0370-230-DB-W
Course Number: 0370-230-DB-W
Course Name: DB1006: DB2 LUW Advanced Query Tuning with IBM Data Studio
# of class dates: 0
Description: This course is designed for the DB2 LUW development professional who desires to understand the fundamental issues associated with performance for DB2 SQL applications. Emphasis is placed on understanding optimization and the many access paths chosen by the...
DB1006: DB2 LUW Advanced Query Tuning with IBM Data Studio
Course Number: 0370-230-DB-W
Course Name: DB1006: DB2 LUW Advanced Query Tuning with IBM Data Studio

# of class dates: 0

Description: This course is designed for the DB2 LUW development professional who desires to understand the fundamental issues associated with performance for DB2 SQL applications. Emphasis is placed on understanding optimization and the many access paths chosen by the...
21 $1625.00
0370-222-DB-W
Course Number: 0370-222-DB-W
Course Name: DB1010: DB2 for z/OS SQL & Application Programming
# of class dates: 8
Description: DB2 SQL and Application Programming is a 5 day course targeting the needs of programmers and developers writing applications that access data stored in the DB2 environment. The presentation is an integrated mixture of lecture and workshop activities that...
DB1010: DB2 for z/OS SQL & Application Programming
Course Number: 0370-222-DB-W
Course Name: DB1010: DB2 for z/OS SQL & Application Programming

# of class dates: 8

Description: DB2 SQL and Application Programming is a 5 day course targeting the needs of programmers and developers writing applications that access data stored in the DB2 environment. The presentation is an integrated mixture of lecture and workshop activities that...
35 $2475.00
0370-226-DB-W
Course Number: 0370-226-DB-W
Course Name: DB1029: Exploiting Native SQL Stored Procedures on DB2 for z/OS
# of class dates: 8
Description: One of the most anticipated new features of DB2 for z/OS was the Native SQL PL stored procedure. A key advantage is the ability to work entirely within the IBM Data Studio environment and accomplish DB2 development with no green screen. This course covers ...
DB1029: Exploiting Native SQL Stored Procedures on DB2 for z/OS
Course Number: 0370-226-DB-W
Course Name: DB1029: Exploiting Native SQL Stored Procedures on DB2 for z/OS

# of class dates: 8

Description: One of the most anticipated new features of DB2 for z/OS was the Native SQL PL stored procedure. A key advantage is the ability to work entirely within the IBM Data Studio environment and accomplish DB2 development with no green screen. This course covers ...
21 $1625.00
0370-212-DB-W
Course Number: 0370-212-DB-W
Course Name: DB1032: DB2 for z/OS SQL Optimization, Performance & Tuning
# of class dates: 0
Description: This class is designed to breakdown SQL statements in detail so the students understand in depth what the DB2 optimizer goes through in fulfilling an SQL request. Time will especially be spent breaking down SQL Joins and Subqueries in order to understand t...
DB1032: DB2 for z/OS SQL Optimization, Performance & Tuning
Course Number: 0370-212-DB-W
Course Name: DB1032: DB2 for z/OS SQL Optimization, Performance & Tuning

# of class dates: 0

Description: This class is designed to breakdown SQL statements in detail so the students understand in depth what the DB2 optimizer goes through in fulfilling an SQL request. Time will especially be spent breaking down SQL Joins and Subqueries in order to understand t...
28 $2450.00
0370-235-ZZ-W
Course Number: 0370-235-ZZ-W
Course Name: DB1037: Advanced Query Tuning with IBM Data Studio on DB2 for z/OS
# of class dates: 0
Description: Get ready for a deep dive into DB2 for z/OS Optimization. This course is for the DB2 for z/OS development professional who desires to understand the fundamental issues associated with performance for SQL applications. Emphasis is placed on new considerati...
DB1037: Advanced Query Tuning with IBM Data Studio on DB2 for z/OS
Course Number: 0370-235-ZZ-W
Course Name: DB1037: Advanced Query Tuning with IBM Data Studio on DB2 for z/OS

# of class dates: 0

Description: Get ready for a deep dive into DB2 for z/OS Optimization. This course is for the DB2 for z/OS development professional who desires to understand the fundamental issues associated with performance for SQL applications. Emphasis is placed on new considerati...
21 $1625.00
0370-220-DB-W
Course Number: 0370-220-DB-W
Course Name: DB1041: Advanced SQL for DB2
# of class dates: 0
Description: Get ready to go deep with Structured Query Language (SQL) and become a power user. Whether you are being asked to solve complicated problems with SQL or you need to read and understand complex SQL that is already written, this course is for you! Come prepa...
DB1041: Advanced SQL for DB2
Course Number: 0370-220-DB-W
Course Name: DB1041: Advanced SQL for DB2

# of class dates: 0

Description: Get ready to go deep with Structured Query Language (SQL) and become a power user. Whether you are being asked to solve complicated problems with SQL or you need to read and understand complex SQL that is already written, this course is for you! Come prepa...
21 $1795.00
0370-221-DB-W
Course Number: 0370-221-DB-W
Course Name: DB1051: High Performance Application Design on DB2 z/OS
# of class dates: 16
Description: Implementing logical database and physical design on DB2 for z/OS requires an understanding of the inner workings of this platform. Learn and discuss some of the things to consider when making this transition in this action packed course. Application desig...
DB1051: High Performance Application Design on DB2 z/OS
Course Number: 0370-221-DB-W
Course Name: DB1051: High Performance Application Design on DB2 z/OS

# of class dates: 16

Description: Implementing logical database and physical design on DB2 for z/OS requires an understanding of the inner workings of this platform. Learn and discuss some of the things to consider when making this transition in this action packed course. Application desig...
21 $1625.00
0370-228-DB-W
Course Number: 0370-228-DB-W
Course Name: DB2110: DB2 11 for z/OS Transition - What Administrators Need to Know
# of class dates: 8
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 th...
DB2110: DB2 11 for z/OS Transition - What Administrators Need to Know
Course Number: 0370-228-DB-W
Course Name: DB2110: DB2 11 for z/OS Transition - What Administrators Need to Know

# of class dates: 8

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 th...
21 $1625.00
0371-000-ZZ-W
Course Number: 0371-000-ZZ-W
Course Name: DB3010: DB2 for z/OS Database Administration
# of class dates: 1
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 D...
DB3010: DB2 for z/OS Database Administration
Course Number: 0371-000-ZZ-W
Course Name: DB3010: DB2 for z/OS Database Administration

# of class dates: 1

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 D...
35 $2950.00
0371-409-ZZ-W
Course Number: 0371-409-ZZ-W
Course Name: DB3011 - DB2 for z/OS Database Recovery and Advanced Utilities
# of class dates: 0
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 recove...
DB3011 - DB2 for z/OS Database Recovery and Advanced Utilities
Course Number: 0371-409-ZZ-W
Course Name: DB3011 - DB2 for z/OS Database Recovery and Advanced Utilities

# of class dates: 0

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 recove...
21 $1800.00
0370-229-DB-W
Course Number: 0370-229-DB-W
Course Name: DB3016: DB2 LUW Administration
# of class dates: 8
Description: This course is designed to review the concepts and components of DB2 version 9.5 for LINUX, UNIX and Windows. This course has 3 major sections: basic administration, advanced recovery and performance and tuning. DB2 commands and SQL will be used to focus o...
DB3016: DB2 LUW Administration
Course Number: 0370-229-DB-W
Course Name: DB3016: DB2 LUW Administration

# of class dates: 8

Description: This course is designed to review the concepts and components of DB2 version 9.5 for LINUX, UNIX and Windows. This course has 3 major sections: basic administration, advanced recovery and performance and tuning. DB2 commands and SQL will be used to focus o...
35 $2950.00
0370-305-DB-W
Course Number: 0370-305-DB-W
Course Name: DB3052 - DB2 for z/OS Database Performance Tuning
# of class dates: 0
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 ...
DB3052 - DB2 for z/OS Database Performance Tuning
Course Number: 0370-305-DB-W
Course Name: DB3052 - DB2 for z/OS Database Performance Tuning

# of class dates: 0

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 ...
21 $1800.00
0370-236-ZZ-W
Course Number: 0370-236-ZZ-W
Course Name: DB5010: DB2 for z/OS System Administration & Performance Basics
# of class dates: 0
Description: This 4-day course is a must for all personnel who need a comprehensive understanding of the DB2 System environment. During this hands-on course the attendee will install their own DB2 subsystem, migrate their subsystem to a new release and analyze each add...
DB5010: DB2 for z/OS System Administration & Performance Basics
Course Number: 0370-236-ZZ-W
Course Name: DB5010: DB2 for z/OS System Administration & Performance Basics

# of class dates: 0

Description: This 4-day course is a must for all personnel who need a comprehensive understanding of the DB2 System environment. During this hands-on course the attendee will install their own DB2 subsystem, migrate their subsystem to a new release and analyze each add...
28 $2250.00
0370-370-10.1-W
Course Number: 0370-370-10.1-W
Course Name: IBM: DB2 10.1 for Linux, UNIX, and Windows Quickstart for Experienced Relational DBAs
# of class dates: 0
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...
IBM: DB2 10.1 for Linux, UNIX, and Windows Quickstart for Experienced Relational DBAs
Course Number: 0370-370-10.1-W
Course Name: IBM: DB2 10.1 for Linux, UNIX, and Windows Quickstart for Experienced Relational DBAs

# of class dates: 0

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...
28 $2680.00
0370-378-OS-Z
Course Number: 0370-378-OS-Z
Course Name: RX1020: Advanced z/OS REXX Programming
# of class dates: 0
Description: This course will introduce students to the skills necessary to code REXX execs in z/OS environments. A series of written and lab exercises will be used to reinforce the classroom education.
RX1020: Advanced z/OS REXX Programming
Course Number: 0370-378-OS-Z
Course Name: RX1020: Advanced z/OS REXX Programming

# of class dates: 0

Description: This course will introduce students to the skills necessary to code REXX execs in z/OS environments. A series of written and lab exercises will be used to reinforce the classroom education.
14 $1200.00
0370-100-SS-W
Course Number: 0370-100-SS-W
Course Name: SS2205 - Introduction to SQL Server 2012 for Administrators
# of class dates: 16
Description: In this course, you will cover installing SQL Server 2012 (high-level overview), working with the Administration Tools, Creating SQL Server Databases, Creating Tables, Indexes and Views, Creating Jobs, Operators, and Alerts, Performance Monitoring and Tuni...
SS2205 - Introduction to SQL Server 2012 for Administrators
Course Number: 0370-100-SS-W
Course Name: SS2205 - Introduction to SQL Server 2012 for Administrators

# of class dates: 16

Description: In this course, you will cover installing SQL Server 2012 (high-level overview), working with the Administration Tools, Creating SQL Server Databases, Creating Tables, Indexes and Views, Creating Jobs, Operators, and Alerts, Performance Monitoring and Tuni...
21 $1625.00
0370-227-DB-W
Course Number: 0370-227-DB-W
Course Name: UI1015: Introduction to UNIX and Shell Programming
# of class dates: 16
Description: This course will provide an in-depth introduction to the effective use of the UNIX Operating System. Topics covered include the operating system’s major features and facilities, frequently used commands, command usage, the vi text editor, the File System, ...
UI1015: Introduction to UNIX and Shell Programming
Course Number: 0370-227-DB-W
Course Name: UI1015: Introduction to UNIX and Shell Programming

# of class dates: 16

Description: This course will provide an in-depth introduction to the effective use of the UNIX Operating System. Topics covered include the operating system’s major features and facilities, frequently used commands, command usage, the vi text editor, the File System, ...
35 $2475.00
0370-224-DB-W
Course Number: 0370-224-DB-W
Course Name: XM1000: Fundamentals of XML
# of class dates: 8
Description: This course is an intensive, hands-on introduction to XML, DTDs, Schemas, XPath, and XSLT. It is a balanced mixture of theory and practical labs designed to take students through the basic fundamentals of XML. Beginning with the basics of XML, this course ...
XM1000: Fundamentals of XML
Course Number: 0370-224-DB-W
Course Name: XM1000: Fundamentals of XML

# of class dates: 8

Description: This course is an intensive, hands-on introduction to XML, DTDs, Schemas, XPath, and XSLT. It is a balanced mixture of theory and practical labs designed to take students through the basic fundamentals of XML. Beginning with the basics of XML, this course ...
21 $1625.00