Provided by: Interskill Learning

1.1 DB2 Overview

DB2

Interskill Learning
This is course 1 of 2 in the Database Series. The course is delivered via e-Learning. It can be accessed online, at any time, place or location with internet access, or delivered through your own internal LMS (if applicable). The course is available as part of the Database Series, or in a Mainframe Bundle, comprising of the 100 most popular mainframe e-Learning titles.
This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Course Level:introductory
Duration:3 hours
Training Presented in:English
Training Provided by Interskill Learning
1.1 DB2 Overview
Duration

2 to 3 hours

Overview Audience

Personnel requiring an introduction to DB2.

Prerequisites

Basic knowledge of Data Processing concepts.

Objectives

After completing this course, the student will be able to:
• Define the concepts of DB2
• Define the basics of SQL
• Identify how to start and stop the system
• Identify how to monitor and restart the system

Course Content
Overview of DB2

Introduction, DB2, SQL
Tables
Security
Availability and Recoverability

Overview of Structured Query Language (SQL)

Command Syntax of Common SQL Statements

DB2 Operations

Starting/ Stopping DB2 Subsystem
Entering Commands to DB2
Monitoring DB2 Subsystem

DB2 Recovery and Restart Facilities

Log and Boot Start Data Set
Termination and Restart of the DB2 System
Case Examples of DB2 Failures

Accessing DB2 Using SPUFI

Execution from TSO

About The Training Provider: Interskill Learning
Interskill Learning - Interskill Learning is a worldwide leader in the provision of e-learning, delivering reliable, quality learning solutions since 1991 to over 1500 organisations. With 1000s of titles to chose from in mainframe, desktop, IT and business subject areas, Interskill offers a comprehensive training solution for your entire workforce, regardless of their department, location or language. With three...
Custom Search
tcw11-v473M-02/09/12-13:10:11-()[A]-[A]-[B] -19:17:28