Microsoft SQL Server 2012: Implementing a Data Warehouse (70-463)
April 2013 with Garth Schulte
- 22 videos
- 12 hrs 39 mins
This SQL Server video training course with Garth Schulte covers Microsoft’s database management system including designing and implementing dimensions, troubleshooting data integration issues, and implementing master data services.
SQL Server business intelligence developers are rock stars in the eyes of an organization's decision makers. Managing and providing high-level data through a data warehouse helps businesses make accurate decisions that save time and money.
This course provides you with the skills you need to create and manage a data warehouse in SQL Server 2012. Learn how to design and implement a data warehouse, implement and automate an ETL solution using SQL Server Integration Services to load warehouse data, and utilize Master Data Services along with Data Quality Services to standardize, enrich, and evolve data over time.
Exam 70-463 is the final step toward attaining the Microsoft MCSA: SQL Server 2012 certification, which completes the pre-requisites toward both MCSE certifications: Data Platform and Business Intelligence. This course helps prepare you for the 70-463 exam and beyond with real-world examples and live demonstrations.
Note: The exam associated with this course was revised December 1, 2015. A large percentage of this course still maps to the current exam objectives and continues to provide value as a training resource. Furthermore, an instructional PDF has been added to the Supplemental Files for your use within the Virtual Lab.
- Experience creating Business Intelligence solutions
- Experience with data cleansing
- Experience with Exact Transform Load and data warehouse implementation
- Microsoft SQL Server 2012
- MCSA: SQL Server 2012
- MCSE: Data Platform
- MCSE: Business Intelligence
- MCSM: Data Platform
- IT professionals
- Database developers
- Database analysts
- ETL developers
- Data warehouse developers