Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Microsoft SQL Server 2012 Certification Training Exam 70-463 to your Wishlist.

Add to Wishlist

Microsoft SQL Server 2012 Certification Training Exam 70-463

Study For Implementing a Data Warehouse with Microsoft SQL Server 2012 (Exam 70-463) Training
3.8 (73 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,449 students enrolled
Last updated 7/2013
$10 $50 80% off
4 days left at this price!
30-Day Money-Back Guarantee
  • 7 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?

This Infinite Skills SQL Server 70-463 Exam training course will teach you everything you need to know to pass the Implementing a Data Warehouse with Microsoft SQL Server 2012 test. It is required that you pass the 70-463 exam in order to achieve your MCSA and MCSE certifications from Microsoft.

The course takes you through each of the topics that you will have to master to pass the SQL Server 2012 70-463 exam. Throughout this tutorial video, you will learn how to design and implement a data warehouse, extract and transform data, load data, configure and deploy SSIS solutions and build data quality solutions. Each topic is broken down into step-by-step lessons, allowing you to learn quickly, and retain what you learn more effectively.

Once you have completed this video based training course for the Microsoft SQL Server 70-463 Exam, you will have a comprehensive understanding of how to Implement a Data Warehouse with SQL Server 2012. You will be fully prepared to write, and pass, your 70-463 exam and continue towards earning your MCSA and MCSE certifications.

How to take the Microsoft 70-463 Exam:

1. Find a test center near you to take the SQL Server 70-463 certification exam, their will provide details on test center locations and schedules. This exam is typically priced around $150 dollars.

2. Study the required material to pass the 70-463 examination. This course covers the material that is within the 70-463 certification exam, and will help put you in a great position to succeed in the exam

3. Pass your exam!

4. Tell your friends how easy passing the Microsoft 70-463 exam was using Infinite Skills training courses

5 Take our Microsoft Windows Server 70-461 and 70-462 courses which will prepare you for the 70-461 and 70-462 exams. Upon passing the 70-461, 70-462, and 70-463 exams you will become a Microsoft Solutions Certified Associate in Microsoft SQL Server 2012.

The information laid out above is given in good faith, we are not endorsing and third party company by offering a link to their site. You should always do your own research prior to making a purchase or using any service linked to via this website. Prices or details may alter and any information listed can not be guaranteed to be accurate. Note: While this course is comprehensive in regards to covering material on the exam, we do recommend using other aids to guide your study.

Who is the target audience?
  • IT Professionals who wish to gain Microsoft Certification
Students Who Viewed This Course Also Viewed
What Will I Learn?
To Study And Pass The Microsoft 70-463 Exam and Gain Certification For MCSA or MCSE
View Curriculum
  • A desire to learn
Curriculum For This Course
Expand All 62 Lectures Collapse All 62 Lectures 07:00:19
Data Warehouse Hardware
4 Lectures 22:28
0201 Data Warehouse Challenges - Memory

0202 Data Warehouse Challenges - Physical

0203 Data Warehouse Architectures

0204 Data Warehouse Appliances
Designing And Implementing A Data Warehouse
4 Lectures 24:11
0301 Data Warehouse Logical Design

0302 Data Warehouse Physical Design

0303 Exercise: Implementing A Data Warehouse Schema

0304 Solution For Implementing A Data Warehouse Schema
Design And Implement A Data Warehouse Schema
6 Lectures 44:46
0401 ETL And SSIS

0402 Defining A Data Source

0403 Implementing A Data Flow - Part 1

0404 Implementing A Data Flow - Part 2

0405 Exercise: Implementing A SSIS Package

0406 Solution For Implementing A SSIS Package
Control Flows And SSIS Package
7 Lectures 48:53
0501 Introduction To Control Flows

0502 Dynamic Packages

0503 Defining Containers - Part 1

0504 Defining Containers - Part 2

0505 Manage Consistency

0506 Exercise: Implement Control Flows In SSIS

0507 Solution For Implementing Control Flow SSIS
Debugging And Troubleshooting SSIS Packages
6 Lectures 38:06
0601 Debugging SSIS

0602 Error Log Providers

0603 Error Handling And SSIS - Part 1

0604 Error Handling And SSIS - Part 2

0605 Exercise: Debugging And Troubleshooting SSIS

0606 Solution For Debugging And Troubleshooting SSIS
Incremental ETL Process
6 Lectures 51:16
0701 Introduction To Incremental ETL Processes

0702 Extract Modified Data - Part 1

0703 Extract Modified Data - Part 2

0704 Load Modified Data

0705 Exercise: Load Incremental Data

0706 Solution For Incremental Load
Enforcing Data Quality
7 Lectures 52:16
0801 Data Cleansing

0802 Data Quality Services

0803 Data Quality Services And Matching Data

0804 Exercise Cleansing Data

0805 Solution For Cleansing Data

0806 Exercise: De-Duplicating Data

0807 Solution For De-Duplicating Data
Master Data Services
3 Lectures 24:45
0901 What Is Master Data Services

0902 Implementing Master Data Services

0903 Excel Add-In For Master Data Services
Extending SSIS
3 Lectures 21:17
1001 Custom SSIS Components

1002 Scripting And SSIS - Part 1

1003 Scripting And SSIS - Part 2
3 More Sections
About the Instructor
4.4 Average rating
33,854 Reviews
665,451 Students
331 Courses
High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

Report Abuse