DB2 Family Introduction Mini-Curriculum

start > courses and registration > training feature sheet

This course has been upgraded to:

»	CE030 DB2 Family Fundamentals

This course is no longer publicly scheduled and displayed for reference purposes only. To find more information about this course expiry or request this archived course, send us an email.

DB2 Family Introduction Mini-Curriculum

course schedule			who can benefit
prerequisites			skills gained
other notes			course content
related solutions

code.

U5732

length.

4 days

type.

Instructor-Led

partner.

IBM

price.

$1,945

IACET credits 3.2

Learn the functions and components of IBM DB2 UDB, a relational database manager, which may be installed on a variety of operating systems. DB2 UDB runs under z/OS, AIX, Linux, HP-UX, Sun, and Windows operating systems.

Discuss the DB2 UDB products and services. Focus on the services DB2 UDB provides and how they work, not on DB2 UDB internal workings.

Learn about SQL and how it applies to the entire DB2 UDB Family. This course is appropriate for individuals working in a z/OS, VM/VSE, Linux, UNIX, or Windows environment. Complete extensive hands-on exercises to develop your skills to use the SQL you learn. Perform these exercises either by using the DB2 UDB for Linux, UNIX, and Windows product in a Windows environment or by using the DB2 UDB for z/OS product through a Time Sharing Option (TSO) interface to a z/OS system.

If you are interested in iSeries, AS/400, or AS/400e, you should complete:

	DB2 UDB for iSeries Fundamentals (S6145)
	Accessing the iSeries Database Using SQL (S6137)

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.

who can benefit

This is a basic course for individuals, who need introductory knowledge of DB2 UDB and who need to write, support, or understand SQL queries. This includes but is not limited to end users, programmers, application designers, database administrators, and system administrators.

It is also for individuals preparing for advanced and specialized DB2 UDB for z/OS Version 8 and DB2 UDB for Linux, UNIX, and Windows Version 8 education.

prerequisites

None.

skills gained

	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 that database system administrators perform or for which they are responsible
	Define 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
	Write basic Data Manipulation Language (DML) SQL statements: SELECT, INSERT, UPDATE, and DELETE
	Write basic Data Definition Language (DDL) SQL statements: CREATE TABLE and CREATE VIEW
	Establish a base for more specialized DB2 education

course materials

The course materials cover DB2 UDB for z/OS Version 8 and DB2 UDB for Linux, UNIX, and Windows Version 8.

hands-on labs

Seven labs are included to address using DB2 UDB for z/OS Version 8 and DB2 UDB for Linux, UNIX and Windows Version 8.

certification

Prepare for IBM Certification Test 700: DB2 UDB V8.1 Family Fundamentals

training path

This course is part of an IBM Training Path. Taking this course in the recommended sequence allows you to maximize the benefits from your education.

http://www-306.ibm.com/services/learning/ites.wss/us/en?pageType=page&contentID=a0000350

ibm education advantage program eligibility:

	Yes - IBM Education Pack - online account
	Yes - IBM Education Card
	Yes - IBM Corporate Education Pass

related courses, exams and materials

	after related training and products

	CE030 DB2 Family Fundamentals
	CE120 SQL Workshop

course content details

	Understanding a table

	list three services provided by a database manager
	define a relation
	name the language used to talk to a Relational Database Manager (RDBM)
	list three characteristics assigned to each column
	list several data types that can be assigned to a column
	list three forms of key used in DB2 UDB tables
	list three services provided by a database manager

	How does an end user use DB2 UDB?

	list several ways to talk to DB2 UDB
	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 UDB?

	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 SQL Communication Area (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 UDB?

list some of the tasks performed by the DB2 UDB administrators: installing, creating, binding, and maintaining

	Data modeling and database design

	state the purpose of a business model
	identify and Entity-Relationship Diagram (ERD) model
	state the purpose of an association table
	list several DB2 UDB column data types
	identify non-standard column and table names
	identify the characteristics of a primary key and foreign key
	state the purpose of referential integrity

	Distributed data processing terminology

	list several planning considerations for distributed data
	list some of the skills required to successfully distribute data
	differentiate between remote unit of work, distributed unit of work, and distributed request

	Introduction

	define the terms database, table, row, column, and view
	state the most common DB2 UDB data types
	list the most commonly used SQL statements in DDL
	list the most commonly used SQL statements in DML
	list the most commonly used SQL statements in Data Control Language (DCL)
	state three null characteristics and their meaning

	Simple SQL queries

	describe four SELECT statement clauses (SELECT, FROM WHERE, and ORDER BY) and their purpose
	retrieve all rows of a table
	retrieve specific columns
	retrieve rows based on comparisons to numeric or alphanumeric column values
	use the keywords BETWEEN, IN, LIKE, and DISTINCT
	order the resulting rows in a desired sequence

	Retrieving data from multiple tables

	retrieve data from more than one table or view
	specify JOIN predicates
	use correlation names in queries

	Scalar functions and arithmetic

	use arithmetic in the SELECT and WHERE clauses
	specify basic scalar functions such as COALESCE/VALUE, DECIMAL, and SUBSTR
	use date and time scalar functions
	use the CONCAT operator

	Column functions and grouping

	describe the difference between scalar and column functions
	list the most common DB2 column functions
	group rows into sets based on one or more columns

	Union

	use subqueries in the WHERE and HAVING clauses
	code subqueies using basic predicates
	code subqueries using the IN keyword

	Maintaining data

	create a simple table for testing DML statements
	create a simple view
	insert rows into a table
	update data in a table
	delete rows from a table
	drop a table

	Daily Agenda

	Day 1

	CF030 - Welcome
	CF030 - Understanding a table
	CF030 - Data modeling and database design
	CF030 - How does a user use DB2 UDB?

	Day 2

	CF030 - How does a programmer use DB2 UDB?
	CF030 - What does an administrator do in DB2 UDB?
	CF030 - Information management with DB2

	Day 3

	CF120 - Welcome
	CF120 - Introduction
	CF120 - Simple SQL Queries
	CF120 - Exercises
	CF120 - Retrieving Data from Multiple Tables
	CF120 - Exercises
	CF120 - Scalar Functions and Arithmetic
	CF120 - Exercises

	Day 4

	CF120 - Column Functions and Grouping
	CF120 - Exercises
	CF120 - Union
	CF120 - Exercises
	CF120 - Using Subqueries
	CF120 - Exercises
	CF120 - Maintaining Data
	CF120 - Exercises