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

De Training 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012 via een Speciale Certificeringspakket. 1 Jaar toegang tot revolutionaire E-Learning om het examen Gemakkelijk te halen. Laat je Introduceren door te Leren via 1 Leerportaal (LMS) met Gecertificeerde Docenten. Exclusief 24/7 Online Mentor en Uitdagende Cursus Testen en Bekijk Achter de schermen alle Tips & Tricks.
Gegarandeerd altijd het Officieel Proefexamen en na de Training een Officieel Certificaat van Deelname. Optioneel Livelabs (meerprijs).

Door gebruik te maken van de datawarehousing-mogelijkheden van SQL Server 2014 kunnen bedrijven kleine tot grote hoeveelheden gegevens snel verwerken door ETL-oplossingen te gebruiken voor het extraheren, transformeren en laden van de gegevens voor analyse en rapportage. Om ETL-oplossingen te bouwen, biedt SQL Server 2014 de SQL Server Data Tools om SQL Server Integration Services-projecten te maken. Een project kan veel pakketten bevatten die besturingsstroomtaken en gegevensstroomcomponenten gebruiken om te specificeren hoe en waar de gegevens worden geladen, hoe deze worden getransformeerd en vervolgens waar ze worden geladen. Nadat de gegevens zijn geladen, kunnen rapporten over de gegevens worden gemaakt om zakelijke beslissingen te helpen nemen. Dit leertraject laat zien hoe u ETL-oplossingen kunt maken met behulp van SQL Server Integration-projecten en -pakketten, en hoe u deze efficiënt kunt uitvoeren. Dit pad behandelt de doelstellingen voor het Microsoft SQL Server 2014-examen 70-463: Een datawarehouse implementeren met Microsoft SQL Server 2012/2014. Dit examen is vereist voor de certificeringspaden MCSA: SQL Server 2014 en MCSE: Data Management and Analytics.

Cursusinhoud

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