- +1 855.488.5327
- customerservice@ituonline.com
- Mon - Fri: 9:00am - 5:00pm ET
Microsoft 70-463: Implementing a Data Warehouse with SQL Server
Take an extra 30% off this course! No coupon needed; auto applies in cart.
$20.00
Sale Ends Soon
- 00Days
- 00Hours
- 00Minutes
- 00Seconds
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.
6 Training Hours
69 Videos
14 Topics
101 Practice Questions
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.
Your 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.
Course Outline
Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012 Course Outline
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
Microsoft 70-463: Implementing a Data Warehouse with SQL Server
$20.00
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.
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
$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
$10.00
In this course you will learn how to create managed enterprise BI solutions. You will learn how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining. This course will also teach you how to create BI solutions that require implementing multi-dimensional data models, implementing and maintaining OLAP cubes, and creating information displays used in business decision making.
$49.00
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
Cascading Style Sheets (CSS) provides the ability to create visually pleasing and sophisticated websites. In this CSS3 Training course, users at all levels will be instructed on how to use it effectively with ease.
$49.00
In this course you will learn how to start building enterprise web applications. This course will provide you with training in web development, C Sharp, HTML and CSS, SQL Server, JavaScript, Object Based JavaScript, Model View and Controller, and jQuery.