Home > Store > Certification > Microsoft Certification

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

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

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

Best Value Purchase

Book + eBook Bundle

  • Your Price: $75.59
  • List Price: $125.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: $55.99
  • List Price: $69.99
  • Usually ships in 24 hours.

eBook (Watermarked)

  • Your Price: $44.79
  • List Price: $55.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.

Description

  • Copyright 2013
  • Dimensions: 7-3/8" x 9"
  • Pages: 600
  • Edition: 1st
  • Book
  • ISBN-10: 0-7356-6609-1
  • ISBN-13: 978-0-7356-6609-2

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


For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Downloads

Downloads

  1. Click the following link: Download the companion content.
  2. Click Save.
  3. Locate the .zip file on your computer. Right-click the file, click Extract All, and then follow the instructions.

The above link does not include the Practice Tests. If you purchased the eBook from this site, the practice test files are available for download on your Account page, under the Disc Contents tab.

Download the sample database(s)

  1. Click the following links:
    AdventureWorksDataFiles.zip
    TK70463_CodeLabSolutions.zip
  2. Click Save.
  3. Choose a location where you want to store this sample database (.mdf file).

    Note You can save the .mdf file wherever you like, but one good place is to save it in the default SQL Server databases folder. You need administrator permission to do that. Typically, the local databases folder is C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA.

Attach the sample database(s)

  1. Start SQL Server Management Studio (SSMS).
  2. Connect to your SQL Server 2012 instance.
  3. In Object Explorer, right-click the Databases node beneath your SQL Server 2012 instance and then choose Attach.
  4. Beneath Databases To Attach, click Add.
  5. In the Local Database Files dialog, scroll to the downloaded .mdf file that you saved locally, select it, and then click OK.

    IMPORTANT When using this method to attach, SSMS will by default also search for the .ldf file (which isn't included), causing the attach-process to fail. You must manually remove the .ldf before clicking OK as discussed in the next step.
  6. Beneath the database details list, select the Log file (filename ending with .ldf) and then click Remove.
  7. Click OK.

You can find more instructions related to attaching databases here: http://msdn.microsoft.com/en-us/library/ms190209.aspx.

Sample Content

Sample Pages

Download the sample content

Table of Contents

  • 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

Updates

Errata

We've made every effort to ensure the accuracy of this book and its companion content. Any errors that have been confirmed since this book was published can be downloaded below.

Download the errata

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership