MCSA: Data Warehouse Implementation Microsoft Sql 2012 (Exam 70-463)
Original price was: £295.00.£99.00Current price is: £99.00.
Course Description
Study247 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 the Microsoft 70-463 exam, known as Implementing a Data Warehouse with SQL Server 2012.
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.
Who is this course aimed at?
What is included in this course?
When you enrol, you’ll not only gain powerful, career-enhancing skills but also receive exclusive benefits, including:
Course Assessment Process
In order to earn your certification, you’ll have to sit an exam after completing your course with us. To prepare you for your exam, we provide interactive quizzes after each module and a mock exam at the end of your course to ensure you’re fully prepared for the real thing. Once you’ve passed with at least 85%, you’ll be ready to book your exam as a private candidate.
Booking your exam is pretty simple, just purchase your exam voucher and schedule your exam. To make life easier, we can help you find an appropriate exam centre and give you all the information you need to secure your place.
Please note that the exam fees aren’t included in the course price.
Got a question about exams? Contact one of our course advisors. We’re happy to help!
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.
Career Path
We’ve put together a list of relevant job titles you can apply for after achieving the MCSA: Data Warehouse Implementation Microsoft SQL 2012 (Exam 70-463) certification (note that some careers may require further study, training and/or work experience):
- Database Administrator
- Database Developer
- Database Analyst
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
Payment Options
Pay securely online by debit or credit card or PayPal. Buying for your team? Talk to us about team training.
Student Reviews
There are no reviews for this course yet.
