Home > Store

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
  • Usually ships in 24 hours.

eBook (Watermarked)

  • Your Price: $25.59
  • List Price: $31.99
  • 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: 288
  • Edition: 1st
  • Book
  • ISBN-10: 1-5093-0647-1
  • ISBN-13: 978-1-5093-0647-3

Prepare for Microsoft Exam 70-767–and help demonstrate your real-world mastery of skills for managing data warehouses. This exam is intended for Extract, Transform, Load (ETL) data warehouse developers who create business intelligence (BI) solutions. Their responsibilities include data cleansing as well as ETL and data warehouse implementation. The reader should have experience installing and implementing a Master Data Services (MDS) model, using MDS tools, and creating a Master Data Manager database and web application. The reader should understand how to design and implement ETL control flow elements and work with a SQL Service Integration Services package.

Focus on the expertise measured by these objectives:

•  Design, and implement, and maintain a data warehouse

•  Extract, transform, and load data

•  Build data quality solutionsThis Microsoft Exam Ref:

•  Organizes its coverage by exam objectives

•  Features strategic, what-if scenarios to challenge you

•  Assumes you have working knowledge of relational database technology and incremental database extraction, as well as experience with designing ETL control flows, using and debugging SSIS packages, accessing and importing or exporting data from multiple sources, and managing a SQL data warehouse.

Implementing a SQL Data Warehouse

About the Exam

Exam 70-767 focuses on skills and knowledge required for working with relational database technology.

About Microsoft Certification

Passing this exam earns you credit toward a Microsoft Certified Professional (MCP) or Microsoft Certified Solutions Associate (MCSA) certification that demonstrates your mastery of data warehouse management

Passing this exam as well as Exam 70-768 (Developing SQL Data Models) earns you credit toward a Microsoft Certified Solutions Associate (MCSA) SQL 2016 Business Intelligence (BI) Development certification.

See full details at: microsoft.com/learning

Downloads

Downloads

Follow the instructions to download this book's companion content.

  1. Click the Download button below to start the download.
  2. If prompted, click Save.
  3. Locate the .pdf file on your computer. Click to open in a .pdf reader.
Download

Sample Content

Table of Contents

CHAPTER 1 Design and implement a data warehouse 

CHAPTER 2 Extract, transform, and load data

CHAPTER 3 Build data quality solutions

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership