banner

Stone River Elearning – Microsoft 70-463 Implementing a Data Warehouse with SQL

img
img

This course is specifically for participants to measure their knowledge and skills on making the appropriate job…

File Size: 1.1 GB.

Stone River Elearning – Microsoft 70-463 Implementing a Data Warehouse with SQL

Stone River Elearning - Microsoft 70-463 Implementing a Data Warehouse with SQL

What you’ll learn

  • This course will prepare you to pass the exam Microsoft 70-463: Implementing Data Warehouse with SQL Server 2012.
  • This course is designed for ETL and Data Warehouse developers who most likely focus on hands-on work creating business intelligence (BI) solutions, including data…

Requirements

  • Basic understanding of SQL server
  • Interest in Business Intelligence (BI) solutions

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.

This course is designed for ETL and Data Warehouse Developers who most likely focus on hands-on work creating business intelligence (BI) solutions, including data cleansing, Extract Transform Load (ETL), and Data Warehouse implementation. Primary responsibilities may include:

  • 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

This training course on implementing a Data Warehouse with Microsoft SQL Server 2012 prepares participants for the Microsoft Exam 70-463.

This course will provide all the skills and knowledge for the following areas:

  • 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

We create the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed.

Who this course is for:

  • IT Professionals who wish to gain Microsoft Certification
  • ETL and data warehouse developers

There are no reviews yet.

Add a Review
Original price was: $299.00.Current price is: $39.00.

This course is specifically for participants to measure their knowledge and skills on making the appropriate job... File Size: 1.1 GB.

Purchase this product now and earn 39 Points!
10 Points = $1