08/22/2022 - 08/24/2022
10:00 AM - 06:00 PM
Online Virtual Class
USD $1,950.00
Enroll
09/06/2022 - 09/08/2022
10:00 AM - 06:00 PM
Online Virtual Class
USD $1,950.00
Enroll
09/26/2022 - 09/28/2022
10:00 AM - 06:00 PM
Online Virtual Class
USD $1,950.00
Enroll
Audience
 

IT practitioners who are responsible for data modeling, such as, database administrators and business analysts.

Prerequisites
 

It is expected that students have a clear idea about the SOA methodology and its benefits. If you are relatively new to SOA, WA1405 Introduction to SOA is highly recommended

Duration
 

3 days

Download Sample Labs Lab Setup Guide

Outline for SOA Data Modeling Training

Chapter 1. Getting Started with XML

  • Unstructured Text Document
  • An Employee Document
  • What is XML ?
  • Why Study XML?
  • Data and Document Structure
  • Elements
  • First XML
  • Another Example of XML
  • Well-formed vs. Valid XML Document
  • Presentation Style
  • Goals of XML
  • Usage of XML
  • Summary

Chapter 2. XML Syntax

  • XML Elements
  • Empty and Non-Empty Elements
  • XML Naming Rules
  • Rules for XML Tags
  • Nesting and Hierarchy of XML Elements
  • Simple XML
  • Sections of an XML Document
  • XML Constructs…
  • XML Declaration
  • Processing Instructions
  • Is the XML Declaration a Processing Instruction ?
  • XML Elements
  • Tag Attributes
  • Comment Tags
  • CDATA Tags
  • Entity References
  • Character References
  • Namespaces
  • Namespace URLS
  • Namespaces
  • Using XML Namespaces
  • Working with Binary Data
  • Encoding Binary Data
  • Specifying Content Type of Binary Data
  • Summary

Chapter 3. Basic XML Schemas

  • What is XML Schema ?
  • Goals of Schema
  • Converting DTDs to Schema
  • Recall: Namespaces
  • The equivalent schema
  • Sample instance document
  • Documents Needed
  • XML Schema Namespaces
  • Link Documents to Schemas
  • Inline element declarations
  • Schema Data Types
  • Schema Type Definitions
  • Schema Simple Data Types
  • Primitive Data Types
  • Simple Types
  • Facet – Restrictions on Element Content
  • Using the Facet
  • More Samples
  • Define Simple Element Type
  • Element Declaration
  • Element Occurrence Indicators
  • Complex Type
  • Attribute Declaration
  • Attribute Declarations
  • Occurrence of Attributes
  • Value Constraints on Attributes
  • Sequence Element
  • Element Choices
  • Express any order
  • Annotations

Chapter 4. XPath Fundamentals

  • Xpath
  • Tree Structure
  • Example
  • XPath Examples
  • XPath Core Definitions
  • Wildcards and Multiple Matches
  • Other Node Operators
  • Path Operators
  • Predicates
  • Predicate Relationships and Attributes
  • More Predicate Examples
  • Predicates Chaining and Indexing
  • XPath Expressions
  • XPath Numbers
  • XPath Strings
  • XPath Booleans
  • XPath Functions
  • String Functions
  • Boolean Functions
  • Number Functions
  • XSLT and XPath
  • XPath and Content Based Routing
  • Summary

Chapter 5. Introduction to XQuery

  • What Is XQuery?
  • XQuery Uses
  • XQuery Properties
  • XPath and XSLT
  • XQuery Flow
  • XQuery Participants
  • Sample XQuery Source
  • Simple Example Queries
  • FLWOR Queries
  • F-WOR Explained
  • L Explained
  • Wrapping Output
  • Converting Output
  • Inline Output
  • Data Rendering
  • Functions
  • Joins
  • Join Example
  • Summary

Chapter 6. Introduction to XSL

  • Formatting XML Documents
  • XSL
  • Three Parts of XSL
  • XSLT – XSL Transformation
  • <xsl:stylesheet>
  • <?xml-stylesheet>
  • <xsl:template>
  • <xsl:template>
  • <xsl:value-of>
  • Navigating with XPath
  • Navigating With XPath
  • <xsl:for-each>
  • <xsl:if>
  • XPath Boolean expressions
  • XPath Boolean Expressions
  • <xsl:choose>
  • <xsl:apply-templates>
  • <xsl:sort>
  • The Music Collection Example – Introduction
  • The Music Collection Example – Sample XML file
  • The Music Collection Example – Retrieving owner details
  • The Music Collection Example – Retrieving the core data
  • The Music Collection Example – Current Output
  • The Music Collection Example – Retrieving canadianContent data
  • The Music Collection Example – Current Output
  • The Music Collection Example – Retrieving media data
  • The Music Collection Example – Final Output
  • Formatting XML Documents

Chapter 7. XML in Applications

  • Topics
  • Needs for Using XML in Applications
  • Basic Functionalities Required for XML Applications
  • XML Parser
  • Obtaining a Parser
  • SAX
  • How it Works
  • DOM
  • DOM Parsing
  • Applying XML Across System Boundaries
  • Using XML on the Client Side
  • Using XML on the Server Side
  • Using XML in Non-Networked Systems
  • Using XML in RDBMS
  • The J2EE Blueprint
  • A Typical Architecture Using XML in J2EE Applications
  • Using XML in Applets
  • Using XML Parser in Applets
  • Using XML in Servlets
  • Creating XML Middleware for Accessing Databases
  • Transforming RDBMS Data to XML Data
  • Transforming XML Data to RDBMS Data
  • Storing XML Data in DB2

Chapter 8. Web services Description Language (WSDL)

  • WSDL Overview
  • WSDL Document Tags
  • WSDL Namespaces
  • <definitions>
  • <import>
  • <types>
  • <message>
  • <portType>
  • <operation>
  • One-way <operation>
  • Request-Response <operation>
  • Solicit-Response <operation>
  • Notification <operation>
  • Modeling Simple Operation
  • Modeling Complex Operation
  • Modeling Complex Message
  • <binding>
  • More on <binding>
  • <binding> Syntax
  • SOAP Binding Example
  • <service> and <port>
  • More on <port>
  • WSDL SOAP Binding Extensions
  • soap:binding
  • soap:operation
  • RPC or Document Style?
  • WSDL API for Java
  • Summary

Chapter 9. Information Management in SOA

  • Introduction
  • SOA and Enterprise Information Management
  • Replication Overview
  • Operational Challenges
  • SOA and Data Basics
  • Intro: Operational Data
  • Data Publishing Event
  • Modeling Events
  • Data Mediation
  • Data Format
  • Generic Data Model
  • Example Generic Data Model
  • Mapping Data
  • Loading Data
  • Extract Transform Load (ETL)
  • ETL and SOA
  • Data Federation
  • SOA Data Layering
  • Data Federation vs ETL
  • Summary

Chapter 10. Introduction to Service Oriented Analysis & Design (SOAD)

  • Introduction to SOAD
  • Applying OOAD Principles
  • Encapsulation
  • Encapsulation in SOAD
  • Inheritance
  • Inheritance in SOAD
  • Polymorphism
  • Polymorphism in SOAD
  • Why OOAD Is Not Enough
  • Granularity
  • The Need for Loose Coupling
  • The SOAD Methodology
  • The SOAD Methodology Steps
  • Stage 1: Requirements Gathering & Process or Message Flow Modeling
  • Stage 1: Requirements Gathering & Process Modeling
  • Stage 2: Service Identification
  • Stage 3: Service Implementation
  • Stage 4: Process Implementation
  • SOAD Stages and SOA Lifecycle
  • Summary

Chapter 11. Data Modeling in SOA

  • Data Modeling in SOA
  • Data Models in SOA
  • The Physical Data Model
  • Deriving the Physical Data Model
  • Scenario 1: New Software System
  • Scenario 2: Legacy Data Model
  • Strategy #1: Adapter-based service example
  • Strategy #1: Another adapter example
  • Strategy #2: Wrapper Web service
  • Scenario 3: Meet-in-the-middle
  • The role of XML in SOA data modeling
  • Converting Relational to XML data
  • Storing XML data in a RDBMS
  • Approaches to storing XML data in a RDBMS
  • Storing the entire XML document
  • Shredding the XML document
  • Using a native XML data type
  • SQL extensions for native XML support
  • The Logical Data Model
  • Benefits of the Logical data model
  • Deriving a Logical Data model from the Physical
  • Designing the Logical Data Model
  • The Enterprise Architecture approach
  • EA Approach – example
  • Aligning your logical and physical models
  • How to align your logical and physical models
  • The SOAD approach
  • The Logical Data Model in Business Process Modeling
  • Business Process state variables
  • Input and the Receive activity
  • Output and the Reply activity
  • The Invoke activity
  • The Assign activity
  • Why do you need a published data model?
  • Industry-standard XML-based data models
  • Review questions
  • Summary

Chapter 12. The Data Mapping Layer

  • Why do you need data transformation in SOA?
  • Interface mapping in SOA
  • Business processes and data mapping
  • How are Data Maps used?
  • How are Data Maps created?
  • XML-to-XML data mapping
  • XML-to-Any data mapping
  • Mapping techniques
  • Copy
  • Splitting
  • Aggregation
  • Enrichment
  • Filtering
  • Computed
  • Testing data maps
  • Review questions
  • Summary

Chapter 13. Master Data Management (MDM)

  • What is Master Data Management?
  • A typical data management scenario
  • Why do you need MDM? (1 of 2)
  • Why do you need MDM? (2 of 2)
  • Why do you need MDM in SOA? (1 of 2)
  • Why do you need MDM in SOA? (2 of 2)
  • What role does MDM play in SOA?
  • MDM and SOA shared principles
  • MDM and SOA Governance
  • MDM products
  • Implementing MDM in an SOA (1 of 3)
  • Implementing MDM in an SOA (2 of 3)
  • Implementing MDM in an SOA (3 of 3)
  • Review questions
  • Summary

Chapter 14. Industry Standard Data Models

  • What are industry data models?
  • Why are these models important in SOA?
  • ACORD – Introduction
  • ACORD – Insurance data models
  • ACORD, IBM and SOA
  • The future of ACORD and SOA
  • HL7 - Healthcare
  • The HL7 data model
  • SID - Telecom
  • ARTS - Retail
  • Review questions
  • Summary

Chapter 15. Schema Configuration Management

  • Evolving Schema
  • Managing XML Schema
  • Management Techniques
  • Internal Techniques
  • Schema Version Attribute
  • Adding An Attribute
  • Namespace Change
  • File-Based Mechanisms
  • External
  • Which To Use?
  • Summary

Chapter 16. Data Model Governance

  • What is data governance?
  • Roles and Responsibilities
  • What is metadata?
  • SOA metadata repository
  • SOA registry as a governance tool
  • Review questions
  • Summary

Chapter 17. Data Modeling Patterns and Best Practices

  • Pattern template
  • Data Federation pattern – Synopsis
  • Data Federation pattern – Benefits
  • Data Federation pattern – Context
  • Data Federation pattern – Solution
  • Data Federation pattern – Solution architecture
  • Data Federation pattern – Considerations
  • Data Federation pattern – Summary
  • Data Consolidation pattern – Synopsis
  • Data Consolidation pattern – Benefits
  • Data Consolidation pattern – Context
  • Data Consolidation pattern – Solution
  • Data Consolidation pattern – Considerations
  • Data Consolidation pattern – Summary
  • Data Cleansing pattern – Synopsis
  • Data Cleansing pattern – Benefits
  • Data Cleansing pattern – Context
  • Data Cleansing pattern – Solution
  • Data Cleansing pattern – Considerations
  • Data Cleansing pattern – Summary
  • Data Management systems primer
  • MDM patterns – Synopsis
  • MDM patterns – Benefits
  • MDM pattern taxonomy
  • MDM pattern catalogue
  • Transaction Interception pattern
  • Transaction Interception pattern flow
  • MDM Pub/Sub pattern
  • Message-based Integration pattern
  • Master Data Integration pattern
  • Information synchronization pattern (1 of 2)
  • Information synchronization pattern (2 of 2)
  • BI Analytical pattern
  • Review questions
  • Summary