Microsoft 70-463 Implementing a Data Warehouse with SQL... (Udemy.com)

Implementing Data Warehouse with SQL Server 2012

( 0 Reviews )

Created by: Stone River eLearning

Produced in 2017

What you will 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 cleansing, Extract Transform Load (ETL), and Data Warehouse implementation.

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 0 / 100

Course 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 ServicesCleansing data using Data Quality ServicesETL Package development for data loading/transfer/transformationData SynchronizationOne-time data or application migrationAd-hoc data manipulations, transformationsScheduling ETL jobsManaging, 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 dimensionsDesigning and implementing fact tablesDefining connection managersDesigning and implementing data flowManaging SSIS package executionImplementing script tasks in SSISDesigning and implementing control flowImplementing package logic using SSIS variables and parametersImplementing data load optionsImplementing script components in SSISTroubleshooting data integration issuesInstalling and maintaining SSIS componentsImplementing auditing, logging, and event handlingDeploying SSIS solutionsConfiguring SSIS security settingsInstalling and maintaining Data Quality ServicesImplementing master data management solutionsCreating 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 CertificationETL and data warehouse developers

Time: 4.5h

Instructor Details

Stone River eLearning

0.0 Rating
0 Reviews

At Stone River eLearning, technology is all we teach. If you're interested in IT, programming, development or design - we have it covered.
Check out our huge catalog of courses and join the over 1,200,000+ students currently taking Stone River eLearning courses. We currently offer 800+different technology training courses on our Stone River eLearning website and are addingnew courses on hot and trending topics everymonth. A subscription option is available for those with a real passion for learning.