United States

Total Activity

students registered
students registered

Connect with MVA

Implementing a Data Warehouse with SQL Server Jump Start

Total points
Average User Rating:
Bonus points for course completion: 15
Add to My Learning Plan
You must sign in and try the content to rate it. Do you want to sign in?

Are you a SQL Server professional looking to expand your understanding of SQL Server 2012 data warehousing concepts and implementation? Or maybe you are 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 live demos to 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.

Instructors | Rich Currey - Microsoft Certified Trainer; George Squillace - Microsoft Certified Trainer

Associated Exam(s) | 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012
Related Certification | MCSA: SQL Server
Associated Course(s) | 10777: Implementing a Data Warehouse with Microsoft SQL Server 2012

Course owner: Dean Of Colleges
01 | Design and Implement Dimensions and Fact Tables
9 Points -  Level 200
02 | Data Flow - Extract Data
9 Points -  Level 200
03 | Data Flow - Transform Data
9 Points -  Level 200
04 | Control Flow
9 Points -  Level 200
05 | Configure and Deploy SSIS
9 Points -  Level 200
06 | Manage Enterprise Data
9 Points -  Level 200
Recommended Resources & Next Steps for Implementing a Data W...
3 Points -  Level 200
Related Course Resources & Events
Next Steps