stone_river

Microsoft 70-463 Implementing a Data Warehouse with SQL


  • flag Stone_River
  • student All Levels
  • database eLearning
  • earth English
  • clock 100

Covered topics:

  • Mastering data using Master Data Services
  • Cleansing data using Data Quality Services
  • ETL Package development for data loading/transfer/transformation
  • Data Synchronization
  • One-time data or application migration
  • Ad-hoc data manipulations^ transformations
  • Scheduling ETL jobs
  • Managing^ configuring and deploying SQL Server Integration Services (SSIS) packages
  • Designing and implementing dimensions
  • Designing and implementing fact tables
  • Defining connection managers
  • Designing and implementing data flow
  • Managing SSIS package execution
  • Implementing script tasks in SSIS
  • Designing and implementing control flow
  • Implementing package logic using SSIS variables and parameters
  • Implementing data load options
  • Implementing script components in SSIS
  • Troubleshooting data integration issues
  • Installing and maintaining SSIS components
  • Implementing auditing^ logging^ and event handling
  • Deploying SSIS solutions
  • Configuring SSIS security settings
  • Installing and maintaining Data Quality Services
  • Implementing master data management solutions
  • Creating a data quality project to clean data

Description

This course is specifically for participants to measure their knowledge and skills on making the appropriate job role decisions around implementing a Data Warehouse with Microsoft SQL Server 2012.