9780735666092

Ace your preparation for Microsoft® Certification Exam 70-463 with this 2-in-1 Training Kit from Microsoft Press®. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with online practice tests-featuring multiple, customizable testing options. Maximize your performance on the exam by learning how to: Design and implement a data warehouse Develop and enhance SQL Server Integration Services packages Manage and maintain SQL Server Integration Services packages Build data quality solutions Implement custom code in SQL Server Integration Services packages

Dejan Sarka is a mentor with SolidQ and focuses on development of database and business intelligence applications. He is a frequent speaker at international conferences such as TechEd, SqlDevCon, and PASS. He is the founder of the Slovenian SQL Server and .NET Users Group. As main author or coauthor, Dejan has written nine books about SQL Server. He has also developed three courses for SolidQ: Data Modeling Essentials, Data Quality and Master Data Management, and Data Mining.

Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012

Introduction

Designing and Implementing a Data Warehouse

Chapter 1: Data Warehouse Logical Design
Chapter 2: Implementing a Data Warehouse

Developing SSIS Packages

Chapter 3: Creating SSIS Packages
Chapter 4: Designing and Implementing Control Flow
Chapter 5: Designing and Implementing Data Flow

Enhancing SSIS Packages

Chapter 6: Enhancing Control Flow
Chapter 7: Enhancing Data Flow
Chapter 8: Creating a Robust and Restartable Package
Chapter 9: Implementing Dynamic Packages
Chapter 10: Auditing and Logging

Managing and Maintaining SSIS Packages

Chapter 11: Installing SSIS and Deploying Packages
Chapter 12: Executing and Securing Packages
Chapter 13: Troubleshooting and Performance Tuning

Building Data Quality Solutions

Chapter 14: Installing and Maintaining Data Quality Services
Chapter 15: Implementing Master Data Services
Chapter 16: Managing Master Data
Chapter 17: Creating a Data Quality Project to Clean Data

Advanced SSIS and Data Quality Topics

Chapter 18: SSIS and Data Mining
Chapter 19: Implementing Custom Code in SSIS Packages
Chapter 20: Identity Mapping and De-Duplicating

About the Authors

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Amazon no longer offers textbook rentals. We do!

Training Kit (Exam 70-463) Implementing a Data Warehouse with Microsoft SQL Server 2012 (MCSA)

Training Kit (Exam 70-463) Implementing a Data Warehouse with Microsoft SQL Server 2012 (MCSA)

0735666091

Summary

Author Biography

Table of Contents

Supplemental Materials

Write a Review