MCSA: Data Warehouse Implementation Microsoft SQL 2012 (Exam 70-463) with Practice Lab
Course
Online
Description
-
Type
Course
-
Methodology
Online
-
Start date
Different dates available
"Course Description
MCSA: Data Warehouse Implementation Microsoft SQL 2012 course introduces you to the key components of a data warehousing solution. The course provides learners with the technical skills required to design and implement a data warehouse. It also provides information on automating an ETL solution using SQL Server Integration Services. This course will help current and aspiring data professionals to prepare for exam 70-463, known as Implementing a Data Warehouse with SQL Server 2012.
As part of this course package, learners will also have access to an online Practice Lab to develop their practical skills whilst learning. Practice Labs makes studying for an exam or learning new technologies an engaging experience, as It offers:
Exam based practical tasks
Real equipment, absolutely no simulations
Access to the latest industry technologies
Available anytime, anywhere on any device
Break and Reset functionality
No hardware or licensing costs
Passing the Implementing a Data Warehouse with SQL Server 2012 (70-463) exam is a requirement to getting MCSA certified, which in turn is a prerequisite to achieving an MCSE certification."
Important information
Price for Emagister users:
Facilities
Location
Start date
Start date
About this course
"Requirements
Our training works on all devices including Mobile phones, IPad’s, Android tablets, Macs and PC’s.
For the best viewing experience on our state-of-the-art eLearning platform we recommend an internet connection of 10Mbps or better. Please also use Google Chrome or Mozilla Firefox as your browser with Adobe Flash Player."
Reviews
Subjects
- Access
- Data warehousing
- Windows
- Server
- SQL
- MCSA training
- MCSA
- Data analysis
- Warehousing
- Project
- Install
Course programme
Course Outline
Course Outline
Course Outline
Lesson 1: Introduction to Data Warehouses
- Topic A: Overview of Data Warehouses
- Topic B: Examine Data Warehousing Concepts
- Topic C: Introduction to Data Analysis and Reporting Concepts
Lesson 2: Creating Dimensions and Changing Granularity of Dimensions
- Topic A: Create Dimensions
- Topic B: Change Granularity
Lesson 3: Creating Fact Tables and Column store Indexes
- Topic A: Create Fact Tables
- Topic B: Create Column store Indexes
- Lesson 4: Implementing Data Warehouses in SQL Server 2012
- Topic A: Overview of Data Warehouse Components
- Topic B: Install Integration Services
Lesson 5: Working with Integration Services
- Topic A: Create an SSIS Project
- Topic B: Add Packages to an SSIS Project
Lesson 6: Managing Control Flow
- Topic A: Deploy a Control Flow
- Topic B: Execute Packages from Different Control Flow
Lesson 7: Working with Dynamic Variables
- Topic A: Create Expressions with Variables
- Topic B: Create Package Templates
Lesson 8: Implementing Data Flow
- Topic A: Add Data Flow Components to a Data Flow Task
- Topic B: Perform Transformation Tasks
- Topic C: Track Changed Data
Lesson 9: Managing Data Flow
- Topic A: Add Script Tasks and Script Components to an SSIS Package
- Topic B: Profile OLTP Data
- Topic C: Cleanse Data Using DQS
Lesson 10: Managing SSIS Package Execution
- Topic A: Execute SSIS Packages on the Server
- Topic B: Configure the Package Execution Strategy
Lesson 11: Debugging and Troubleshooting Packages
- Topic A: Debug Package Execution Components
- Topic B: Troubleshoot Package Failures
Lesson 12: Deploying Packages
- Topic A: Deploy SSIS Packages
- Topic B: Examine MSI Packages
Lesson 13: Securing Packages and Databases
- Topic A: Secure Packages
- Topic B: Secure Databases
Lesson 14: Working with MDS and Windows Azure
- Topic A: Configure MDS
- Topic B: Work with MDS Databases
- Topic C: Work with Windows Azure
Course Outline
Lesson 1: Introduction to Data Warehouses
Lesson 1: Introduction to Data Warehouses
- Topic A: Overview of Data Warehouses
- Topic B: Examine Data Warehousing Concepts
- Topic C: Introduction to Data Analysis and Reporting Concepts
Lesson 2: Creating Dimensions and Changing Granularity of Dimensions
Lesson 2: Creating Dimensions and Changing Granularity of Dimensions
- Topic A: Create Dimensions
- Topic B: Change Granularity
Lesson 3: Creating Fact Tables and Column store Indexes
Lesson 3: Creating Fact Tables and Column store Indexes
- Topic A: Create Fact Tables
- Topic B: Create Column store Indexes
- Lesson 4: Implementing Data Warehouses in SQL Server 2012
- Topic A: Overview of Data Warehouse Components
- Topic B: Install Integration Services
Lesson 5: Working with Integration Services
Lesson 5: Working with Integration Services
- Topic A: Create an SSIS Project
- Topic B: Add Packages to an SSIS Project
Lesson 6: Managing Control Flow
Lesson 6: Managing Control Flow
- Topic A: Deploy a Control Flow
- Topic B: Execute Packages from Different Control Flow
Lesson 7: Working with Dynamic Variables
Lesson 7: Working with Dynamic Variables
- Topic A: Create Expressions with Variables
- Topic B: Create Package Templates
Lesson 8: Implementing Data Flow
Lesson 8: Implementing Data Flow
- Topic A: Add Data Flow Components to a Data Flow Task
- Topic B: Perform Transformation Tasks
- Topic C: Track Changed Data
Lesson 9: Managing Data Flow
Lesson 9: Managing Data Flow
- Topic A: Add Script Tasks and Script Components to an SSIS Package
- Topic B: Profile OLTP Data
- Topic C: Cleanse Data Using DQS
Lesson 10: Managing SSIS Package Execution
Lesson 10: Managing SSIS Package Execution
- Topic A: Execute SSIS Packages on the Server
- Topic B: Configure the Package Execution Strategy
Lesson 11: Debugging and Troubleshooting Packages
Lesson 11: Debugging and Troubleshooting Packages
- Topic A: Debug Package Execution Components
- Topic B: Troubleshoot Package Failures
Lesson 12: Deploying Packages
Lesson 12: Deploying Packages
- Topic A: Deploy SSIS Packages
- Topic B: Examine MSI Packages
Lesson 13: Securing Packages and Databases
Lesson 13: Securing Packages and Databases
- Topic A: Secure Packages
- Topic B: Secure Databases
Lesson 14: Working with MDS and Windows Azure
Lesson 14: Working with MDS and Windows Azure
- Topic A: Configure MDS
- Topic B: Work with MDS Databases
- Topic C: Work with Windows Azure
"
MCSA: Data Warehouse Implementation Microsoft SQL 2012 (Exam 70-463) with Practice Lab