July 2018
Intermediate
8h 16m
English
Closed Captioning available in English, Japanese, Korean, Chinese (Simplified), Chinese (Traditional)
Overview
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
- Design and implement dimension tables and fact tables
- Design Rowstore and Columnstore indexes
- Design storage for a data solution
- Implement SSIS packages
- IT professionals responsible for designing, implementing, or administering SQL Server data warehouses
- BI developers pursuing Microsoft Certification
- Basic understanding of extract, transform, and load (ETL) and data warehouses
- Familiarity with Microsoft SQL Server client tools
About Pearson Video Training
Pearson publishes expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. These professional and personal technology videos feature world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, Pearson IT Certification, Prentice Hall, Sams, and Que Topics include: IT Certification, Network Security, Cisco Technology, Programming, Web Development, Mobile Development, and more. Learn more about Pearson Video training at http://www.informit.com/video.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Watch now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.