Implementing a Data Warehouse with Microsoft SQL Server 2012 Discussion Forum
Implementing a Data Warehouse with Microsoft SQL Server 2012 Exam Prep Wiki
Are you a SQL Server professional looking for data warehouse training that will expand your understanding of SQL Server 2012 data warehousing concepts and implementation? Or maybe you are continuing your SQL Server SSIS training to preparing for Exam 70-463, a key component of the MCSA: SQL Server certification. Take this Jump Start course that focuses on the design of dimensions to support business intelligence (BI) in the organization, the implementation of extract, transform, and load (ETL) processes, and the implementation of enterprise-level master data and data quality. Watch the SQL Server videos for live demos to that can help you learn about building dimension tables in a data warehouse, implementing an ETL process with control flow and data flow definitions, configuring logging and event handling, deploying an ETL solution, and implementing master data and data quality solutions.
This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft® SQL Server® 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
Ace your preparation for Microsoft Certification Exam 70-463 with this 2-in-1 Training Kit from Microsoft Press. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with online practice tests—featuring multiple, customizable testing options.
This exam is primarily intended for ETL and data warehouse developers who create Business Intelligence (BI) solutions, and whose responsibilities include data cleansing, and Extract Transform Load and data warehouse implementation.
Saving please wait...