MCSA: Data Warehouse Implementation Microsoft SQL 2012
Course
Online
Description
-
Type
Course
-
Methodology
Online
-
Start date
Different dates available
"Course Description
The exam associated with this course will retire January 31, 2021. If you're preparing for this exam, you have until the retirement date to pass it.
My Training Academy's 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.
SQL Server business intelligence developers are rock stars in the eyes of an organization's decision makers. Managing and providing high-level data through a data warehouse helps businesses make accurate decisions that save time and money.
This course provides you with the skills you need to create and manage a data warehouse in SQL Server 2012. Learn how to design and implement a data warehouse, implement and automate an ETL solution using SQL Server Integration Services to load warehouse data, and utilize Master Data Services along with Data Quality Services to standardize, enrich, and evolve data over time.
Exam 70-463 is the final step toward attaining the Microsoft MCSA: SQL Server 2012 certification, which completes the pre-requisites toward both MCSE certifications: Data Platform and Business Intelligence. This course helps prepare you for the 70-463 exam and beyond with real-world examples and live demonstrations.
Who is this course for?
This course is targeted at database professionals whose primary duties involve installation, configuration, and maintenance tasks
Entry Requirements
The course has been designed to give you real-world knowledge that you can put to use from day one. It's highly flexible, so you can set your own timetable and study at your own pace - you can start learning right away.
"
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
- Data warehousing
- Windows
- Server
- SQL
- MCSA training
- MCSA
- Data analysis
- Design
- Warehousing
- Project
- Business Intelligence
- 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