Microsoft SQL Server 2012 Certification Training Exam 70-463
4.2 (83 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,529 students enrolled
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
4.2 (83 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,529 students enrolled
Created by Infinite Skills
Last updated 1/2017
English
Current price: $10 Original price: $50 Discount: 80% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 7 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • To Study And Pass The Microsoft 70-463 Exam and Gain Certification For MCSA or MCSE
View Curriculum
Requirements
  • A desire to learn
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.

Who is the target audience?
  • IT Professionals who wish to gain Microsoft Certification
Students Who Viewed This Course Also Viewed
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
06:20

0202 Data Warehouse Challenges - Physical
04:52

0203 Data Warehouse Architectures
07:13

0204 Data Warehouse Appliances
04:03
+
Designing And Implementing A Data Warehouse
4 Lectures 24:11
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
+
Design And Implement A Data Warehouse Schema
6 Lectures 44:46
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
+
Control Flows And SSIS Package
7 Lectures 48:53
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
+
Debugging And Troubleshooting SSIS Packages
6 Lectures 38:06
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
+
Incremental ETL Process
6 Lectures 51:16
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
+
Enforcing Data Quality
7 Lectures 52:16
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
+
Master Data Services
3 Lectures 24:45
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
+
Extending SSIS
3 Lectures 21:17
1001 Custom SSIS Components
05:43

1002 Scripting And SSIS - Part 1
07:17

1003 Scripting And SSIS - Part 2
08:17
3 More Sections
About the Instructor
Infinite Skills
4.4 Average rating
37,992 Reviews
688,529 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.