Wir benutzen Cookies nur für interne Zwecke um den Webshop zu verbessern. Ist das in Ordnung? Ja Nein Für weitere Informationen beachten Sie bitte unsere Datenschutzerklärung. »
Artikelnummer: 118507518

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

Artikelnummer: 118507518

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

311,89 371,15 Inkl. MwSt.

70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012 E-Learning Zertifizierte Lehrer Prüfungsquizze Online Mentor MeasureUp Test Exam Live Labs Tipps Tricks Zertifikat.

Lesen Sie mehr
Verfügbarkeit:
Auf Lager
Schulungsangebot: IKT-Schulung , Microsoft SQL Server
  • Award Winning E-learning
  • Tiefpreisgarantie
  • Persönlicher Service durch unser Expertenteam
  • Sicher online oder per Rechnung bezahlen
  • Bestellung und Start innerhalb von 24 Stunden

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

Unterrichtsdauer 20:05 Stunde
Sprache Englisch
Online-Zugang 365 Tage
Teilnahmeurkunde Ja
Preisgekröntes Online-Training Ja

Es wurden noch keine Bewertungen für dieses Produkt abgegeben.

Bewertungen

Es wurden noch keine Bewertungen für dieses Produkt abgegeben.

Microsoft Office SCORM e-Learning

Möchten Sie Microsoft Office E-Learning SCORM in das LMS Ihrer Organisation integrieren? Nehmen Sie Kontakt mit uns auf.

Bewertung der Schüler

Springest: 8.9, Edubookers: 8.5

Qualitätsgarantie

Preisgekröntes E-Learning & zertifizierte Tutoren

Microsoft Partner

und Certiport Partner

Nicht Gut, Geld Zurück

und eine Starter-Garantie