DB2 Family Fundamentals

Schedule

Start End Duration Location Details

Course Details

DB2 Family Fundamentals

Duration: 2 Days

Course Code: CE031G

Prerequisite:

You should have:
•    Basic knowledge in data processing 

Course Description:

This course provides you with information about the functions of IBM's DB2, a relational database manager which may be installed under a variety of operating systems on many hardware platforms. DB2 runs under the z/OS, VM, Linux, UNIX, and Windows operating systems, to name a few. This course replaces course DB2 Family Fundamentals (CE030GB). This is the Classroom version of Instructor-Led Online course DB2 Family Fundamentals - Instructor Led Online (3E031GB) and Web-Based course DB2 Family Fundamentals - Web-Based (1E030GB).

Course Objecitves:

•    List and describe the major components of IBM's relational database, DB2 
•    Explain the characteristics of a DB2 table
•    Relate the basic concepts of data modeling
•    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 the responsibilities of, database and system administrators 
•    Establish a base for more specialized DB2 education 

Intended Audience:

This basic course is for persons needing an introductory knowledge of DB2, and persons preparing for advanced and specialized DB2 education.

Course Outline:

Understanding a Table

•    Identify the advantages of a relational database
•    Define a relation
•    Name the language used to talk to a
•    relational database manager (RDBM)
•    List three characteristics assigned to each column
•    Define the tasks performed by DB2 when running an application
•    Define the roles that are performed within DB2
•    Data Modeling and Database Design
•    State the purpose of a business model
•    Identify an Entity-Relational Diagram (ERD) model
•    List several DB2 column data types
•    Identify non-standard column and table Names
•    Identify the characteristics of a primary key and a foreign key
•    State the purpose of referential integrity
•    State the purpose of triggers
•    How does a user use DB2?
•    List several ways to talk to DB2
•    List multiple ways to generate an SQL statement
•    List several ways to ADD, REMOVE, or CHANGE table rows
•    List several ways to READ data and produce reports

How does a Programmer use DB2?

•    List the steps needed to create a test environment
•    List the necessary steps to coding SQL in a program
•    Describe the purpose of SQL delimiters

How does a Programmer use DB2?

•    List the steps needed to create a test environment
•    List the necessary steps to coding SQL in a program
•    Describe the purpose of SQL delimiters
•    Describe the purpose of an SQLCA
•    List the steps involved in preparing a program for execution
•    State the differences between static and dynamic SQL

What does an Administrator do in DB2?

•    List some of the tasks performed by a DB2 System Administrator: Identifying the DB2 product, Installing 082, creating subsystems/instances, databases and table spaces, Authorizing, and Monitoring
•    List some of the tasks performed by a DB2 Database Administrator: Creating, altering and dropping tables, views and indexes, Planning locking strategies, Running utility jobs and Authorizing

Information Managernent with DB2

•    List several planning considerations for distributing data
•    List some of the skills required to
•    successfully distribute data
•    Differentiate between rernote unit of work, distributed unit of work, and distributed request
•    List some of the security concerns when dealing with distributed data
•    List some of the other products that interface with DB2

Agenda
Day 1
•    Welcome
•    understanding a Table
•    Data Modeling and Database Design
•    How does a user use DB2?

Day 2
•    How does a Programmer use DB2?
•    What does an Administrator do in DB2?
•    Information Management with DB2