MP4 | Video: h264, 1280x720 | Audio: AAC, 48 KHz, 2 Ch | Duration: 7h 40m | 16.7 GB

Genre: eLearning | Language: English

Sneak Peek

The Sneak Peek program provides early access to Pearson video products. Content for titles in this program is made available throughout the development cycle, so products may not be complete, edited, or finalized, including video post-production editing.

8+ Hours of Video Instruction

Prepare for Microsoft Exam 70-767: Implementing a Data Warehouse Using SQL, and develop practical skills to design, configure, and manage a data warehouse with SQL Server

Overview

In this video training, Scot Reagin couples discussion with demonstration to give you not only the technical and procedural aspects of implementing a data warehouse, but also a basis to make design choices that will make your job more efficient and effective.

About the Instructor

Scot Reagin’s technology career spans the entire history of what we now think of as Business Intelligence. Starting with software he developed for mini-computers in the early 1980s to the first Cube technologies of the 1990s and Self-Service BI and contemporary Predictive Analytics, Scot has consistently designed, developed, and delivered solutions for organizations across the evolving BI marketplace.

Scot is a TDWI Certified Business Intelligence Professional and Board Member of the Colorado Data Warehouse Institute. He is also a Certified Data Vault Data Modeler and active member of the Genesee Academy. Scot is the author of Microsoft 70-768: Developing SQL Data Models LiveLessons (Video Training).

Skill Level

Intermediate

Learn How To

Design and implement dimension tables and fact tables

Design Rowstore and Columnstore indexes

Design storage for a data solution

Implement SSIS packages

Who Should Take This Course

IT professionals responsible for designing, implementing, or administering SQL Server data warehouses

BI developers pursuing Microsoft Certification

Course Requirements

Basic understanding of extract, transform, and load (ETL) and data warehouses

Familiarity with Microsoft SQL Server client tools