Description
At Sixe Engineering we have been providing official IBM training around the world for over 12 years. Get the best training from our specialists in Europe. We have important discounts and offers for two or more students.
Course details
| IBM course code: CE822G | Category: IBM Infosphere / Data Explorer |
| Delivery: Online & on-site** | Course length in days: 2 |
Target audience
This intermediate course is for data modelers, physical database designers, application analysts, database administrators, and other personnel who need to perform logical and physical modeling and associated functions as provided by InfoSphere Data Architect.
Desired Prerequisites:
You should have:
- Basic skills in logical data modeling.
- Knowledge of general RDBMS terminology
Instructors
The great majority of the IBM courses we offer are taught directly by our engineers. This is the only way we can guarantee the highest quality. We complement all the training with our own materials and laboratories, based on our experience during the deployments, migrations and courses that we have carried out during all these years.
Added value
Our courses are deeply role oriented. To give an example, the needs for technology mastery are different for developer teams and for the people in charge of deploying and managing the underlying infrastructure. The level of previous experience is also important and we take it very seriously. That is why beyond (boring) commands and tasks, we focus on solving the problems that arise in the day to day of each team. Providing them with the knowledge, competencies and skills required for each project. In addition, our documentation is based on the latest version of each product.
Agenda and course syllabus
InfoSphere Data Architect Introduction
- Describe the basic architectural elements of the Eclipse Graphical User Interface (GUI)
- Explain the InfoSphere Data Architect Views and their contents
- Relate the functions of the Search tool
Logical Data Modeling
- Relate the concepts of a logical data model and notation techniques for its diagram
- Explain how a logical data model is represented in the various InfoSphere Data Architect Views in the Eclipse Graphical User Interface (GUI)
- Describe the InfoSphere Data Architect functions to create a project, a logical data model in the project, and the logical data model elements
- State the purpose and usage of a Glossary Model and a Domain Model
Web Publishing and BIRT Reporting
- Use Web Publishing interface as a means of publishing your logical or physical model in HTML or PDF format.
- Explain the level of details of the report, so as to be able to use the report as means of documentation as well as means of collaborating with your project team.
Physical Data Modeling and Transformations
- Discuss the various ways to create a physical data model
- Explain how to create a physical data model from an existing logical data model
- Describe the capabilities of InfoSphere Data Architect to perform DB2 for zSeries storage modeling for the physical data model
- Relate the usage of the InfoSphere Data Architect model analysis facility
- List the steps to generate DDL to deploy the completed physical data model
- State the InfoSphere Data Architect process to reverse engineer an existing physical database to a physical data model
- Describe the functions available with the InfoSphere Data Architect Data Source Explorer View
Database Lifecycle Management
- List the major activities for lifecycle management of the database and associated models
- Describe how to setup and use InfoSphere Data Architect Team Support with Eclipse CVS or with ClearCase Remote Client
- Explain how to use the InfoSphere Data Architect Compare and Synch features to manage concurrency and accuracy of data models
- Relate the reasons for an impact analysis and the steps to perform an impact analysis
- State the basic data model transformation functions
Validation and Dependency Analysis
- Describe how to invoke the analysis of a data model
- Explain and evaluate the results of a model analysis
- Describe how to invoke the impact analysis function
- Explain and evaluate the results of an impact analysis
Mapping Models and Data Integration
- Explain what mapping models are used for
- Create a new mapping model
- Configure mappings
- Configure mapping groups
- Generate scripts based on mapping models
- Discuss how InfoSphere Data Architect can integrate with InfoSphere Metadata Server
Agenda
Day 1
- Welcome
- Unit 1 – RDA Introduction
- Exercise 1
- Unit 2 – Logical Data Modeling
- Exercise 2
- Unit 3 – Web Publishing and BIRT Reporting
- Exercise 3
Day 2
- Unit 4 – Physical Data Modeling and Transformations
- Exercise 4
- Unit 5 – Database Lifecycle Management
- Unit 6 – Validation and Dependency Analysis
- Exercise 5
- Unit 7 – Mapping Models and Data Integration
- Exercise 5
Do you need to adapt this syllabus to your needs? Are you interested in other courses? Ask us without obligation.
Locations for on-site delivery
- Austria: Vienna
- Belgium: Brussels, Ghent
- Denmark: Cophenhagen
- Estonia: Tallinn
- Finland: Helsinki
- France: Paris, Marseille, Lyon
- Germany: Berlin, Munich, Cologne, Hamburg
- Greece: Athens, Thessaloniki
- Italy: Rome
- Louxemburg: Louxembourg (city)
- Netherlands: Amsterdam
- Norway: Oslo
- Portugal: Lisbon, Braga, Porto, Coimbra
- Slovakia: Bratislava
- Slovenia: Bratislava
- Spain: Madrid, Sevilla, Valencia, Barcelona, Bilbao, Málaga
- Sweden: Stockholm
- Turkey: Ankara
- United Kingdom: London
