Implementing a Data Warehouse with Microsoft SQL Server 2012

Course ID

16030

Course Description

Ace your preparation for Microsoft Certification Exam 70-463 with this course 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

Prerequisites

None

Audience

This exam is primarily intended for ETL and data warehouse developers who create Business Intelligence (BI) solutions, and whose responsibilities include data cleansing, and Extract Transform Load and data warehouse implementation.

Course Content

    Data Warehouse Logical Design
  • Introducing Star and Snowflake Schemas
  • Designing Dimensions
  • Designing Fact Tables
  • Case Scenarios
  • Suggested Practices
  • Answers

    Implementing a Data Warehouse
  • Implementing Dimensions and Fact Tables
  • Managing the Performance of a Data Warehouse
  • Loading and Auditing Loads
  • Case Scenarios
  • Suggested Practices
  • Answers
  • Developing SSIS Packages

    Creating SSIS Packages
  • Using the SQL Server Import and Export Wizard
  • Developing SSIS Packages in SSDT
  • Introducing Control Flow, Data Flow, and Connection Managers
  • Case Scenarios
  • Suggested Practices
  • Answers

    Designing and Implementing Control Flow
  • Connection Managers
  • Control Flow Tasks and Containers
  • Precedence Constraints
  • Case Scenarios
  • Suggested Practices
  • Answers

    Designing and Implementing Data Flow
  • Defining Data Sources and Destinations
  • Working with Data Flow Transformations
  • Determining Appropriate ETL Strategy and Tools
  • Case Scenario
  • Suggested Practices
  • Answers
  • Enhancing SSIS Packages

    Enhancing Control Flow
  • SSIS Variables
  • Connection Managers, Tasks, and Precedence Constraint Expressions
  • Using a Master Package for Advanced Control Flow
  • Case Scenarios
  • Suggested Practices
  • Answers

    Enhancing Data Flow
  • Slowly Changing Dimensions
  • Preparing a Package for Incremental Load
  • Error Flow
  • Case Scenario
  • Suggested Practices
  • Answers

    Creating a Robust and Restartable Package
  • Package Transactions
  • Checkpoints
  • Event Handlers
  • Case Scenario
  • Suggested Practices
  • Answers

    Implementing Dynamic Packages
  • Package-Level and Project-Level Connection Managers and

    Parameters
  • Package Configurations
  • Case Scenario
  • Suggested Practices
  • Answers

    Auditing and Logging
  • Logging Packages
  • Implementing Auditing and Lineage
  • Preparing Package Templates
  • Case Scenarios
  • Suggested Practices
  • Answers
  • Managing and Maintaining SSIS Packages

    Installing SSIS and Deploying Packages
  • Installing SSIS Components
  • Deploying SSIS Packages
  • Case Scenarios
  • Suggested Practices
  • Answers

    Executing and Securing Packages
  • Executing SSIS Packages
  • Securing SSIS Packages
  • Case Scenarios
  • Suggested Practices
  • Answers

    Troubleshooting and Performance Tuning
  • Troubleshooting Package Execution
  • Performance Tuning
  • Case Scenario
  • Suggested Practice
  • Answers
  • Building Data Quality Solutions

    Installing and Maintaining Data Quality Services
  • Data Quality Problems and Roles
  • Installing Data Quality Services
  • Maintaining and Securing Data Quality Services
  • Case Scenario
  • Suggested Practices
  • Answers

    Implementing Master Data Services
  • Defining Master Data
  • Installing Master Data Services
  • Creating a Master Data Services Model
  • Case Scenarios
  • Suggested Practices
  • Answers

    Managing Master Data
  • Importing and Exporting Master Data
  • Defining Master Data Security
  • Using Master Data Services Add-in for Excel
  • Case Scenario
  • Suggested Practices
  • Answers

    Creating a Data Quality Project to Clean Data
  • Creating and Maintaining a Knowledge Base
  • Creating a Data Quality Project
  • Profiling Data and Improving Data Quality
  • Case Scenario
  • Suggested Practices
  • Answers
  • Advanced SSIS and Data Quality Topics

    SSIS and Data Mining
  • Data Mining Task and Transformation
  • Text Mining
  • Preparing Data for Data Mining
  • Case Scenario
  • Suggested Practices
  • Answers

    Implementing Custom Code in SSIS Packages
  • Script Task
  • Script Component
  • Implementing Custom Components
  • Case Scenario
  • Suggested Practices
  • Answers

    Identity Mapping and De-Duplicating
  • Understanding the Problem
  • Using DQS and the DQS Cleansing Transformation
  • Implementing SSIS Fuzzy Transformations
  • Case Scenario
  • Suggested Practices
  • Answers

For More Information

For training inquiries, call 850-308-1376

or email us at eramos@gbsi.com

Course Details

Duration - 5 days
Price - $3095.00 USD


(Discounts may apply. Call for more information.)

Course Actions

Schedule

Acceletrain Collaborative Learning Environment (formerly know as VILT) places industry certified and expert instructors, peers, learners and multi-media components into a "borderless classroom", and interactive learning environment that can span multiple physical locations. VILT combines the benefits of the traditional brick-and-mortar classroom with innovative learning techniques and the cost savings of internet-based training.