Enable Technology

Database 

SQL Server 2012 Data Warehouse Implementation




Course Overview


Participants will learn to perform ETL (Extraction Transformation and Loading) operations by creating SSIS packages, managing a control flow and data flow, executing packages, and troubleshooting errors. To ensure the smooth functioning of the ETL operations, you will manage SSIS packages and secure them. Delegates will use SSIS packages to design and build a Data Warehouse.

The course requires a working knowledge of SQL.

Duration: 3 day course



Course Content


Introduction to Data Warehouses
Overview of Data Warehouses
Examine Data Warehousing Concepts
Introduction to Data Analysis and Reporting Concepts

Creating Dimensions and Changing Granularity of Dimensions
Create Dimensions
Change Granularity

Creating Fact Tables and Columnstore Indexes
Create Fact Tables
Create Columnstore Indexes

Implementing Data Warehouses in SQL Server 2012
Overview of Data Warehouse Components
Install Integration Services

Working with Integration Services
Create an SSIS Project
Add Packages to an SSIS Project

Managing Control Flow
Deploy a Control Flow
Execute Packages from Different Control Flow

Working with Dynamic Variables
Create Expressions with Variables
Create Package Templates

Implementing Data Flow
Add Data Flow Components to a Data Flow Task
Perform Transformation Tasks
Track Changed Data

Managing Data Flow
Add Script Tasks and Script Components to an SSIS Package
Profile OLTP Data
Cleanse Data Using DQS

Managing SSIS Package Execution
Execute SSIS Packages on the Server
Configure the Package Execution Strategy

Debugging and Troubleshooting Packages
Debug Package Execution Components
Troubleshoot Package Failures

Deploying Packages
Deploy SSIS Packages
Examine MSI Packages

Securing Packages and Databases
Secure Packages
Secure Databases

Working with MDS and Windows Azure
Configure MDS
Work with MDS Databases
Work with Windows Azure






Email us about this courses         Telephone on 01952 305730






Training Locations: Enable Technology run courses in Wolverhampton, Telford, Shrewsbury, Birmingham, Cannock, Walsall, Dudley, Sandwell, Bridgnorth, Lichfield, Burton-upon-Trent, Stafford, Redditch, Bromsgrove, Solihull, Tamworth, Worcester, Shropshire, Staffordshire, Worcestershire and across the West Midlands.




West Midlands Scheduled Courses: Excel VBA; MS Project, SSRS; SQL; Crystal Reports; HTML;Adobe Illustrator; ASP.NET; Dreamweaver; Flash; Photoshop; InDesign; Google Scripting; Visio; PHP; Microsoft Access; JQuery JavaScript; Web Development; Office;

Birmingham Scheduled Courses: SQL; Excel VBA; MS Access;Photoshop; Adobe Illustrator; InDesign; Dreamweaver; MS Project;Visio; Flash; SSRS;PHP; JavaScript JQuery; HTML CSS; Microsoft Office;

Wolverhampton Scheduled Courses: Microsoft Access; Excel VBAMS Project; Visio; Adobe Illustrator; Photoshop; Dreamweaver; InDesign; Flash; HTML CSS; JavaScript; SQL; Microsoft Office; Adobe

Telford Scheduled Courses: SQL; Excel VBA; MS Project; Visio; PowerPoint; Photoshop; Adobe InDesign; Illustrator; Dreamweaver; Web Design; Office;

Cannock Scheduled Courses: Excel VBA; PHP; Microsoft Access; Visio; MS Project; PowerPoint; Dreamweaver; Photoshop; InDesign; Adobe Illustrator; Flash; JavaScript; HTML CSS;

Walsall Scheduled Courses: Excel; Access; MS Project; Visio; Photoshop; InDesign; Adobe Illustrator; Dreamweaver; Flash; SQL; JavaScript; HTML CSS;

Dudley Scheduled Courses: Excel; MS Access; SQL; MS Project;Visio; Adobe Illustrator; InDesign; Photoshop; Dreamweaver; Flash; JavaScript; HTML CSS;

Sandwell Scheduled Courses: Access;Excel; Microsoft Project; Visio; PowerPoint; Adobe Illustrator; Photoshop; Adobe InDesign; Dreamweaver; Flash; JavaScript; HTML CSS; SQL;

Shropshire Scheduled Courses: Illustrator; InDesign; Adobe; Dreamweaver; Flash; Photoshop; Excel; Project; Visio; PowerPoint; Office; JavaScript; HTML; Access;

Staffordshire Scheduled Courses: Illustrator; InDesign; Photoshop; Dreamweaver; Flash; Adobe; Excel;