Overview
| Course code | 1I900 | Skill level | Basic |
|---|---|---|---|
| Duration | 24.0 hours | Delivery type | Web Based Training |
| Course type | Public only | ||
| Public price | USD $1,020.00 plus tax |
This course is developed for Federation Server Version 9.5. Learn Federation concepts and describes how to configure a federated database for accessing relational and non-relational data sources. Configuration involves defining wrappers, servers, and nicknames for linking to remote data sources. This course discusses access to both relational and non-relational data sources.
Please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access the course.
Learn Federation concepts and how to configure a federated database for accessing relational and non-relational data sources. Configuration involves defining wrappers, servers, and nicknames for linking to remote data sources. This is a self-paced online course. You will receive detailed access instructions in an email confirming your registration. Once you receive your access information, you will have 60 days to complete this course.
The self-paced format gives you the opportunity to complete the course at your convenience, at any location, and at your own pace. The course is available 24 hours a day. Once you have accessed the course, instructor help is available via the course forum Monday through Friday; questions will be responded to within 24 hours.
Audience
This basic course is developed for Federation Server Version 9.5. Learn Federation concepts and describes how to configure a federated database for accessing relational and non-relational data sources. Configuration involves defining wrappers, servers, and nicknames for linking to remote data sources. This course discusses access to both relational and non-relational data sources.
Prerequisites
You should have:
- Basic knowledge of relational database administration for an RDBMS such as DB2, Oracle, or SQL Server
- Knowledge of SQL
- Knowledge of how relational databases are used within a business
Skills taught
- Describe the uses of federation technology
- Use the DB2 Control Center to define wrappers, servers, user mappings, and nicknames
- Recognize key factors that influence query performance
- Explain key concepts of SQL support including compensation, passThru, and datatype and functional mappings
- Explain the major security issues for protecting the federated environment
Course outline
- What is Federation
- How it works
- Usage scenarios
- Architecture
- Wrapper
- Server
- Nicknames
- User mappings
- Security issues
- Relational data source access
- SQL support
- Compensation
- PassThru
- Datatype, function mappings
- Non-relational data source access
- Performance and optimization
Machine requirements
HW/SW CONFIGURATION
The minimum hardware and software required to launch the course are:
- Reliable HIGH-SPEED INTERNET connection (min 200 kbps up and down)
- Windows 2000 or XP or Vista
- Computer with soundcard
- Headset or computer speakers
- Internet Explorer 5.01 or later, or Firefox 1.0 or later
Network Speed Test
http://clpext.moppssc.com/index.php?option=com_wrapper&view=wrapper&Itemid=8
User: clp
Pass: ibmeduc
For example, a speed test against the server with a slow connection of 140 Kbps download and 28 Kbps upload took 14 minutes to load a 30min recording before the video began. Extrapolate from this result to estimate approximately how fast your network internet access would be. High-speed broadband internet access is the recommended configuration for this course.
Keyboard Configuration
If you use a different character keyboard, you may experience errors when entering passwords. If possible, change your language/country settings for your keyboard to USA, which allows you to enter characters as in a QWERTY keyboard.