Home > Store

SQL Server 70-767: Implementing a Data Warehouse Using SQL LiveLessons (Video Training)

Register your product to gain access to bonus material or receive a coupon.

SQL Server 70-767: Implementing a Data Warehouse Using SQL LiveLessons (Video Training)

Online Video

  • Your Price: $159.99
  • List Price: $199.99
  • Estimated Release: Jun 20, 2018
  • About this video
  • Accessible from your Account page after purchase. Requires the free QuickTime Player software.

    Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.

Related Products


  • Copyright 2018
  • Edition: 1st
  • Online Video
  • ISBN-10: 0-13-522411-X
  • ISBN-13: 978-0-13-522411-3

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


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.

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

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.

Sample Content

Table of Contents


Lesson 1: Design and Implement Dimension Tables
Learning objectives
1.1 Design Hierarchies
1.2 Determine keys and key relationships
1.3 Design and maintain slowly changing dimensions
1.4 Implement auditing and lineage

Lesson 2: Design and Implement Fact Tables
Learning objectives
2.1 Identify measures
2.2 Identify dimension table relationships
2.3 Design many-to-many relationships

Lesson 3: Design an Indexed Solution
Learning objectives
3.1 Design Rowstore indexes
3.2 Design Columnstore indexes

Lesson 4: Design a Storage Solution
Learning objectives
4.1 Configure hardware and file layout
4.2 Design partitions

Lesson 5: Design and implement SSIS Packages
Learning objectives
5.1 Implement an SSIS control flow
5.2 Implement an SSIS data flow
5.3 Implement transformations
5.4 Create variables and parameters

Lesson 6: Design Advanced SSIS Packages
Learning objectives
6.1 Implement fuzzy grouping and fuzzy lookup
6.2 Implement checkpoints
6.3 Implement data profiling

Lesson 7: Design for Incremental Data Management

Learning objectives
7.1 Configure SQL Server to use Change Data Capture
7.2 Using Change Data Capture

Lesson 8: Deploy and Administer SSIS Package and Projects
Learning objectives
8.1 Diagnose errors using the debugger
8.2 Deploy and configure packages
8.3 Execute packages

Lesson 9: Create a Knowledge Base with Data Quality Services
Learning objectives
9.1 Implement Data Quality Services
9.2 Configure Data Quality Services
9.3 Implement Data Quality Services in SSIS

Lesson 10: Manage Data with Master Data Services
Learning objectives
10.1 Implement Master Data Services
10.2 Configure Master Data Services
10.3 Administer Master Data Services



Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership