The main viewers for this examination are ETL and Details Factory Designers. They are most likely to focus on hands-on perform developing company intellect (BI) alternatives including data washing, Draw out Convert Fill (ETL), and Details Factory execution.
Their main obligations may include:
Mastering data using Expert Details Services
Cleansing data using Details Excellent Services
ETL Program development for data loading/transfer/transformation
Data Synchronization
One-time data or application migration
Ad-hoc data manipulations, transformations
Scheduling ETL jobs
Managing, setting up and Applying SQL Server Incorporation Solutions (SSIS) packages
Credit toward Certification
Exam 70-463: Applying a Details Factory with MS SQL Server 2012: number as credit score toward the following certifications:
MCSA: SL Server 2012
MCSE: Details Platform
MCSE: Business Intelligence
Skills Being Measured
This examination measures your ability to accomplish the technical projects listed below. The rates indicate the relative weight of each major subject place on the examination. The higher the percentage, the more questions you are likely to see on that content place on the examination.
1.Design and Apply a Details Factory (11%)
2.Extract and Convert Details (23%)
3.Load Details (27%)
4.Configure and Set up SSIS Solutions (24%)
5.Build Details Excellent Solutions (15%)
What You’ll Learn
In this course, you will understand how to apply information warehouse facilities to support information employee statistics using SQL Server 2012. You will discover how to create an information warehouse with SQL Server 2012, Apply extract, transform, and cargo (ETL) with SQL Server Incorporation Solutions, and confirm and cleanse data with SQL Server Details Excellent Solutions (DQS) and SQL Server Expert Details Solutions.
Data warehouse principles and structure considerations
Select an appropriate elements foundation for an information warehouse
Design and Apply an information warehouse
Apply Details Flow in a SQL Server Incorporation Solutions (SSIS) package
Debug and diagnose SSIS packages
Apply a SSIS solution that can handle small data warehouse plenty and changing data
Integrate reasoning data into a information warehouse environment infrastructure
Apply data washing using MS DQS
Apply Expert Details Methods to use data reliability at source
Extend SSIS with custom programs and components
Deploy and set up SSIS packages
How information workers can consume data from the details warehouse
Who Needs to Attend
Database experts who need to meet up with a BI programmer role focused on hands-on
Perform; developing BI alternatives included data warehouse execution, ETL, and data cleansing
Database experts responsible for an information warehouse, developing SSIS offers for data removal, running, switching, changing, and Applying data reliability using Expert Details Solutions, and washing data using DQS
Prerequisites
Knowledge of relational databases
Basic information of MS Windows systems and its primary functionality
Earning this MS Certified Solutions Affiliate (MCSA): SQL Server 2012 qualification verifies that you have the essential abilities needed to develop and maintain mission-critical MS SQL Server 2012 surroundings
MCSA: SQL Server 2012 qualification is your first step towards generating an MCSE: Details Platform qualification or an MCSE: Business Intelligence qualification.
