About Trainer

  • 9 years of IT experience
  • Working in IDA from 4 years
  • Working as a Project Lead
  • Excellent in Communication

About Infosphere Data Architect

 
 
 
 
ONLINE TRAINING IN IBM INFOSPHERE DATA ARCHITECT
To DISCOVER, MODEL, RELATED AND
STANDARDIZE DIVERSE AND STANDARD DATA

Course Pre-requisites:

  • Database modeling knowledge
  • SQL Fundamentals
  • DBA experience in any OLTP/OLAP environments is an added advantage

Lab setup:

  • Install IDA 7.5.3 and above
  • Install Any relational DB (oracle, DB2, etc)

Training Material:

  • Class PPT’s (Soft copy)
  • Class recordings (Optional)
  • Interview Questions

IBM INFOSPHERE DATA ARCHITECT ONLINE TRAINING Course Outline
  • Introduction to IBM InfoSphere Data Architect
  • Data Modeling Overview
  • Logical Data Modeling
  • Creating databases and data placement
  • Domain Models
  • Physical Data Modeling
  • Generating Reports, Importing, and Exporting
  • Model Mapping and Discovery
  • Analyzing Data Models
  • The Data Management Life Cycle
Contents

OVERVIEW AND SETUP
Unit 1: Introduction to IBM InfoSphere Data Architect (1 hour)

  • What is IBM InfoSphere Data Architect?
  • Installing Configuring IDA with various RDBMS
  • Workbench, Data perspective and its views
  • Manipulating views

Unit 2: Data Modeling Overview (1 hour)

  • The data model design life cycle
  • Organizing the data model
  • Creating the student information management system

MODELING YOUR DATA
Unit 3: Logical Data Modeling (2 hours)

  • Logical data modeling: The big picture
  • Creating a logical data model
  • Creating a logical data model with the workbench
  • Creating entities with the diagram
  • Adding relationships
  • Working with glossary models
  • Best practices for naming standards and glossary models
  • Working with naming standards
  • Analyzing to check compliance with naming standards
  • Constraints
  • Exercise 1: Create logical and glossary models.

Unit 4: Domain Models(1 hours)

  • Creating a blank domain model
  • Atomic domains
  • List domains and union domains
  • Associating domain model elements with logical data model elements.
  • Exercise 2: Creating domain models

Unit 5: Physical Data Modeling (2 hours)

  • Physical data modeling: The big picture
  • Creating a physical data model from scratch
  • Transforming a logical data model to a physical data model
  • Working on your physical data model
  • Anatomy of your model
  • Storage modeling in DB2
  • Refining the physical data model
  • Rearranging columns in a physical data model
  • Creating roles within the physical data model
  • Adding a user ID to the physical data model
  • Validating the physical data model
  • Generating the DDL script from the database object
  • Exercise 3: Creation of PDM and explore storage model

ITERATIVE DESIGN: REPORTING, REVISING, AND ANALYZING
Unit 6: Generating Reports, Importing, and Exporting (3 hours)

  • Reporting, importing, and exporting: The big picture
  • An insight into reporting
  • Generating a BIRT report
  • Generating a basic physical data model report
  • Setting up the reporting environment
  • Adding data objects to a report
  • Grouping data in a report
  • Adding dynamic text to a report
  • Generating a report configuration from a template
  • Generating XSLT reports
  • Importing and exporting with IBM InfoSphere Data Architect
  • Exporting with the workbench
  • Importing a data model with the workbench
  • Exercise 4: Generating various reports

Unit 7: Reverse-Engineering (2 hours)

  • Reverse-engineering: The big picture
  • Reverse-engineering with the workbench
  • Reverse-engineering from DDL
  • Reverse-engineering from a database
  • Making changes to the new physical data model
  • Compare and merge your changes
  • Comparing and merging changes with the database
  • Advantages of the compare and merge functions
  • Exercise 5: reverse-engineer a model and explore all the functions

Unit 8: Model Mapping and Discovery (3 hours)

  • Mapping models: The big picture
  • Managing metadata with mapping models
  • Further managing naming standards with mapping models
  • Building mappings within the workbench
  • Creating a blank mapping model
  • Adding mappings to mapping model
  • Types of mapping
  • Adding expressions and filters to the mapping model
  • Generate scripts that you can deploy
  • Export mapping models in CSV format
  • Exercise 6: Map different model and create filters

Unit 9: Analyzing Data Models (2 hours)

  • Analyzing data models: The big picture
  • Analyzing data models with the workbench
  • Analyzing logical data models with the workbench
  • Analyzing physical data models with the workbench
  • Fixing errors and warnings in the Problems view
  • Modifying the preferences for model analysis
  • o Exercise 7: Analyze your data model in workbench

Unit 10: The Data Management Life Cycle (3 hour)

  • Managing your data
  • The data management life cycle
  • Integrating IBM InfoSphere Data Architect with other products
  • Shell-sharing with other Eclipse-based products
  • Exercise 8: Shell share IDA with different product

 
 
 
 

Testimonials

  • The fact that they have a set format of teaching, which creates a schedule for a student, and a step-by-step process that covers the entire Netezza syllabus. I can surely assure eTraining provides a great help for Netezza curriculum.
    - Shannon D.

  • The BEST I liked about the tutors in eTraining is the amount of practical knowledge these guys have and the way they bring in the same to students perspective while Teaching. Glad I took DB2 course from eTraining.
    - Rubeena Khan

  • I found classes very helpful. What you Teach is AWESOME
    - Gopal

Related Courses