Exam Ref 70-767 Implementing a SQL Data Warehouse,9781509306473

Exam Ref 70-767 Implementing a SQL Data Warehouse

by ;
ISBN13: 9781509306473
ISBN10: 1509306471
Format: Paperback
Pub. Date: 2017-11-09
Publisher(s): Microsoft Press
  • Complimentary 7-Day eTextbook Access - Read more
    When you rent or buy this book, you will receive complimentary 7-day online access to the eTextbook version from your PC, Mac, tablet, or smartphone. Feature not included on Marketplace Items.
List Price: $39.99

Buy New

Usually Ships in 2-3 Business Days
$39.95
Add to Cart

Rent Textbook

Select for Price
Add to Cart
There was a problem. Please try again later.

Rent Digital

Rent Digital Options
Online:1825 Days access
Downloadable:Lifetime Access
$62.39
*To support the delivery of the digital material to you, a digital delivery fee of $3.99 will be charged on each digital item.
$62.39*
Add to Cart

Used Textbook

We're Sorry
Sold Out

Buy from our Marketplace starting at $7.94

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

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

Author Biography

Jose Chinchilla is the President of Agile Bay. He writes and speaks about SQL Server administration and performance, data warehousing, business intelligence, predictive analytics and big data. 


Raj Uchhana is an enterprise data architect specializing in business intelligence, enterprise data warehousing, and Microsoft’s Power BI. Raj can be reached at: Raj@BusinessIntelligenceNow.com  

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

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.