XpertSkills - the parent company under which iCollege operates - was established in South Africa in 2003 and since then, we have grown globally in leaps and bounds with customers and partners in more than 120 countries. With employees on 3 continents and as a next-generation, virtual organization we are unconstrained by the limits that are usually associated with traditional “brick & mortar” companies.
This allows us to focus, without distraction, on reaching our ultimate goal – ensuring your ongoing success – by providing affordable, reliable, high quality and relevant learning products whilst remaining innovative and agile.
Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com
Head Office - South Africa
16 Monte Carlo Crescent
Kyalami business Park
Johannesburg
South Africa 1684
Head Office - South Africa 16 Monte Carlo Crescent Kyalami business Park Johannesburg South Africa 1684 Mail: info@icollege.co
We create the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed.
Module 1: Introduction to Data Warehouses
1.1 Overview of Data Warehouses
1.2 Examine Data Warehousing Concepts
1.3 Introduction to Data Analysis and Reporting Concepts
Module 2: Creating Dimensions and Changing Granularity of Dimensions
2.1 Create Dimensions
2.2 Change Granularity
Module 3: Creating Fact Tables and Columnstore Indexes
3.1 Create Fact Tables
3.2 Create Columnstore Indexes
Module 4: Implementing Data Warehouses in SQL Server 2012
4.1 Overview of Data Warehouse Components
4.2 Install Integration Services
Module 5: Working with Integration Services
5.1 Create an SSIS Project
5.2 Add Packages to an SSIS Project
Module 6: Managing Control Flow
6.1 Deploy a Control Flow
6.2 Execute Packages from Different Control Flow
Module 7: Working with Dynamic Variables
7.1 Create Expressions with Variables
7.2 Create Package Templates
Module 8: Implementing Data Flow
8.1 Add Data Flow Components to a Data Flow Task
8.2 Perform Transformation Tasks
8.3 Track Changed Data
Module 9: Managing Data Flow
9.1 Add Script Tasks and Script Components to an SSIS Package
9.2 Profile OLTP Data
9.3 Cleanse Data Using DQS
Module 10: Managing SSIS Package Execution
10.1 Execute SSIS Packages on the Server
10.2 Configure the Package Execution Strategy
Module 11: Debugging and Troubleshooting Packages
11.1 Debug Package Execution Components
11.2 Troubleshoot Package Failures
Module 12: Deploying Packages
12.1 Deploy SSIS Packages
12.2 Examine MSI Packages
Module 13: Securing Packages and Databases
13.1 Secure Packages
13.2 Secure Databases
Module 14: Working with MDS and Windows Azure
14.1 Configure MDS
14.2 Work with MDS Databases
14.3 Work with Windows Azure
