Master Data Services with SQL 2008 R2
Corso
A Milano
![Digi Academy](https://www.emagister.it/assets/it/logos/centro/id/54139/size/l.png)
Hai bisogno di un coach per la formazione?
Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.
Descrizione
-
Tipologia
Corso
-
Luogo
Milano
-
Inizio
Scegli data
What is Master Data Management? The Need for Master Data Management Data Quality Operational and Analytical Master Data Management Master Data Management Architectural Patterns Master Data Management Team
Sedi e date
Luogo
Inizio del corso
Inizio del corso
Opinioni
Materie
- Web master
- Security
- Management
- SQL
- E-business
Programma
What you will get out of this module:
An overview of the Master data Management
An understanding of challenges
The benefits of implementing a solution
An examination of the various competing architectures.
Guidelines on the team roles
In this module you will gain the knowledge that is key to working within MDS. A clear understanding of the terms such as Entity, Member and Attribute etc. and how they relate to each other will allow you to develop a MDS system.
Master Data Services Architecture
Master Data Services Key Terms
Master Data Services Web Interface
Master Data Services SQL Data Base
Installing Master Data Services
Creating the Master Data Services Database
Initial Configuration
Installation of Master Data Services
Configuration of Master Data Services
Create the MDS Web
Explore the Web Interface
What you will get out of this module:
An appreciation of the Architecture
An understanding of the key terms
The relationships between the objects
The installation requirements
Familiarization of the MDS Web Interface
The Model of the data is the key to success. In this module you will learn to design your data model then how to implement that design.
Modeling Concepts
Modeling Guidelines
Building a Model
Deploying a Model
How to Step by Step
Develop a Model using MDS
What you will get out of this module:
Working knowledge of Data Models
Model Development Guidelines
Model Development Major Steps
Implementation of a Module
In this module we will review the considerations for loading data into the models. We will examine the staging tables and stored procedures that may be utilized for loading data.
MDS Staging Tables
Creating New Members
Creating New Collections
Adding Members to Collections
Updating Member Attributes
Importing the Data
Validating the Model
Error Conditions
View the Staging Tables
Importing Data with SQL Server Integration Services
Run the Staging Process
Using a Stored Procedure to Initiate the Staging Process
Viewing Errors
What you will get out of this module:
How to manually load data into modules
How to created new Members and attributes with SQL
Loading data via the staging databases
An understanding of the functionality of the staging tables
The error conditions that may occur
Understanding Versions
Version Statuses
Version Validation
Version Flags
Ancestry
Validating Versions
Locking, Unlocking and Committing Versions
Create a Version
Work with Version Flags
Validate a Version
View a Version Ancestry
Lock, Unlock and Commit a Version
What you will get out of this module:
The need for Versions
Knowledge of a Version Status
How to use a Version Flag
Viewing A Version’s Ancestry
How to Lock, Unlock and Commit a Version
Business Rules Overview
How to Create A Business Rule
Business Rules Interface
Rule Expressions
Conditions and Actions
Using SharePoint Workflows
Create several Business Rules
Use Visual Studio to create a workflow called by the Business Rules
What you will get out of this module:
Understanding of Business Rules
How to code a Business Rule
Work with the Web Interface
How to create an Expression
Integrate SharePoint into the path of the workflow
Invoking complicated workflows through the use of SharePoint
Master Data Services Security Overview
Users and Groups
Administrators
Permission Levels
Best Practices
Implement Security
Test Security
What you will get out of this module:
This module will demonstrate the security of Master Data Services
Subscribing Systems
Subscription Views
Formats
Creating Views
How Subscribing Systems can Extract Data
Create a Subscription View
Subscribe to the View
What you will get out of this module:
How to use Publish Data
How to Create a Subscription View
An understanding of Formats
How a subscribing system can extract data.
Using Web Services to Interface with Master Data Services
Creating the Web Service
Errors in the Web Service
Create a Web Service Project in Visual Studio
Perform Several Operations with the Web Service
What you will get out of this module:
How to use Web Services to Interface with Master Data Services
Hai bisogno di un coach per la formazione?
Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.
Master Data Services with SQL 2008 R2