Implementing a Data Warehouse with Microsoft SQL Server 2012/14/16 (70-463) Course

Microsoft SQL Server Training Online & Onsite

Attend Our Classes From Home - No Software Needed - Learn More...

Microsoft SQL Server TrainingImplementing a Data Warehouse with Microsoft SQL Server 2012/14/16 (70-463)

by Certstaffix® Training

Length: 5 day(s)      Public Class Price: $-/person (USD)      Group Class Price: Request Quote      Course Category: Microsoft SQL Server


Microsoft SQL Server Training
The primary audience for this course is Extract Transform Load (ETL) and Data Warehouse Developers. They are most likely to focus on hands-on work creating business intelligence (BI) solutions including data cleansing, ETL, and Data Warehouse implementation.

This course will be taught using 2012 software, however, 2014 and 2016 can attend due to similarities.

Certification exams are administered by third party testing companies such as Pearson Vue or Prometric. Our courses prepare you for the certification exam, which is an additional fee paid to the testing provider. You must contact Prometric, Pearson Vue or the corresponding testing provider to take a certification exam.
Course Description: Print It | Download PDF | Email It

  Public Classes - Live Online at Your Location or OursHow It Works

Certstaffix® Training public classes are instructor-led, live online training you attend from your home or work or in one of our local computer labs. Our live online instructors teach you from a remote location while being able to interact with students as in a traditional classroom setting.

  • A real, live instructor teaching you from another location
  • Hands-on learning with the software/skills you are being taught
  • Interaction with all students in the class at other locations
  • Any needed software for class provided in online lab environment
  • Easy assistance from the instructor

Click a class date below to register & view location/attendance options.



This course is available for private onsite training only.  Request a Quote


  Group Classes for Organizations - Onsite or Online How It Works

Have a group of employees needing the same training? Onsite training at your office or group live online classes are great solutions.  

  • An expert Instructor will either come to your office or deliver a private live online class to your students
  • Course can be customized to your training needs
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 4 weeks lead time to arrange a training session

  Detailed Course Topics

Course Description: Print It | Download PDF | Email It

Related Certifications

70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 Certification


Course Topics

Designing and Implementing a Data Warehouse
Chapter 1 Data Warehouse Logical Design
Lesson 1: Introducing Star and Snowflake Schemas
Lesson 2: Designing Dimensions
Lesson 3: Designing Fact Tables

Chapter 2 Implementing a Data Warehouse
Lesson 1: Implementing Dimensions and Fact Tables
Lesson 2: Managing the Performance of a Data Warehouse
Lesson 3: Loading and Auditing Loads

Developing SSIS Packages
Chapter 3 Creating SSIS Packages
Lesson 1: Using the SQL Server Import and Export Wizard
Lesson 2: Developing SSIS Packages in SSDT
Lesson 3: Introducing Control Flow, Data Flow, and Connection Managers

Chapter 4 Designing and Implementing Control Flow
Lesson 1: Connection Managers
Lesson 2: Control Flow Tasks and Containers
Lesson 3: Precedence Constraints

Chapter 5 Designing and Implementing Data Flow
Lesson 1: Defining Data Sources and Destinations
Lesson 2: Working with Data Flow Transformations
Lesson 3: Determining Appropriate ETL Strategy and Tools

Enhancing SSIS Packages
Chapter 6 Enhancing Control Flow
Lesson 1: SSIS Variables
Lesson 2: Connection Managers, Tasks, and Precedence Constraint Expressions
Lesson 3: Using a Master Package for Advanced Control Flow

Chapter 7 Enhancing Data Flow
Lesson 1: Slowly Changing Dimensions
Lesson 2: Preparing a Package for Incremental Load
Lesson 3: Error Flow

Chapter 8 Creating a Robust and Restartable Package
Lesson 1: Package Transactions
Lesson 2: Checkpoints
Lesson 3: Event Handlers

Chapter 9 Implementing Dynamic Packages
Lesson 1: Package-Level and Project-Level Connection Managers and Parameters
Lesson 2: Package Configurations

Chapter 10 Auditing and Logging
Lesson 1: Logging Packages
Lesson 2: Implementing Auditing and Lineage
Lesson 3: Preparing Package Templates

Managing and Maintaining SSIS Packages
Chapter 11 Installing SSIS and Deploying Packages
Lesson 1: Installing SSIS Components
Lesson 2: Deploying SSIS Packages

Chapter 12 Executing and Securing Packages
Lesson 1: Executing SSIS Packages
Lesson 2: Securing SSIS Packages

Chapter 13 Troubleshooting and Performance Tuning
Lesson 1: Troubleshooting Package Execution
Lesson 2: Performance Tuning

Building Data Quality Solutions
Chapter 14 Installing and Maintaining Data Quality Services
Lesson 1: Data Quality Problems and Roles
Lesson 2: Installing Data Quality Services
Lesson 3: Maintaining and Securing Data Quality Services

Chapter 15 Implementing Master Data Services
Lesson 1: Defining Master Data
Lesson 2: Installing Master Data Services
Lesson 3: Creating a Master Data Services Model

Chapter 16 Managing Master Data
Lesson 1: Importing and Exporting Master Data
Lesson 2: Defining Master Data Security
Lesson 3: Using Master Data Services Add-in for Excel

Chapter 17 Creating a Data Quality Project to Clean Data
Lesson 1: Creating and Maintaining a Knowledge Base
Lesson 2: Creating a Data Quality Project
Lesson 3: Profiling Data and Improving Data Quality

Advanced SSIS and Data Quality Topics
Chapter 18 SSIS and Data Mining
Lesson 1: Data Mining Task and Transformation
Lesson 2: Text Mining
Lesson 3: Preparing Data for Data Mining

Chapter 19 Implementing Custom Code in SSIS Packages
Lesson 1: Script Task
Lesson 2: Script Component
Lesson 3: Implementing Custom Components

Chapter 20 Identity Mapping and De-Duplicating
Lesson 1: Understanding the Problem
Lesson 2: Using DQS and the DQS Cleansing Transformation
Lesson 3: Implementing SSIS Fuzzy Transformations
Course Description: Print It | Download PDF | Email It

Public Class Format

Certstaffix® Training public classes are instructor-led live online training you attend either from your home/work location or in one of our computer labs. Our live online instructors teach you from a remote location while being able to interact with you like in a traditional classroom.


Quality Instructors

Our instructors have many years of experience teaching adult learners in person and online.

Complete Lab Environment

Access to software required is provided in a lab environment during class.

Hands-on Learning

Most classes are not all lecture - you can learn by actually doing.


Small Classes

You get more attention from the instructor and classes flow more smoothly.

Post-Class Lab Access*

Access practice lab environment for 180 days after most classes*.


Low Cancellation Rate

Most classes run as scheduled.



*These courses do not have post-class lab environment access: Adobe, Salesforce, QuickBooks Online Edition, Google, HTML, WordPress, ITIL, Six Sigma, CompTIA, Project Management, SEO, Social Media.


Group Training

Have a group of employees needing the same training? Onsite training at your office or group live online classes are great solutions.

How Group Training Works





  • An expert Instructor will either come to your office or deliver a private live online class to your students
  • Course can be fully customized to your training needs
  • Each student receives a Course Manual with Practice Files (Materials provided before the class date)
  • If a course has a hands‐on lab, we provide access to the configured course software and files.
    (Requires a high‐speed internet connection and certain open ports on your firewall. You can perform a Connection Assessment Test here)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 4 weeks lead time to arrange a training session
  • Training is completed in a convenient session(s) of your choosing
  • Two 15 minute breaks and one hour long break for lunch daily

Request a Free Quote

Implementing a Data Warehouse with Microsoft SQL Server 2012/14/16 (70-463) Class Reviews

Here are a sample of Microsoft SQL Server class reviews from past students that have attended our Microsoft SQL Server training courses.



The primary audience for this course is Extract Transform Load (ETL) and Data Warehouse Developers. They are most likely to focus on hands-on work creating business intelligence (BI) solutions including data cleansing, ETL, and Data Warehouse implementation.


This course will be taught using 2012 software, however, 2014 and 2016 can attend due to similarities.

Certification exams are administered by third party testing companies such as Pearson Vue or Prometric. Our courses prepare you for the certification exam, which is an additional fee paid to the testing provider. You must contact Prometric, Pearson Vue or the corresponding testing provider to take a certification exam.


Certstaffix® Class Reviews

Student Average:
4.73 out of 5 from 12 students

4.96 out of 5

Dave Zubal is an excellent teacher.


- attended our Querying Microsoft SQL Server 2012/14/16 (70-461) class

5.00 out of 5


- attended our Querying Microsoft SQL Server 2012/14/16 (70-461) class

4.96 out of 5


- attended our Microsoft SQL Server 2012/14/16 Reporting Services (SSRS) class

4.17 out of 5


- attended our Microsoft SQL Server 2012/14/16 Reporting Services (SSRS) class

4.39 out of 5


- attended our Administering Microsoft SQL Server 2012/14/16 Databases (70-462) class

5.00 out of 5


- attended our Querying Microsoft SQL Server 2012/14 (70-461) class

5.00 out of 5


- attended our Querying Microsoft SQL Server 2012/14 (70-461) class

4.76 out of 5


- attended our Querying Microsoft SQL Server 2012/14 (70-461) class

4.47 out of 5


- attended our Querying Microsoft SQL Server 2012/14 (70-461) class

5.00 out of 5


- attended our Microsoft SQL Server 2012/14 Reporting Services (SSRS) class

5.00 out of 5


- attended our Microsoft SQL Server 2012/14 Reporting Services (SSRS) class

4.06 out of 5


- attended our Microsoft SQL Server 2012/14 Reporting Services (SSRS) class



Please contact us if we do not yet have any reviews or you would like more.


View all Microsoft SQL Server training reviews

Microsoft SQL Server Courses By City:

       FL - Tampa       NC - Asheville       PA - York      
- - your home       FL - Winter Park       NC - Charlotte       PR - Puerto Rico      
AL - Birmingham       GA - Atlanta       NC - Greensboro       QC - Montreal      
AL - Huntsville       GA - Augusta       NC - Raleigh       RI - Providence      
AL - Mobile       GA - Columbus       NC - Winston-Salem       SC - Greenville      
AR - Bentonville       GA - Savannah       ND - Bismarck       SC - Myrtle Beach      
BC - Vancouver       HI - Honolulu       ND - Fargo       SC - North Charleston      
CA - Bakersfield       IA - Des Moines       NE - Lincoln       SK - Regina      
CA - Fresno       IA - Iowa City       NE - Omaha       SK - Saskatoon      
CA - Los Angeles       ID - Boise       NH - Bedford       TN - Chattanooga      
CA - Merced       IL - Chicago       NJ - Bridgewater       TN - Knoxville      
CA - Modesto       IL - Rockford       NM - Albuquerque       TN - Memphis      
CA - Napa       IN - Bloomington       NM - Las Cruces       TN - Nashville      
CA - Oakland       IN - Evansville       NM - Santa Fe       TX - Amarillo      
CA - Oxnard       IN - Fort Wayne       NS - Halifax       TX - Austin      
CA - Rancho Cucamonga       IN - Indianapolis       NV - Henderson       TX - Beaumont      
CA - Sacramento       IN - South Bend       NV - Reno       TX - Corpus Christi      
CA - Salinas       KS - Overland Park       NY - Albany       TX - Dallas      
CA - San Diego       KS - Topeka       NY - Buffalo       TX - El Paso      
CA - San Jose       KY - Lexington       NY - New York City       TX - Fort Worth      
CA - Santa Maria       KY - Louisville       NY - Rochester       TX - Houston      
CA - Santa Rosa       LA - Baton Rouge       NY - Syracuse       TX - Killeen      
CA - Stockton       LA - Lafayette       OH - Beavercreek       TX - Laredo      
CB - Caribbean       LA - New Orleans       OH - Cincinnati       TX - Longview      
CB - Kingston       LA - Shreveport       OH - Cleveland Heights       TX - Lubbock      
CB - Nassau       MA - Burlington       OH - Columbus       TX - McAllen      
CO - Boulder       MA - Springfield       OH - Toledo       TX - Midland      
CO - Colorado Springs       MA - Westborough       OH - Youngstown       TX - San Antonio      
CO - Denver       MB - Winnipeg       OK - Oklahoma City       TX - Tyler      
CT - Cheshire       MD - Laurel       OK - Tulsa       TX - Waco      
CT - New Haven       ME - Portland       ON - Ottawa       UT - Ogden      
CT - Stamford       MI - Ann Arbor       ON - Toronto       UT - Salt Lake City      
DC - Washington       MI - Flint       OR - Beaverton       VA - Charlottesville      
DE - Wilmington       MI - Grand Rapids       OR - Bend       VA - Glen Allen      
FL - Daytona Beach       MI - Lansing       OR - Eugene       VA - Harrisonburg      
FL - Fort Lauderdale       MI - Livonia       OR - Medford       VA - Roanoke      
FL - Fort Myers       MN - Minnetonka       OR - Salem       VA - Virginia Beach      
FL - Gainesville       MO - Columbia       PA - Allentown       VT - Burlington      
FL - Jacksonville       MO - St. Louis       PA - Erie       WA - Seattle      
FL - Lakeland       MS - Biloxi       PA - Harrisburg       WA - Spokane      
FL - Miami       MS - Jackson       PA - Malvern       WI - Eau Claire      
FL - Naples       MT - Billings       PA - Philadelphia       WI - Green Bay      
FL - Pensacola       MT - Montana       PA - Pittsburgh       WI - Madison      
FL - Sarasota       NB - Moncton       PA - Reading       WI - Milwaukee      
FL - Tallahassee       NB - Saint John       PA - Scranton-Wilkes Barre