IB-Learning: practical, hands-on training for software developers, software testers, business analysts and project managers

Spotlight On

• Curriculums
  • Business Analysis
  • Business Skills
  • Mainframe
  • Relational Database Management Systems
  • Software Testing
  • Windows Desktop
  • WebSphere MQ
  • Project Management
  • IT Service Management
  
  
• Class Schedules
• Facility Rentals
• Special Offers!

DB2 Concepts and Facilities - D200 ( 1 Day )

Course Outline

Abstract/Overview

This seminar is a survey course in IBM"s strategic, relational database product, providing a comprehensive overview of DB2 for OS/390 UDB. Topics range from an introduction to Relational Database concepts to an overview of the Structured Query Language (SQL), and a brief review of the DB2 application development environment.

Audience - Who Should Attend?

This course is designed as a basic introduction to DB2 for any level of Information Technology staff. End user communities who use DB2-based applications in their day-to-day work will also benefit from this seminar.

Prerequisite

A basic familiarity with data processing concepts is assumed. No database experience is required.

Objective

• Understand the major characteristics of the Relational Model.
• Understand the basic components of the DB2 product, and its major operating platforms.
• Become familiar with fundamental DB2 objects including Universal Data Base support.
• Learn about DB2’s security mechanism.
• Understand referential integrity.
• Review the Structured Query Language including its sub-languages.
• Understand how DB2 affects the application development environment and process.

Content

Introduction

• The Evolution of Database
• Why Relational?

• The Relational Model
• Table, Column, Row
• Primary Key, Foreign Key
• Integrity

• Product Overview
• Operating Platforms
• Related Products

• The DB2 Objects and UDB Support
• The Catalog
• Structured Query Language
• Security
• Referential Integrity
  

• Data Manipulation Language
• Data Definition Language
• Data Control Language
• Using the SQL Language

• The Application Development Process
• Programmed Applications
• End User Applications
• Productivity Tools - SPUFI