Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > SOA for Architects > SOA Data Modeling Training

SOA Data Modeling Training

Quick Enroll

Course#: WA1605

This course is designed for the data modelers who are considering using SOA as the next generation methodology for Enterprise Application Integration. Data modeling plays a key role in SOA where the chief concern is data integration between applications. Traditionally data modeling has been limited to Relational Database Management Systems (RDBMS). This course will help you extend your existing RDBMS modeling knowledge to the SOA world.

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

Outline of WA1605 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

 

Address Start Date End Date
Instructor Led Virtual 09/18/2017 09/20/2017
Instructor Led Virtual 10/23/2017 10/25/2017
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

09/18/2017 - Online Virtual
$1,950.00
Enroll

10/23/2017 - Online Virtual
$1,950.00
Enroll

Other Details

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.