Format

Classroom

Duration

3.0 Day(s)

Description

This course provides you with information about the functions of IBM's DB2&regtm. Universal Database (DB2 UDB), a relational database manager which may be installed under a variety of operating systems on many hardware platforms. DB2 UDB runs under the MVS, VM, OS/2 and Windows NT operating systems and LINUX, operating systems to name a few.
The course includes discussion of how the DB2 UDB products provide services. The focus is on the services DB2 provides and how we will work with DB2 UDB, not on its internal workings.

Audience

Anyone who needs introductory knowledge of DB2 and persons preparing for advanced and specialized DB2 education.

Objectives

After completing this course, you should be able to:
- List and describe the major components of IBM's relational database DB2 UDB
- Explain the characteristics of a DB2 table
- Identify the characteristics of various DB2 column data types
- Comprehend the processing instructions given to DB2 via simple SQL statements
- List and describe several ways to build (write) and execute SQL statements
- List and describe steps needed to imbed SQL statements in an application program
- Explain some of the functions performed by, and responsibilities of, Database and System Administrators
- Understand the basic concepts of data modeling
- Describe the concepts involved with distributed data and some implementation considerations
- Describe data warehousing and some of the products involved
- Establish a base for more specialized DB2 education

Contents

- Understanding A Table
- How Does an End-User Use DB2 UDB?
- How Does an Programmer Use DB2 UDB?
- What Does an Administrator Do in DB2 UDB?
- Data Modeling and Database Design
- Distributed Data Processing Terminology