Home > Store > Data > SQL Server

Exam Ref 70-767 Implementing a SQL Data Warehouse

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

Exam Ref 70-767 Implementing a SQL Data Warehouse

Best Value Purchase

Book + eBook Bundle

  • Your Price: $43.19
  • List Price: $71.98
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

More Purchase Options

Book

  • Your Price: $31.99
  • List Price: $39.99
  • Estimated Release: Oct 11, 2017

eBook (Watermarked)

  • Your Price: $25.59
  • List Price: $31.99
  • Estimated Release: Oct 11, 2017
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

About

Features

  • Authoritative and complete MCSA Exam 70-767 preparation content, straight from Microsoft
  • Covers data warehouse design and implementation; ETL processes; integration with cloud data and big data; and ensuring data quality
  • Organized by exam objectives for efficient study
  • Strategic, what-if scenarios challenge you as an exam candidate, helping you master the big-picture thinking the exam demands
  • Contains up-to-date exam preparation tips from a leader in the worldwide Microsoft BI and SQL Server communities

Description

  • Copyright 2018
  • Dimensions: 7-3/8 X 9
  • Pages: 416
  • Edition: 1st
  • Book
  • ISBN-10: 1-5093-0647-1
  • ISBN-13: 978-1-5093-0647-3

Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-767 Implementing a SQL Data Warehouse certification exam.

Exam Ref 70-767 Implementing a SQL Data Warehouse offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. It focuses on the specific areas of expertise modern IT professionals need to successfully build modern data warehouses to support advanced business intelligence solutions. Coverage includes:

  • Designing and implementing an effective data warehouse, including dimension tables, fact tables, indexes, storage, partitioning, and more
  • Establishing successful processes for extracting, transforming, and loading data (ETL) with SQL Server Integration Services (SSIS) and Transact-SQL (T-SQL)
  • Integrating solutions that encompass cloud data and big data, using Polybase Integrate, Hadoop Integrate, the Azure Blob service, and related tools
  • Ensuring high levels of data quality with a Data Quality Services (DQS) knowledge base and a Master Data Services (MDS) model

Microsoft Exam Ref publications stand apart from third-party study guides because they:

  • Provide guidance from Microsoft, the creator of Microsoft certification exams
  • Target IT professional-level exam candidates with content focused on their needs, not "one-size-fits-all" content
  • Streamline study by organizing material according to the exam’s objective domain (OD), covering one functional group and its objectives in each chapter
  • Feature Thought Experiments to guide candidates through a set of "what if?" scenarios, and prepare them more effectively for Pro-level style exam questions
  • Explore big picture thinking around the planning and design aspects of the IT pro’s job role

For more information on Exam 70-767 and the MCSA: SQL 2016 Business Intelligence Development credential, visit microsoft.com/learning.

Sample Content

Table of Contents

1. Design and Implement a Data Warehouse
2. Extract, Transform, and Load Data
3. Integrate Solutions with Cloud Data and Big Data
4. Build Data Quality Solutions

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership