The five day Implementing A Data Warehouse With Microsoft SQL Server® (SSIS) training course will show you how to implement a data warehouse platform to support a BI solution. The training course is designed for those who are interested in learning SQL Server 2012 or SQL Server 2014 and covers the new features in SQL Server 2014 but also the important capabilities across the SQL Server data platform.
Module 1: Introduction To Data Warehousing
Overview Of Data Warehousing
Considerations For A Data Warehouse Solution
Lab: Exploring A Data Warehousing Solution
Module 2: Data Warehouse Hardware Considerations
Considerations For Building A Data Warehouse
Data Warehouse Reference Architectures And Appliances
Lab: Planning Data Warehouse Infrastructure
Module 3: Designing And Implementing A Data Warehouse
Logical Design For A Data Warehouse
Physical design For A Data warehouse
Lab: Implementing A Data Warehouse Schema
Module 4: Creating an ETL Solution with SSIS
Introduction To ETL With SSIS
Exploring Data Sources
Implementing Data Flow
Lab: Implementing Data Flow In An SSIS Package
Module 5: Implementing Control Flow In An SSIS Package
Introduction To Control Flow
Creating Dynamic Packages
Lab: Implementing Control Flow In An SSIS Package
Lab: Using Transactions And Checkpoints
Module 6: Debugging And Troubleshooting SSIS Packages
Debugging An SSIS Package
Logging SSIS Package Events
Handling Errors In An SSIS Package
Lab: Debugging And Troubleshooting An SSIS Package
Module 7: Implementing An Incremental ETL Process
Introduction To Incremental ETL
Extracting Modified Data
Loading Modified Data
Lab: Extracting Modified
DataLab: Loading Incremental Changes
Module 8: Enforcing Data Quality
Introduction To Data Quality
Using Data Quality Services To Cleanse Data
Using Data Quality Services To Match Data
DataLab: De-Duplicating Data
Module 9: Using Master Data Services
Master Data Services Concepts
Implementing A Master Data Services Model
Managing Master Data
Creating A Master Data Hub
Lab: Implementing Master Data Services
Module 10: Extending SQL Server Integration Services
Using Scripts In SSIS
Using Custom Components In SSIS
Lab: Using Custom Components And Scripts
Module 11: Deploying And Configuring SSIS Packages
Overview Of SSIS Deployment
Deploying SSIS Projects
Planning SSIS Package Execution
Lab: Deploying And Configuring SSIS Packages
Module 12: Consuming Data In A Data Warehouse
Introduction To Business Intelligence
Introduction To Reporting
An Introduction To Data Analysis
Lab: Using Business Intelligence Tools
You will learn how to create a data warehouse with Microsoft SQL Server® 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
This interactive training session can be taken from any location, your office or home and is delivered virtually by a tutor. Virtual students do not need to travel for the training course and Purple Griffon will send you all of the information needed before the start of the training course so you can test your login details.
The Implementing A Data Warehouse With Microsoft SQL Server® (SSIS) training course is intended for Database Professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing. Primary responsibilities include:
Security: SQL Server provides two security models including integration with Windows Authentication to provide robust security platform for managing your organisations information. Security can be managed across all database objects including tables, views, stored procedures and at a very granular level, to provide complete information security. Database encryption is now available as well to secure SQL Server database at rest.
Scalability: SQL Server is a highly scalable enterprise database platform capable of managing petabytes of data while delivery high performance. This allows organisations to deploy SQL Server databases with the confidence that SQL Server can continue to deliver superior performance even as their needs and businesses grow.
High Availability/Failover: SQL Server provides a variety of high availability features including fail over clustering available on the Standard and Enterprise editions, database mirroring, log shipping, and database snapshots to meet your organisations' needs.
Business Intelligence: SQL Server Standard and Enterprise Editions come with extensive business intelligence capabilities through SQL Server Analysis Services. Analytical models can be developed to breakdown business information to provide business insights for managing and forecasting business needs. SQL Server also comes with integrated reporting capabilities from SQL Server Reporting Services which allows organisations to access business critical information across the organisation. In more recent versions of SQL Server, PowerPivot for Microsoft Excel has been added to allow users another familiar tool for analysing business data.
Integration: SQL Server provides a robust set of integration tools call SQL Server Integration Services (SSIS) which can be used consolidate data from multiple heterogenous data sources for holistic data view and comprehensive data analysis. SSIS can also be used to migrate data from other database formats (Oracle, DBase, Paradox, legacy formats, Microsoft Access) to SQL Server.
The Implementing A Data Warehouse With Microsoft SQL Server® (SSIS) training course will keep your personal or professional skills up to date.
The Implementing A Data Warehouse With Microsoft SQL Server® (SSIS) training course requires you to have at least two years’ experience of working with relational databases, including:
There is no official prereading with the Implementing A Data Warehouse With Microsoft SQL Server® (SSIS) training session.
The Implementing A Data Warehouse With Microsoft SQL Server® (SSIS) training course helps you prepare for the Microsoft Implementing a Data Warehouse With Microsoft SQL Server 2012/2014 examination. The examination measures your ability to accomplish the technical tasks listed below:
The Implementing A Data Warehouse With Microsoft SQL Server® (SSIS) training course will give you credit towards the MCP, MCSA, MCSE certifications.
The five day Implementing Data Models & Reports With SQL Server 2014 training course focuses on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft® SQL Server® Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining.
The Implementing A Data Warehouse With Microsoft SQL Server® (SSIS) training course is part of the Microsoft Certification Path and can help you prepare for your MCSA Certification, MCSE Certification or MCSD Certification.