Interskill Learning Mainframe Training

770-872-4278

The Online Mainframe Training Specialists
Search   Course Catalog   Live Chat!  
Return to Catalog Home

DB2 - Database Curriculum

Course Title Duration Description
DB2 Operations Series

Note: DB2 v10 is also available.
DB2 Fundamentals
5 The DB2 Fundamentals course describes what DB2 is, how it is used and the components that comprise its structure. An overview of the SQL language, which is used to communicate with DB2, is provided along with details on how it is used with SPUFI.
Managing DB2 Operations
4 The Managing DB2 Operations course looks at DB2 from an Operations viewpoint, describing DB2 startup and shutdown, common operator tasks, message interpretation and restart and recovery considerations. A number of commands used to analyze the status of DB2 components are discussed as well as the facilities associated with backup, recovery and restart.
DB2 - Database Management System Series
Introduction to RDBMSs and DB2
4 The Introduction to RDBMSs and DB2 course describes from a Database Administrator's (DBA) viewpoint how DB2 is used and the types of DB2-related tasks that the DBA performs. The course also looks at DB2's system configuration requirements and how it is implemented in a z/OS environment.
Manage Data Definitions with DB2
6 The Manage Data Definitions with DB2 course describes how SQL is used to define a DB2 database and its associated objects. It looks at SQL statement syntax and the methods used to invoke SQL statements.
DB2 SQL Fundamentals
4 (Previously titled Manage Data with DB2 SQL in the v10 Curriculm) The DB2 SQL Fundamentals course looks at some of the more common SQL statements used by programmers when starting out. It addresses the code used to obtain DB2 table data, sort it, as well as methods used for inserting, deleting, updating and merging table data.
Advanced DB2 SQL
4 The Advanced DB2 SQL course discusses some of the more advanced SQL code used to manipulate table data. Various methods used for joining tables is presented, along with examples of SQL statements and subqueries used to filter data results.
Create and Maintain DB2 Programs
6 The Create and Maintain DB2 Programs course describes how SQL is invoked from an application program and the interaction that can occur between the application program and DB2. This course also discusses how a DB2 COBOL Program is created.
DB2 Stored Procedures
3 The DB2 Stored Procedures course describes how stored procedures are used and the platforms on which they can be implemented. The benefits derived from using stored procedures are discussed as well as security implications associated with them.
Optimize DB2 Application Performance
5 The Optimize DB2 Application Performance course describes the methods used by DB2 when processing application programs containing SQL, and provides details of the tools and utilities that can be used to measure and analyse their effectiveness.
Looking for more information about Interskill Learning Products?
Contact our Learning Consultants or call us at 770-872-4278