Lifetime
An ITU Online Training exclusive. The only Buy Once, Never Pay for IT training again program available. Plus, get all new and updated content for life.
- +1 855.488.5327
- customerservice@ituonline.com
- Mon - Fri: 9:00am - 5:00pm ET
Microsoft 70-463: Implementing a Data Warehouse
In this course you will learn how to create Business Intelligence (BI) solutions. This course will teach you how to implement a data warehouse platform to support a BI solution. You will learn how to create a data warehouse with Microsoft SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
Included In This Course
Included In This Course
6 Hrs 56 Min
69 On-demand Videos
Closed Captions
14 Topics
101 Prep Questions
Certificate of Completion
Course Description
Note: Although the associated examination for this course has been retired, it is a good resource for training.
About the current exam objectives
This Microsoft 70-463: Implementing a Data Warehouse with SQL Server exam is designed to assess the knowledge and skills of ETL and data warehouse developers who are responsible for developing Business Intelligence (BI) solutions, such as performing data cleansing tasks and implementing Extract Transform Load processes in a data warehouse.
This course is preparation for the 70-463 Implementing a Data Warehouse with SQL Server exam. The course covers topics that are featured on the exam, such as how to implement a data warehouse platform to support a BI solution, how to create a data warehouse with Microsoft SQL Server, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
Skills measured in exam questions
- 10–15% – Create and execute a data warehouse that exemplifies efficiency, performance, and scalability.
- 20–25% – Streamline your data by leveraging Extract and Transform capabilities. Quickly extract the most relevant information from multiple sources for advanced analytics, enabling you to make informed decisions about how best to utilize your resources.
- 25–30% – Upload data for processing and analysis.
- 20–25% Quickly and efficiently deploy SSIS solutions in order to get the most out of your business.
- 15–20% – Construct robust data integrity solutions that ensure accuracy, reduce errors and maximize efficiency.
Frequently Asked Questions About Microsoft 70-463: Implementing a Data Warehouse
What will I learn from the Microsoft 70-463: Implementing a Data Warehouse course?
You’ll learn how to create Business Intelligence (BI) solutions. The course teaches you how to implement a data warehouse platform to support a BI solution. You’ll also get the chance to learn how to create a data warehouse with Microsoft SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
How long is the course and what are the components?
The course is six training hours long. It consists of 69 videos and 14 topics, and it provides you with 101 practice questions.
How can I access the course?
The course is available through an All Access Monthly Subscription. This gives you access to over 2,500 hours of on-demand content. You can start a 7-day free trial with no obligation and you can cancel anytime.
I heard the associated exam has been retired. Is the course still relevant?
Yes, while the exam associated with this course has been retired, the course itself remains a valuable resource for training. It’s especially beneficial for ETL and data warehouse developers who are developing Business Intelligence (BI) solutions.
What skills are measured in the exam questions?
The exam measures your ability to create and execute a data warehouse that exemplifies efficiency, performance, and scalability.
Proudly DisplayYour Achievement
Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
Course Outline
Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012 Course Content
Lesson 1: Introduction to Data Warehouse
Introduction
Introduction To Data Warehouse-Part1
Introduction To Data Warehouse-Part2
Introduction To Data Warehouse-Part3
Introduction To Data Warehouse-Part4
Introduction To Data Warehouse-Part5
Introduction To Data Warehouse-Part6
Lesson 2: Creating Dimensions and Changing Granularity of Dimensions
Creating Dimensions And Changing Granularity Of Dimensions-Part1
Creating Dimensions And Changing Granularity Of Dimensions-Part2
Creating Dimensions And Changing Granularity Of Dimensions-Part3
Creating Dimensions And Changing Granularity Of Dimensions-Part4
Creating Dimensions And Changing Granularity Of Dimensions-Part5
Creating Dimensions And Changing Granularity Of Dimensions-Part6
Lesson 3: Creating Fact Tables and ColumnStore Indexes
Creating Fact Tables And Column Store Indexes-Part1
Creating Fact Tables And Column Store Indexes-Part2
Creating Fact Tables And Column Store Indexes-Part3
Creating Fact Tables And Column Store Indexes-Part4
Creating Fact Tables And Column Store Indexes-Part5
Lesson 4: Implementing Data Warehouse in SQL Server 2012
Implementing Data Warehouse-Part1
Implementing Data Warehouse-Part2
Implementing Data Warehouse-Part3
Implementing Data Warehouse-Part4
Lesson 5: Working with Integration Services
Working With Integration Services-Part1
Working With Integration Services-Part2
Working With Integration Services-Part3
Working With Integration Services-Part4
Working With Integration Services-Part5
Working With Integration Services-Part6
Lesson 6: Managing Control Flow
Managing Control Flow-Part1
Managing Control Flow-Part2
Managing Control Flow-Part3
Managing Control Flow-Part4
Managing Control Flow-Part5
Lesson 7: Working with Dynamic Variables
Working With Dynamic Variables-Part1
Working With Dynamic Variables-Part2
Working With Dynamic Variables-Part3
Working With Dynamic Variables-Part4
Working With Dynamic Variables-Part5
Working With Dynamic Variables-Part6
Working With Dynamic Variables-Part7
Working With Dynamic Variables-Part8
Lesson 8: Implementing Data Flow
Implementing DataFlow-Part1
Implementing DataFlow-Part2
Implementing DataFlow-Part3
Implementing DataFlow-Part4
Implementing DataFlow-Part5
Implementing DataFlow-Part6
Implementing DataFlow-Part7
Implementing DataFlow-Part8
Lesson 9: Managing Data Flow
Managing DataFlow-Part1
Managing DataFlow-Part2
Managing DataFlow-Part3
Managing DataFlow-Part4
Lesson 10: Managing SSIS Package Execution
Managing SSIS Package Execution-Part1
Managing SSIS Package Execution-Part2
Managing SSIS Package Execution-Part3
Managing SSIS Package Execution-Part4
Managing SSIS Package Execution-Part5
Managing SSIS Package Execution-Part6
Lesson 11: Debugging and Troubleshooting
Debugging And Troubleshooting-Part1
Debugging And Troubleshooting-Part2
Debugging And Troubleshooting-Part3
Debugging And Troubleshooting-Part4
Lesson 12: Deploying Packages
Deploying Packages-Part1
Deploying Packages-Part2
Deploying Packages-Part3
Lesson 13: Securing Packages and Databases
Securing Packages And Databases-Part1
Securing Packages And Databases-Part2
Lesson 14: Working with MDS and Windows
Working With MDS And Windows Azure
ITU OnlineYour Training Instructor
Rafiq has extensive experience including more than 20 years in IT as a Systems Architect, Software Engineer, DBA, and Project Manager. He has instructed in a variety of technical areas and has designed and implemented network and information systems. Bringing nearly 30 years of advanced IT experience to each course and adding his unique perspective and “real world” tips, Rafiq has a knack for making complex topics easy to understand.
Subscribe To All-Access
Lock In $14.99 / Month Forever
Start this course for free with our 10-day trial of the all-access subscription providing access to over 2,600 hours of training.
$49.00 $14.99 Monthly
OR
$49.00
Microsoft 70-463: Implementing a Data Warehouse
Microsoft 70-463: Implementing a Data Warehouse
Additional Options to Access This Training
This training is also part of our extensive training library containing over 225 courses, 12,000+ videos and over 19,000 practice test questions.
Monthly All-Access Subscription
7 Days Free - $39.00 / month
A great option at an affordable monthly price.
Annual All-Access Subscription
$229 / year
A discounted price when paying for your All Access library on an annual basis.
Lifetime All-Access Library
$379 One time payment
Exceptional Value. Pay once, never have to buy IT training again.
Related Courses
$49.00
Master the skills to effectively manage SQL Server with our Microsoft 70-764 training course. Get started today!
The Microsoft 70-764 SQL Server 2016 Administration course is designed to equip students with all the skills and knowledge necessary for them to confidently pass the Microsoft Certification Exam 70-764. By mastering this program, learners will be fully capable of administering a complete Microsoft SQL 2016 server solution – from installation through maintenance tasks.
$49.00
Take your SQL Server skills to the next level with ITU Online’s Microsoft 70-464: Developing Microsoft SQL Server Databases course. Enroll today!
In this course you will learn logical table design, indexing and query plans. This course focuses on the creation of database objects including views, stored procedures, parameters and functions. Common aspects of procedure coding such as indexes, concurrency, error handling, and triggers are also covered in this course. This course will also teach you how to optimize indexes, ensure data integrity, implement views, stored procedures and functions as well as manage transactions and locks.
$49.00
Boost your career with our comprehensive Microsoft 70-487 online course on developing Azure and web services.
In this Microsoft 70-487 course you will learn how to access data, query and manipulate data by using the entity framework, create and consume web API-based services, design and implement web services, and deploy in Microsoft Azure and Web Services.
