Course Features:
Live Instructor Teaching
Certificate of Completion
Courseware: Print
Free 6 Month Online Retake
Hands-On Learning?: Yes
Software Lab Included?: Yes
Delivery Methods:
Group Teams
@ Your Location
Group Teams
@ Your Organization
This is an instructor-led course. It is taught by an instructor
live online or at organizations for groups.
For
team training, we can teach onsite at your office or private live online.
Register Early: Registration Deadline is 2 Weeks Prior to Class Start.
Course Overview
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.
Course Notes
Course Taught With: 2012 software
SQL Server Versions That Can Attend: 2016, 2014, and 2012
Certification Notes: Certification exams are administered by third party testing companies. Our courses prepare you for the certification exam, which is an additional fee paid to the testing provider. You must contact the corresponding testing provider to take a certification exam.
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
Explore SQL Server Classes Near Me: