70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012 Ausbildung - OEM Certkit

Das Ausbildung 70-463 Implementieren eines Data Warehouse mit Microsoft SQL Server 2012 über ein spezielles Zertifizierungspaket. 1 Jahr Zugang zu revolutionärem E-Learning, um die Prüfung problemlos zu bestehen. Machen Sie sich mit dem Lernen über 1 Learning Portal (LMS) mit zertifizierten Lehrern vertraut. Exklusive Online-Mentoren rund um die Uhr und anspruchsvolle Kurstests und hinter den Kulissen Alle Tipps und Tricks anzeigen.
Garantiert immer die offizielle Testprüfung und eine offizielle Teilnahmebescheinigung nach dem Training. Optionale Livelabs (zusätzliche Kosten).

Kursinhalt

Designing and Implementing Dimensions

Course: 1 Hour, 10 Minutes

• Course Introduction
• The SQL Server Business Intelligence platform
• Changing Dimensions
• Dimension Tables and Attributes
• Hierarchies
• Schema Options
• Fact Tables
• Auditing and Lineage
• Keys
• Implement Dimensions
• Implement Data Lineage

Designing a Fact Table

Course: 1 Hour, 7 Minutes

• Course Introduction
• Slowly Changing Dimensions Transformation
• Implementing Transformations
• Processing Options
• Identity Mapping
• Deduplication
• Fuzzy Lookup
• Implementing a Fuzzy Lookup
• Erroneous Rows
• Auditing

Connection Managers and Data Sources

Course: 1 Hour, 15 Minutes

• Course Introduction
• Data Flow Components
• Using Data Flows
• Debugging Data Flow
• SQL/SSIS Transformations and Packages
• SSIS Lookups
• Data Sources and Destinations
• Extracting, Transforming, and Loading Data
• Performance Tuning, Optimization, and Integrity

Designing Data Flow

Course: 1 Hour, 5 Minutes

• Course Introduction
• Designing a Package Execution Strategy
• Scheduling Package Execution
• Implementing Package Execution
• Executing Packages Using SSMS
• Monitoring Execution Using Management Studio
• Using DTEXEC and DTEXECUI
• Executing Packages Using PowerShell
• ETL Restartability

Data Flow Implementation

Course: 1 Hour, 6 Minutes

• Course Introduction
• Control Flow
• Containers and Tasks
• Precedence Constraints
• SSIS Package Transaction Strategy
• Event Handlers, Variables, Parameters
• Connection Managers
• Custom Tasks
• Logging a Package

SSIS Package Execution and Script Tasks

Course: 1 Hour, 19 Minutes

• Course Introduction
• Checkpoints
• Debug Control Flow
• Implement Control Flow
• Data Profiling
• Sequence and Loop Containers
• Transactions in SSIS Packages
• Parallelism
• Controlling Task Execution Sequences
• Package Templates
• Execute Package Tasks

Designing Control Flow

Course: 1 Hour, 4 Minutes

• Course Introduction
• Designing a Package Execution Strategy
• Scheduling Package Execution
• Implementing Package Execution
• Executing Packages Using SSMS
• Monitoring Execution Using Management Studio
• Using DTEXEC and DTEXECUI
• Executing Packages Using PowerShell
• ETL Restartability

Implementing Control Flow

Course: 1 Hour, 12 Minutes

• Course Introduction
• User Variables
• Variable Scope
• Data Types
• Parameterization of Properties
• Precedence Constraints
• SSIS System Variables

SSIS Variables

Course: 39 Minutes

• Course Introduction
• Checkpoints
• Debug Control Flow
• Implement Control Flow
• Data Profiling
• Sequence and Loop Containers
• Transactions in SSIS Packages
• Parallelism
• Controlling Task Execution Sequences
• Package Templates
• Execute Package Tasks

SSIS Packages

Course: 1 Hour, 41 Minutes

• Course Introduction
• Designing SSIS Packages
• Package Configurations for Files
• Package Configurations for SQL tables
• Expressions
• Package and Project Parameters
• Project Level Connection Managers
• Expressions for Connection Managers
• Package Environments
• Package Configurations
• Package and Project Level Parameters
• Project Connection Managers
• Property Expressions

Data Load Options

Course: 1 Hour

• Data Loading
• Incremental Data Load Strategy
• Full Data Load Strategy
• Data Mart
• Data Mart: Incremental Updates
• Indexed Tables
• Bulk Load Options
• Load Technique: SSIS Destination
• Load Technique: T-SQL
• Load Partitioned Tables

Script Components

Course: 47 Minutes

• Course Introduction
• SCD Changes
• Script Components in SSIS
• Source Components
• Transformation Components
• Destination Components
• Web Service Source and Destination
  Error Messages

SSIS Components

Course: 1 Hour, 40 Minutes

• Course Introduction
• SSIS Components
• Preparing to Install Integration Services
• Integration Services Configuration Options
• Installing Integration Services
• SSIS Designer
• Development Box and Server
• Remote Package Execution
• 32 & 64-bit Installation
• Upgrading
• Provisioning Accounts
• Creating Catalogs
• Creating Object Identifiers
• Catalog Configuration

Auditing, Logging, and Event Handling

Course: 51 Minutes

• Course Introduction
• Auditing Using System Variables
• Propagating Events
• Log Providers
• Logging SSIS Execution
• Alerts and Notification Mechanisms
• Event Handlers
• Custom Logging

Troubleshooting Data Integration

Course: 1 Hour

• Course Introduction
• Performance Issues
• Connectivity Issues
• Troubleshooting Tasks
• Logic Issues
• SSIS Logging Infrastructure
• SSIS Package Failure
• Break Points
• Data Viewers
• Profiling Data

SSIS Solutions

Course: 50 Minutes

• Course Introduction
• The SSIS Catalog
• Backing Up and Restoring the SSIS Catalog
• Upgrading the SSIS Catalog
• Creating a Deployment Utility
• Deploy Packages by Using the Deployment Utility
• SSIS Packages: SQL or File System Locations
• Deploying Packages on Multiple Servers
• Validating Packages
• Installing Custom Components and Tasks
• DTUTIL

SSIS Security

Course: 1 Hour, 4 Minutes

• Course Introduction
• Database Roles
• Parameters and Package Deployment Model
• Parameters and Project Deployment Model
• Package Protection Levels
• Package and Project Protection Level Dialog Box
• Secure Deployments
• SSIS Packages Deployed at the File System
• Create Sensitive Parameters
• Set Parameter Values Post Deployment

Data Quality Services (DQS) and Master Data Services (MDS)

Course: 1 Hour, 15 Minutes

• Course Introduction
• Installation Prerequisites
• Installing Data Quality Services
• DQ Roles
• Identity Analysis

Data Quality Projects

Course: 50 Minutes

• Course Introduction
• Data Quality Knowledge Base Management
• Data Quality Client
• Data Quality Knowledge Base Domains
• Data Quality Projects
• Cleansing Data
• Deduplication
• History
• Managing Knowledge Base Domains

•TestPrep 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012TestPrep 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012