Canada IT Courses
ExitCertified US




ExitCertified - Excellence in IT Certified Education
 
IT education classes
IT training feature sheet
 
   
 
start > courses and registration > training feature sheet
DB2 Data Warehouse Edition 9 components
 
 
 
 
ibm certified training   this course works with savings passes
 
code. DW350   length. 5 days
type. Instructor-Led   partner. IBM
price.
$3,125  
 
IACET credits 4.0
 
Become familiar with the components of DB2 Data Warehouse Edition. Focus on the SQL Warehouse Tool, DB2 Intelligent Miner, Cube Views, and their common interface, the Design Studio. Examine components such as DB2 Alphablox and the Database Partitioning Feature at a higher level. This is due to the fact that there are existing courses that cover those components in great detail. In the exercises focus on the SQL Warehousing Tool, DB2 Intelligent Miner, and Cube Views. However, there is a DB2 Alphablox exercise, and DB2 Alphablox is used to access DB2 data based on Cube Views metadata.
 
course schedule  
 
Towson/Baltimore, MD jun.9.2008 - jun.13.2008 register register
     
   
Request another training Date Request onsite training
 
who can benefit
  
 
This is an intermediate course for individuals who administer one or more of the components that come with DB2 Data Warehouse Edition.
 
prerequisites
  
 
You should have Database Administrator (DBA) experience, regular use of DB2 UDB, and Microsoft Windows experience.
 
skills gained
  
 

Describe the components of DB2 Data Warehouse Edition
Define a DB2 Alphablox cube based upon Cube Views metadata
Use the Design Studio to physically model tables that are used as sources and targets for the SQL Warehouse Tool.
Use the Design Studio to create Data Flows in order to move data within DB2
Combine Data Flows into Control Flows and deploy the Control Flows into the SQL Warehouse Tool runtime environment
Describe the different data mining algorithms supported by DB2 Intelligent Miner
Create Mining Flows that create data mining models and score those models against new data
Use DB2 Intelligent Miner Visualizers to view data mining results
Create Mining Flows that use DB2 Intelligent Miner Modeling
Create Mining Flows that invoke DB2 Intelligent Miner Scoring to score DB2 data using previously created data mining models
Describe how Cube Views can be used as an Online Analytical Processing (OLAP) metadata store
Create Data Flows that will populate a star schema and then define OLAP metadata that describes that star schema to Cube Views
Use Cube Views to create Materialized Query Tables (MQT) to enhance some OLAP tools' performance


 
course materials
  
 
The course materials cover DB2 Data Warehouse Edition V9.1.
 
hands-on labs
  
 
Twelve labs are included to address functionality of Data Warehouse Edition components.
 
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.ibm.com/services/learning/ites.wss/us/en?pageType=page&contentID=a0000266



 
ibm education advantage program eligibility:
  
 

Yes - IBM Education Pack - online account


 
related courses, exams and materials
  
 


  other related training and products


 
course content details  
 


  DB2 Data Warehouse Edition Components Overview

define what DB2 Data Warehouse Edition is
describe the DB2 Data Warehouse Edition architecture
list the components of DB2 Data Warehouse Edition
describe the installation process
explain how DB2 Query Patroller can be used to control queries
list the benefits of Database Partitioning




  Design Studio

describe the Eclipse platform
explain how to use perspectives in the Design Studio
list the components of the Business Intelligence perspective
explain how to customize Design Studio perspectives




  Physical Data Modeling

explain how to create physical data models from scratch or by reverse engineering
describe how to validate the model using Analyze Model
generate a Data Definition Language (DDL) script to deploy your model to a database
compare objects in the project to the database to generate a delta DDL script




  SQL Warehouse Tool

describe the use of the SQL Warehousing Tool
list the SQL Warehousing Tool components
explain the use of Data Flow: operators; ports; connectors
list the components of a data warehouse project
describe the use of variables in the SQL Warehousing Tool
define a Data Station operator
describe an execution plan graph




  Control Flows

define a Control Flow
list the components of a Control Flow
describe Control Flow ports
explain how to use the Control Flow iterator
describe the integration between SQL Warehousing Tool (SQW) and DataStage
explain how to import a DataStage parallel job to run in SQW
list the SQL and DataStage integration points




  Administration Console

describe the SQW deployment process
explain the use of application profiles
list the functions of the Administration Console
explain the role based security used by the Administration Console




  Introduction to Cube Views

define OLAP and its position with Business Intelligence
contrast different types of OLAP
state the benefits of OLAP
list the components of Cube Views
define Summary Tables as used by Cube Views
describe how Cube Views exploits Summary Tables
state the benefits of using Cube Views




  Cube Views

describe the features of Cube Views
explain how OLAP metadata is transferred to partner's products
list the main tasks when defining a cube model
use the Design Studio to create and manage OLAP metadata
work with different hierarchy types
discuss the use of different attribute types
define advanced measures for a cube model
describe the enhanced model support




  Cube Views Optimization Advisor

state the benefits of using Summary Tables
compare SQL used to create different Summary Tables
use Optimization Advisor to generate Summary Table scripts for four different query types




  DB2 Alphablox Overview

define what is a DB2 Alphablox application
describe what Blox are
describe the DB2 Alphablox architecture
explain the three tiers that make up the DB2 Alphablox platform




  DB2 Alphablox Basics

perform the steps to define:
an DB2 Alphablox application
a user for accessing DB2 Alphablox Applications
a data source accessed by DB2 Alphablox applications
a cube to access relational data as though it were multi-dimensional
launch the application
name the major Blox categories and give an example of a Blox in each category
describe how Blox are implemented
describe basic tag syntax




  An Overview of Data Mining

define data mining
distinguish between verification-driven and discovery-driven analysis
list the different types of mining kernels
discuss where data mining can be applied
give an example of data mining


  A Data Mining Process

describe the key elements for a successful data mining project
describe the purposes and uses of a data mining process
state six steps in a data mining process
discuss the importance of the six steps




  An Introduction to DB2 Intelligent Miner

describe the components of DB2 Intelligent Miner
list the different model types supported by DB2 Intelligent Miner Modeling
describe how IDB2 intelligent Miner Scoring is used
explain how to inspect your data using different distributions: univariate, bivariate, and multivariate
describe how to execute a Mining Flow
discuss how to generate a Java class from a Mining Flow




  DB2 Intelligent Miner Supported Mining Techniques

describe the Cluster function used in DB2 Intelligent Miner Modeling
describe the Classification function used in DB2 Intelligent Miner Modeling
describe the Regression function used in DB2 Intelligent Miner Modeling
describe the Associations function used in DB2 Intelligent Miner Modeling
describe the Sequential Rule function used in DB2 Intelligent Miner modeling




  DB2 Intelligent Miner Easy Mining

discuss how to prepare to use Easy Mining
differentiate between: procedures for common mining tasks and procedures for basic mining step
list the Easy Mining procedures for common mining tasks
list the Easy Mining procedures for basic mining steps




  Daily Agenda - Day 1

welcome
DB2 Data Warehouse Edition components overview
Design Studio
exercise for Design Studio
Data modeling
exercise for data modeling
SQL Warehouse Tool




  Day 2

exercise for SQL Warehouse Tool
Control Flows
exercise for Control Flows
administration console
exercise for Administration Console




  Day 3

an introduction to Cube Views
Cube Views
exercise for Cube Views
Cube Views Optimization Advisor
exercise for Optimization Advisor




  Day 4

DB2 Alphablox overview
DB2 Alphablox basics
exercise for DB2 Alphablox basics
an overview of Data Mining
a Data Mining process
introduction to DB2 Intelligent Miner
DB2 Intelligent Miner supported mining techniques
Clustering functions
exercise for clustering




  Day 5

DB2 Intelligent Miner supported mining techniques (continued)
predictive models
exercise for prediction
associations and sequential rule
exercise for associations and sequential rule
DB2 Intelligent Miner easy mining
exercise for DB2 Intelligent Miner easy mining





 
Free PSP - FREE GPS

Save on IBM Training



find a course
 
phone us
 
view course schedule





Free PSP - FREE GPS

 
go to top
Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education
© 2008 ExitCertified. All rights reserved.
terms of use and disclaimer :: privacy policy :: webmaster :: link to us
   
Sacramento Training :: 916.669.3970 | Las Vegas Training :: 1.800.803.EXIT (3948) | San Francisco Training :: 415.975.3948 | San Jose Training :: 408.288.EXIT (3948)
Phoenix, Arizona Training | Los Angeles, California Training | San Diego, California Training | Broomfield, Colorado Training | Fort Lauderdale, Florida Training
Tampa, Florida Training | Atlanta, Georgia | Downers Grove, Illinois | Kansas City, Kansas Training | Portland, Maine Training | Baltimore, Maryland Training | Burlington, Massachusetts Training
Troy, Detroit, Michigan Training | Minneapolis, Minesota Training | St. Louis, Missouri Training | Omaha, Nebraska Training | Edison, New Jersey Training | New York City, New York Training
Raleigh, North Carolina Training | Columbus, Ohio Training | Philadelphia, Pennsylvania Training | Nashville, Tennessee Training | Dallas, Texas Training
Houston, Texas Training | Hampton, Virginia Training | Madison, Wisconsin Training | Seattle, Washington Training

ExitCertified is a global provider of authorized technology training. Some of our popular course topic searches include:

Java Training | J2EE Training | JSP Training | Java Courses | Servlets Training | EJB Training | Struts Training | Networking Courses | Solaris Training
Red Hat Training | SUSE Training | XML Training | Oracle SQL | Oracle PL/SQL | DBA Training | DBA Certification | Oracle Certification
RedHat Training | Solaris Certification | Java Certification | Veritas Certification | PeopleSoft Training | 11g Training | 11g Certification
RedHat Courses | SQL Training | 10g Training | 9i Training | Application Development Training | Certified Training | Corporate Training
Government Training | Course Catalogue | Training Schedule | Certification Training | Project Management Training | Linux Training
Solaris 10 Training | Unix Training | NetBackup Training | Virus Protection Courses | Education Technology Newsletter | zSeries Training
s/390 Training | iSeries Training | DB2 Training | OS/400 Training | AIX Training | Rational Courses | PMI Training | Project Management Training
SeeBeyond Training | Java Composite Application Platform (JCAPS) Training | MySQL Training | MySQL Database Course | Hyperion Training | Fusion Middleware