Microsoft SQL Server 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012 OEM Certkit
70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012 OEM Certkit
€349,00 €299,00
Microsoft SQL Server
Aanbieding

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

EUR 299,00
EUR 349,00 Excl. btw
  • Koop 2 voor €293,02 per stuk en bespaar 2%
  • Koop 3 voor €290,03 per stuk en bespaar 3%
  • Koop 5 voor €278,07 per stuk en bespaar 7%
  • Koop 10 voor €269,10 per stuk en bespaar 10%
  • Koop 25 voor €254,15 per stuk en bespaar 15%
  • Koop 50 voor €233,22 per stuk en bespaar 22%
  • Koop 100 voor €209,30 per stuk en bespaar 30%
  • Koop 200 voor €149,50 per stuk en bespaar 50%

Bestel online de customized E-Learning training Implementing a Data Warehouse with Microsoft SQL Server 2012 om u voor te bereiden op het 70-463 examen. Incl. Exam quizzes, Online mentor, MeasureUp sim. en Tips tricks.

  • E-Learning - Online toegang: 365 dagen
  • Taal: Engels (US)
  • Certificaat van deelname
Op voorraad
Bestel voor 16:00 uur en start vandaag.
Aantal
- +
  • Voor 23:00 uur besteld, morgen in huis
  • Certificaat van deelname
  • Bedrijven bestellen op factuur
  • Betaal in 3x geen extra kosten 0% rente en zonder BKR met in3
  • Meer informatie? Neem contact op over dit product
Productomschrijving

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

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).

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

Specificaties
Levertijd Binnen 1 werkdag
Online toegang 365 dagen
Lesduur 21 uur
Studiebelasting Variabel i.v.m. praktijkopdrachten.
Leermethoden Instructie video, Demonstratie video, Knowledge Base
Besturingssystemen Microsoft Windows, Google Chrome OS, Apple MacOS
Inbegrepen dienstverlening Voortgangsrapportage, 24/7 online toegang
Ondersteunde browsers Internet Explorer, Edge, Firefox, Safari en Chrome
MOS Examen Mogelijk voor bijbehorend examennummer
Toegang tot docent Per e-mail en chat
Extra Opties Virtual Labs (indien beschikbaar)
Wat onze klanten zeggen

average of 0 review(s)

Geen reviews gevonden
Help ons en andere klanten door het schrijven van een review
Mijn account
You are not logged in. Log in to make use of all the benefits. Or create an account now.
Taal
Winkelwagen
Uw winkelwagen is leeg
Menu
Zoeken
Search suggestions
Geen cursussen of trainingen gevonden...
Wij slaan cookies op om onze website te verbeteren. Is dat akkoord? Ja Nee Meer over cookies »