Microsoft SQL Server 2012 Certification Training Exam 70-463

Study For Implementing a Data Warehouse with Microsoft SQL Server 2012 (Exam 70-463) Training
4.0 (56 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,302 students enrolled
$19
$50
62% off
Take This Course
  • Lectures 62
  • Length 7 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2013 English

Course Description

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.

What are the requirements?

  • A desire to learn

What am I going to get from this course?

  • To Study And Pass The Microsoft 70-463 Exam and Gain Certification For MCSA or MCSE

What is the target audience?

  • IT Professionals who wish to gain Microsoft Certification

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction Data Warehousing 2012
Important - Working Files - Download These First
Preview
Article
0101 What You Will Learn
Preview
03:06
0102 Data Warehouse Concepts And Architecture
Preview
05:10
0103 Data Warehouse Solutions
Preview
05:07
Section 2: Data Warehouse Hardware
0201 Data Warehouse Challenges - Memory
06:20
0202 Data Warehouse Challenges - Physical
04:52
0203 Data Warehouse Architectures
07:13
0204 Data Warehouse Appliances
04:03
Section 3: Designing And Implementing A Data Warehouse
0301 Data Warehouse Logical Design
07:19
0302 Data Warehouse Physical Design
08:28
0303 Exercise: Implementing A Data Warehouse Schema
02:05
0304 Solution For Implementing A Data Warehouse Schema
06:19
Section 4: Design And Implement A Data Warehouse Schema
0401 ETL And SSIS
10:14
0402 Defining A Data Source
07:32
0403 Implementing A Data Flow - Part 1
08:14
0404 Implementing A Data Flow - Part 2
09:03
0405 Exercise: Implementing A SSIS Package
03:38
0406 Solution For Implementing A SSIS Package
06:05
Section 5: Control Flows And SSIS Package
0501 Introduction To Control Flows
09:48
0502 Dynamic Packages
11:07
0503 Defining Containers - Part 1
06:55
0504 Defining Containers - Part 2
07:35
0505 Manage Consistency
06:19
0506 Exercise: Implement Control Flows In SSIS
02:51
0507 Solution For Implementing Control Flow SSIS
04:18
Section 6: Debugging And Troubleshooting SSIS Packages
0601 Debugging SSIS
09:35
0602 Error Log Providers
07:38
0603 Error Handling And SSIS - Part 1
07:57
0604 Error Handling And SSIS - Part 2
05:25
0605 Exercise: Debugging And Troubleshooting SSIS
02:53
0606 Solution For Debugging And Troubleshooting SSIS
04:38
Section 7: Incremental ETL Process
0701 Introduction To Incremental ETL Processes
09:50
0702 Extract Modified Data - Part 1
09:26
0703 Extract Modified Data - Part 2
07:09
0704 Load Modified Data
09:45
0705 Exercise: Load Incremental Data
05:09
0706 Solution For Incremental Load
09:57
Section 8: Enforcing Data Quality
0801 Data Cleansing
07:22
0802 Data Quality Services
06:55
0803 Data Quality Services And Matching Data
09:04
0804 Exercise Cleansing Data
04:30
0805 Solution For Cleansing Data
09:12
0806 Exercise: De-Duplicating Data
05:31
0807 Solution For De-Duplicating Data
09:42
Section 9: Master Data Services
0901 What Is Master Data Services
07:54
0902 Implementing Master Data Services
09:18
0903 Excel Add-In For Master Data Services
07:33
Section 10: Extending SSIS
1001 Custom SSIS Components
05:43
1002 Scripting And SSIS - Part 1
07:17
1003 Scripting And SSIS - Part 2
08:17
Section 11: Deploying SSIS Packages
1101 Overview Of SSIS Deployment
08:08
1102 Deploying SSIS Packages - Part 1
07:16
1103 Deploying SSIS Packages - Part 2
09:16
1104 Planning SSIS Package Execution
08:40
1105 Exercise: Deploying An SSIS Package
03:31
1106 Solution For Deploying SSIS Package
06:41
Section 12: Consuming Data
1201 Data Warehouse Using Excel
08:31
1202 Using PowerPivot And Data Warehouse
08:05
1203 Data Warehouse And SSRS
08:06
1204 Exercise: Using Excel And PowerPivot
03:02
1205 Solution For Excel And PowerPivot
05:38
Section 13: About The Author
1301 Learn About Me
02:03

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Infinite Skills, 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.

Ready to start learning?
Take This Course