This SQL Server 2012 Training Kit is designed for information technology (IT) professionals who support or plan to guide data warehouses, extract transform load (ETL) processes, data quality improvements, and master data management. It is designed for IT professionals who also want to take the Microsoft Certified Technology Specialist (MCTS) exam 70-463. The authors think that you have a good, foundation-level understanding of Microsoft SQL Server 2012 and the Transact-SQL language and that you understand basic relational modelling concepts.
Sql Server 2012 Training Kit Covers
The material covered in this SQL Server 2012 Training Kit and on Exam 70-463 pertains to the technologies given by SQL Server 2012 for implementing and maintaining a data warehouse. The topics in this Training Kit cover what you need to learn for the exam as described on the Skills Measured tab for the exam 70-463. By studying this Training Kit, you will see how to execute the following tasks:
Design a suitable data model for a data warehouse
Optimize the physical design of a data warehouse
Extract data from different data sources, transform and cleanse the information, and load it in important computer data warehouse by using SQL Server Integration Services (SSIS)
Use advanced SSIS components
Use SQL Server 2012 Master Data Services (MDS) to assume control of your master data
Use SQL Server Data Quality Services (DQS) for data cleansing
Make reference to the objective mapping page in leading with this book to see where in the book each exam objective is covered.