Implementing a Data Warehouse with SQL Server Jump Start
Are you a SQL Server professional looking to expand your understanding of SQL Server 2012 data warehousing concepts and implementation? Take this Jump Start, which focuses on the design of Dimensions to support 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.

COURSE OUTLINE


   - Design and Implement Dimensions and Fact Tables
   - Data Flow; Extract Data
   - Data Flow; Transform Data
   - Control Flow; Load Data
   - Configure and Deploy SSIS
   - Manage Enterprise Data
  

Instructor Team
Richard Currey | SQL Server instructor
Rich is currently a Microsoft SQL Server instructor at New Horizons (NHUnited) with over 10 years of experience helping SQL Server professionals and students who desire to be SQL Server professionals gain the necessary knowledge. He has over 25 years of industry experience, during which he has implemented BI projects, including ETL processes and data warehousing for Fortune 500 companies across the United States. He currently resides in Connecticut where he spends his free time driving in and attending auto races.
George SQuiLlace | SQL Server instructor
George SQUILLACE (notice the SQL in the name) is a Microsoft SQL Server instructor at New Horizons Great Lakes, with 20 years of service, and 28 years in the IT industry. Having become a Microsoft Certified Trainer in 1997, George is certified in every version of SQL Server since SQL 2000, and passed all seven SQL 2012 exams. George’s background includes deep experience with Windows Server and he is certified in every version of Windows Server from NT 4.0 through Windows Server 2008, and is certified in Exchange Server from 5.5 through 2007. As of recently George sat in on his 96th certification exam event!

George lives in East Lansing, Michigan (home of the MSU Spartans) with his wife and three kids, and enjoys movies, reading, bicycling (1,200 miles this summer), travel, music, and computers.
Live Event Details
October 18, 2013
9:00am-5:00pm PDT
What: Fast Paced Live Virtual Session
Cost: Free
Audience: Developer, Advanced Information Workers, Database Administrators
Prerequisites:

The Administering SQL Server 2012 Jump Start is a prerequisite to this Jump Start. This Jump Start will help you prepare for Exam 70-463.