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

cover for Training Kit Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012We’re happy to announce the availability of the Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012  (ISBN 978-0-7356-6609-2). If you are planning to take the 70-463 exam, are an ETL or data warehouse developer who focuses on creating business intelligence (BI) solutions, this is the book for you. Written Dejan Sarka, Matija Lah, and Grega Jerkic, who are experts in the field, you’ll work through lessons and practical exercises at your own pace, and then assess your skills with online practice tests

You’ll review 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

You can view the complete table of contents below, and you can purchase the book here: https://shop.oreilly.com/product/0790145345219.do.

Part 1: Designing and Implementing a Data Warehouse

Chapter 1: Data Warehouse Logical Design

1. Before You Begin

2. Lesson 1: Introducing Star and Snowflake Schemas

3. Lesson 2: Designing Dimensions

4. Lesson 3: Designing Fact Tables

5. Case Scenarios

6. Suggested Practices

7. Answers

Chapter 2: Implementing a Data Warehouse

1. Before You Begin

2. Lesson 1: Implementing Dimensions and Fact Tables

3. Lesson 2: Managing the Performance of a Data Warehouse

4. Lesson 3: Loading and Auditing Loads

5. Case Scenarios

6. Suggested Practices

7. Answers

Part II: Developing SSIS Packages

Chapter 3: Creating SSIS Packages

1. Before You Begin

2. Lesson 1: Using the SQL Server Import and Export Wizard

3. Lesson 2: Developing SSIS Packages in SSDT

4. Lesson 3: Introducing Control Flow, Data Flow, and Connection Managers

5. Case Scenarios

6. Suggested Practices

7. Answers

Chapter 4: Designing and Implementing Control Flow

1. Before You Begin

2. Lesson 1: Connection Managers

3. Lesson 2: Control Flow Tasks and Containers

4. Lesson 3: Precedence Constraints

5. Case Scenarios

6. Suggested Practices

7. Answers

Chapter 5: Designing and Implementing Data Flow

1. Before You Begin

2. Lesson 1: Defining Data Sources and Destinations

3. Lesson 2: Working with Data Flow Transformations

4. Lesson 3: Determining Appropriate ETL Strategy and Tools

5. Case Scenario

6. Suggested Practices

7. Answers

Part III: Enhancing SSIS Packages

Chapter 6: Enhancing Control Flow

1. Before You Begin

2. Lesson 1: SSIS Variables

3. Lesson 2: Connection Managers, Tasks, and Precedence Constraint Expressions

4. Lesson 3: Using a Master Package for Advanced Control Flow

5. Case Scenarios

6. Suggested Practices

7. Answers

Chapter 7: Enhancing Data Flow

1. Before You Begin

2. Lesson 1: Slowly Changing Dimensions

3. Lesson 2: Preparing a Package for Incremental Load

4. Lesson 3: Error Flow

5. Case Scenario

6. Suggested Practices

7. Answers

Chapter 8: Creating a Robust and Restartable Package

1. Before You Begin

2. Lesson 1: Package Transactions

3. Lesson 2: Checkpoints

4. Lesson 3: Event Handlers

5. Case Scenario

6. Suggested Practices

7. Answers

Chapter 9: Implementing Dynamic Packages

1. Before You Begin

2. Lesson 1: Package-Level and Project-Level Connection Managers and Parameters

3. Lesson 2: Package Configurations

4. Case Scenario

5. Suggested Practices

6. Answers

Chapter 10: Auditing and Logging

1. Before You Begin

2. Lesson 1: Logging Packages

3. Lesson 2: Implementing Auditing and Lineage

4. Lesson 3: Preparing Package Templates

5. Case Scenarios

6. Suggested Practices

7. Answers

Part IV: Managing and Maintaining SSIS Packages

Chapter 11: Installing SSIS and Deploying Packages

1. Before You Begin

2. Lesson 1: Installing SSIS Components

3. Lesson 2: Deploying SSIS Packages

4. Case Scenarios

5. Suggested Practices

6. Answers

Chapter 12: Executing and Securing Packages

1. Before You Begin

2. Lesson 1: Executing SSIS Packages

3. Lesson 2: Securing SSIS Packages

4. Case Scenarios

5. Suggested Practices

6. Answers

Chapter 13: Troubleshooting and Performance Tuning

1. Before You Begin

2. Lesson 1: Troubleshooting Package Execution

3. Lesson 2: Performance Tuning

4. Case Scenario

5. Suggested Practice

6. Answers

Part V: Building Data Quality Solutions

Chapter 14: Installing and Maintaining Data Quality Services

7. Before You Begin

8. Lesson 1: Data Quality Problems and Roles

1. Lesson 2: Installing Data Quality Services

2. Lesson 3: Maintaining and Securing Data Quality Services

3. Case Scenario

4. Suggested Practices

5. Answers

Chapter 15: Implementing Master Data Services

1. Before You Begin

2. Lesson 1: Defining Master Data

3. Lesson 2: Installing Master Data Services

4. Lesson 3: Creating a Master Data Services Model

5. Case Scenarios

6. Suggested Practices

7. Answers

Chapter 16: Managing Master Data

1. Before You Begin

2. Lesson 1: Importing and Exporting Master Data

3. Lesson 2: Defining Master Data Security

4. Lesson 3: Using Master Data Services Add-in for Excel

5. Case Scenario

6. Suggested Practices

7. Answers

Chapter 17: Creating a Data Quality Project to Clean Data

1. Before You Begin

2. Lesson 1: Creating and Maintaining a Knowledge Base

3. Lesson 2: Creating a Data Quality Project

4. Lesson 3: Profiling Data and Improving Data Quality

5. Case Scenario

6. Suggested Practices

7. Answers

Part VI: Advanced SSIS and Data Quality Topics

Chapter 18: SSIS and Data Mining

8. Before You Begin

9. Lesson 1: Data Mining Task and Transformation

10. Lesson 2: Text Mining

11. Lesson 3: Preparing Data for Data Mining

12. Case Scenario

13. Suggested Practices

14. Answers

Chapter 19: Implementing Custom Code in SSIS Packages

1. Before You Begin

2. Lesson 1: Script Task

3. Lesson 2: Script Component

4. Lesson 3: Implementing Custom Components

5. Case Scenario

6. Suggested Practices

7. Answers

Chapter 20: Identity Mapping and De-Duplicating

1. Before You Begin

2. Lesson 1: Understanding the Problem

3. Lesson 2: Using DQS and the DQS Cleansing Transformation

4. Lesson 3: Implementing SSIS Fuzzy Transformations

5. Case Scenario

6. Suggested Practices

7. Answers

Appendix: About the Authors