DB2 Federated Database: Integrating Diverse Data (CF47AU)

IBM Australia Ltd
Sydney,Melbourne,PERTH,BRISBANE,CANBERRA CITY, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Duration 3.0 Day(s)
Description This course is designed to provide the student with the ability to describe the advantages of DB2 Federated Technology in implementing Data Warehouse and OLTP e-business solutions. The course also prepares the student to implement a multi-vendor, multi-platform Federated Database environment using DB2 UDB for UNIX, Windows and OS/2 V7.2, DB2 Connect V7.2 and DB2 Relational Connect.
Audience This course is appropriate for database administrators; application programmers; data warehouse administrators; systems architects; consultants, e-business, business intelligence, application integration, system integration professionals, and all other professionals with an interest in architecting, planning and constructing an Integrated Data Warehouse and/or OLTP solution.
Prerequisites Before taking this course, you should understand the basic concepts of a relational database and its usage within a business. This can be accomplished by completing IBM course CT03AU or DT03AU. Students are also expected to be able to configure DB2 clients using the DB2 Client Configuration Assistant or manual means. Alternatively, the student should be able to setup client/server connectivity for either Oracle or Microsoft SQL databases.
Objectives After completing this course, you should be able to:
Describe the advantages of using DB2 Federated Technology for your systems and application integration project needs
Describe the architectural and product components of an integrated Data Warehouse (DW) or OLTP e-business solution related to DB2¡¯s federated database approach This includes the DB2 Relational Connect; DB2 UDB for UNIX, Windows and OS/2; and/or DB2 Connect products in addition to the back end data sources which are part of the federated environment.
Using the DB2 UDB Control Center, configure an operational federated database environment between any member of the DB2 UDB Family, and supported non-IBM sources (that is, Oracle and Microsoft SQL Server)
Recognize key factors that influence query performance in a integrated federated database environment
Use DB2’s Visual Explain and DB2 monitoring tools to expose federated database performance problems
Explain how to implement security to protect an integrated federated environment.

...''

Phone:1800 801 088

School Address:

IBM Australia Ltd
Level 13
IBM Centre
601 Pacific Highway
St Leonards NSW 2065.
Tel:1800 801 088

Jobs & Resumes: Sydney, Melbourne, PERTH, BRISBANE, CANBERRA CITY
Houses & Roommates: Sydney, Melbourne, PERTH, BRISBANE, CANBERRA CITY

DB2 UDB for z/OS Version 8 Transition (CG38AU)
DB2 UDB for z/OS System Performance Analysis (CG88AU)
IBM DB2 V8 for z/OS Functions (ITS406AU)
QMF/SQL for End Users (U4507AU)
DB2 Universal Database Advanced Programming (CF11BAU)
DB2 UDB Administration Workshop for Linux (CF20AU)
DB2 UDB Administration Workshop for UNIX (CF21AU)
DB2 UDB Administration Workshop for Windows (CF23AU)
DB2 UDB Multi Partitioned DBA Workshop (CF24AU)
DB2 UDB Peformance Tuning and Monitoring Workshop (CF41AU)
DB2 UDB Advanced Administraion for Experienced Relational DBAs (CF48AU)
DB2 Connect DRDA Implementation with TCP/IP (CF60AU)
DB2 UDB for Linux, UNIX, and Windows V8 Transition (CG08AU)
Generating and Integrating XML Content with DB2 (CG12BAU)
Implementing DB2 Everyplace in Your Enterprise (CG20AU)
DB2 UDB/WebSphere Performance Tuning and Operations (ITS413AU)
IBM DB2 Document Manager V8 Implementation and Administration (DM401AU)
IBM Content Manager V7 Advanced Topics (IM320AU)
Design Analysis for IBM DB2 Content Manager V8 (IM410AU)

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.