Enquire Now
Menu
£199 £49 (inc. VAT)

Buy Now

Add To Cart

  • 365 Days
  • , ,
  • Course Certificate
  • Awarded by 'Microsoft'
  • 08Guided Learning Hours
  • 14 Number of Modules
  • Course Material
  • Mock Exam
  • Official Exam

Overview:

Microsoft has a range of official exams designed for IT professionals who want to get certified, and Global Edulink provides excellent training, which will enable you to pass your chosen exam. If you hope to take the Microsoft Implementing a Data Warehouse with SQL Server 2012 – Exam 70 – 463, then this is the course for you. Our course material is delivered straight to you and is perfectly tailored to help you pass the exam with flying colours.

Learning with Global Edulink has many advantages. The course material can be adapted to fit in with your lifestyle. It is created by experts within the industry, meaning you are receiving accurate information, which is up-to-date and easy to understand.

This course is comprised of professionally narrated e-Learning modules, interactive quizzes, tests and exams. All delivered through a system that you will have access to 24 hours a day, 7 days a week for 365 days (12 months). An effective support service and study materials will build your confidence to secure your qualification.

Course Objectives:

During this course you will learn to:

  • Design and implement a data warehouse (10–15%)
  • Extract and transform data (20–25%)
  • Load data (25–30%)
  • Configure and deploy SSIS solutions (20–25%)
  • Build data quality solutions (15–20%)

Who is it for:

  • This course is aimed at IT Professionals who wish to gain Microsoft Certification

Course Description:

This online training course is comprehensive and designed to cover the topics listed under the curriculum.

Method of Assessment:

This course is assessed by the Microsoft Implementing a Data Warehouse with SQL Server 2012 – Exam 70 – 463, which will test your knowledge of the course objectives listed above.

For further details about the exam, please visit: https://www.microsoft.com/en-gb/learning/exam-70-463.aspx.

Please Note: official exams are not included in this course and need to be purchased it separately.

Certification:

Learners who successfully complete the exam will be awarded an official Microsoft Implementing a Data Warehouse with SQL Server 2012 –70 – 463 certificate.

Entry Requirements:

Learners must be over the age of 16.

Learners must have a basic understanding of the English Language, mathematics and IT.

This exam is primarily intended for ETL and data warehouse developers who create Business Intelligence (BI) solutions, and whose responsibilities include data cleansing, and Extract Transform Load and data warehouse implementation.

Career Path:

On the completion of this course, you will walk away with all the necessary knowledge and skills needed to take the official Microsoft exam, which is sure to enhance your resume for many job opportunities in the IT industry. You can also use this course to progress substantially within your career by winning the various job incentives put forth by your organisation. Below mentioned are some of the job roles this course will be worthwhile in, along with the average UK salary per annum according to https://www.payscale.com,

  • Configuration Manager – £37,654 Per annum
  • Network Analyst – £30,155 Per annum
  • Network Manager – £30,790 Per annum
  • Network Administrator – £25,235 Per annum

Course Curriculum

module 1 - an introduction to sql server data warehousing concepts
Module 1 – An Introduction to SQL Server Data Warehousing Concepts 00:52:00
module 2 - how to create dimensions and change granularity of dimensions
Module 2 – How to Create Dimensions and Change Granularity of Dimensions 00:40:00
module 3 - creating a columnstore index for fact tables
Module 3 – Creating a ColumnStore Index for Fact Tables 00:26:00
module 4 - implementing data warehouse in sql server
Module 4 – Implementing Data Warehouse in SQL Server 00:24:00
module 5 - working with sql server integration services
Module 5 – Working with SQL Server Integration Services 00:44:00
module 6 - regulating the control flow
Module 6 – Regulating the Control Flow 00:32:00
module 7 - working with variables in sql server
Module 7 – Working with Variables in SQL Server 00:54:00
module 8 - managing data flow
Module 8 – Managing Data Flow 01:06:00
module 9 - data flow management
Module 9 – Data Flow Management 00:23:00
module 10 : how to manage ssis package execution
Module 10 How to Manage SSIS Package Execution 00:21:00
module 11 - troubleshooting and debugging errors
Module 11 Troubleshooting and Debugging Errors 00:19:00
module 12 - how to deploy packages ?
Module 12 How to Deploy Packages ? 00:12:00
module 13 - securing the content of packages and databases
Module 13: Securing the Content of Packages and Databases 00:08:00
module 14 - how to handle mds and windows?
Module 14: How to Handle MDS and Windows? 00:04:00
mock exam
Mock Exam : Microsoft Implementing a Data Warehouse with SQL Server 2012 – Exam 70 – 463 00:40:00
£199 £49 (inc. VAT)

Buy Now

Add To Cart

  • 365 Days
  • , ,
  • Course Certificate
  • Awarded by 'Microsoft'
  • 08Guided Learning Hours
  • 14 Number of Modules
  • Course Material
  • Mock Exam
  • Official Exam

Inquiry Now

  • By submitting your information, you agree to the terms and conditions stated in our privacy policy.
Call Back

464 STUDENTS ENROLLED

Buy with Confidence

UKRLP


cv All students enrolled with Global Edulink are entitled to a CV Writing and Interview Skills Pack, which includes CV templates, cover letter guidance, and advice for interviews. MORE INFO
cv If you need career support Global Edulink is here for you. We provide excellent career support through our Career Support Service.
MORE INFO

Paypal Credit

NUS Extra Card

NUS Extra Card Every student of Global Edulink is eligible to apply for an NUS Extra card, allowing you to enjoy great saving by top brands on the high-street and online.

Course Reviews

4

4
1 ratings
  1. mikilon jece

    good course

    Very good hands on examples to go along with the 70-463 Training Kit for prep for the exam.

    4

Popular Courses

Effective CV Writing – Online
Overview: A decent CV and...
  • 365 Days
  • ACCREDITED BY CPD & iAP
5
£199 £49 (inc. VAT)
Teaching Assistant: Level 3 Award in Supporting Teaching and Learning in Schools
Overview: This excellent NCFE CACHE...
  • 180 Days
  • Awarded by 'NCFE CACHE'
5
Price Options +
£499 £249 (inc. VAT)
or only £59 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £59.00 (Inc. VAT)
Awarding Body Registration:

£69.00 (Inc. VAT)

Assessment: £139.00 (Inc. VAT)

(Pay in 04 Installments)

Total Price: £267.00 (Inc. VAT)
Health & Safety for Food Manufacturing – Level 2
Overview The Health & Safety...
  • 365 Days
  • Awarded by 'CIEH'
5
£119 £28 (inc. VAT)
Level 3 Certificate in Teaching Assistant – Children and Young individual’s Positive Behaviour
Overview Children and Young Individual’s...
  • 365 Days
  • Awarded by 'ABC Awards'
5
Price Options +
£349 £129 (inc. VAT)
or only £49 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £49.00 (Inc. VAT)
Assessment: £89.00 (Inc. VAT)

(Pay in 06 Installments)

Total Price: £138.00 (Inc. VAT)
Diploma in Modern Disinfection – Level 4
Overview The Diploma in Modern...
  • 365 Days
  • Awarded by 'ABC Awards'
5
Price Options +
£469 £269 (inc. VAT)
or only £99 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £99.00 (Inc. VAT)
Assessment: £179.00 (Inc. VAT)

(Pay in 05 Installments)

Total Price: £278.00 (Inc. VAT)
Professional Receptionist Training
Overview As a Receptionist, you...
  • 365 Days
  • ACCREDITED BY CPD & iAP
5
£199 £49 (inc. VAT)
Diploma in Health Science-Level 3 
  Develop a thorough understanding...
  • 365 Days
  • ACCREDITED BY CPD & iAP
5
£299 £59 (inc. VAT)
Microsoft Access 2010 – Advanced
Are you an IT professionals?...
  • 365 Days
  • ACCREDITED BY CPD & iAP
5
£199 £49 (inc. VAT)
Advanced Diploma in Dog Behaviour and Training – Level 3
Overview: Build a strong bond...
  • 365 Days
  • Awarded by 'ABC Awards'
5
Price Options +
£429 £229 (inc. VAT)
or only £79 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £79.00 (Inc. VAT)
Assessment: £159.00 (Inc. VAT)

(Pay in 03 Installments)

Total Price: £238.00 (Inc. VAT)
Level 7 Award in Coaching and Mentoring
Overview The Level 7 Award...
  • 365 Days
  • CMI
5
Price Options +
£999 £599 (inc. VAT)
or only £99 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £99.00 (Inc. VAT)
Awarding Body Registration:

£139.00 (Inc. VAT)

Assessment: £369.00 (Inc. VAT)
Total Price: £607.00 (Inc. VAT)
Diploma in Study Skills – Level 3
Overview Not every student knows...
  • 365 Days
  • Awarded by 'ABC Awards'
5
Price Options +
£429 £229 (inc. VAT)
or only £79 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £79.00 (Inc. VAT)
Assessment: £159.00 (Inc. VAT)

(Pay in 05 Installments)

Total Price: £238.00 (Inc. VAT)
Diploma in Safeguarding Children and Young People – Level 3
Overview The term safeguarding refers...
  • 365 Days
  • Awarded by 'ABC Awards'
5
Price Options +
£429 £229 (inc. VAT)
or only £79 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £79.00 (Inc. VAT)
Assessment: £159.00 (Inc. VAT)

(Pay in 02 Installments)

Total Price: £238.00 (Inc. VAT)
Diploma in Basic Chemistry – Level 3
Overview The Diploma in Basic...
  • 365 Days
  • Awarded by 'ABC Awards'
5
Price Options +
£429 £229 (inc. VAT)
or only £79 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £79.00 (Inc. VAT)
Assessment: £159.00 (Inc. VAT)

(Pay in 05 Installments)

Total Price: £238.00 (Inc. VAT)
CAPM® – Certified Associate in Project Management
Overview: If you wish to become...
  • 365 Days
  • Awarded by 'PMI'
5
£249 £69 (inc. VAT)
Diploma in Advanced Management Skills – Level 3
Overview: Global Edulink, a key...
  • 365 Days
  • ACCREDITED BY CPD & iAP
5
£399 £199 (inc. VAT)
Diploma in Marketing for Business – Level 3
Need to get ahead in...
  • 365 Days
  • ACCREDITED BY CPD & iAP
5
£399 £59 (inc. VAT)
Fundamentals of Human Molecular Genetics
Overview: Since we’ve been able...
  • 365 Days
  • ACCREDITED BY CPD & iAP
5
£199 £39 (inc. VAT)
Diploma in Business Management – Level 3
Overview: Whether you want to...
  • 365 Days
  • Awarded by 'ABC Awards'
5
Price Options +
£429 £229 (inc. VAT)
or only £79 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £79.00 (Inc. VAT)
Assessment: £159.00 (Inc. VAT)

(Pay in 02 Installments)

Total Price: £238.00 (Inc. VAT)
Principles of Manual Handling – Level 2
Overview Incorrect manual handling is...
  • 365 Days
  • Awarded by 'CIEH'
5
£119 £28 (inc. VAT)
Level 3 Certificate in Teaching Assistant – Professional Relationships
Overview It is healthy and...
  • 365 Days
  • Awarded by 'ABC Awards'
5
Price Options +
£349 £129 (inc. VAT)
or only £49 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £49.00 (Inc. VAT)
Assessment: £89.00 (Inc. VAT)

(Pay in 05 Installments)

Total Price: £138.00 (Inc. VAT)
Diploma in Mastering Thinking Skills Level 4
Overview Do you want to...
  • 365 Days
  • Awarded by 'ABC Awards'
5
Price Options +
£469 £269 (inc. VAT)
or only £99 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £99.00 (Inc. VAT)
Assessment: £179.00 (Inc. VAT)

(Pay in 04 Installments)

Total Price: £278.00 (Inc. VAT)
Educational Psychology
Overview: Educational Psychology is a...
  • 365 Days
  • ACCREDITED BY CPD & iAP
5
£249 £69 (inc. VAT)
Windows 10 Training
Overview If you want to...
  • 365 Days
  • ACCREDITED BY CPD & iAP
5
£199 £49 (inc. VAT)
Teaching Assistant: Level 3 Certificate in Supporting Teaching & Learning in Schools
Overview: This NCFE CACHE Level...
  • 365 Days
  • Awarded by 'ncfe'
5
Price Options +
£699 £349 (inc. VAT)
or only £89 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £89.00 (Inc. VAT)
Awarding Body Registration:

£119.00 (Inc. VAT)

Assessment: £199.00 (Inc. VAT)

(Pay in 11 Installments)

Total Price: £407.00 (Inc. VAT)
Diploma in Teaching Assistant – Level 3
Overview Do you love to...
  • 365 Days
  • Awarded by 'ABC Awards'
5
Price Options +
£429 £229 (inc. VAT)
or only £79 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £79.00 (Inc. VAT)
Assessment: £159.00 (Inc. VAT)

(Pay in 03 Installments)

Total Price: £238.00 (Inc. VAT)
Level 3 Certificate in Teaching Assistant – Working in Schools Environment
Overview While there are many...
  • 365 Days
  • Awarded by 'ABC Awards'
5
Price Options +
£349 £129 (inc. VAT)
or only £49 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £49.00 (Inc. VAT)
Assessment: £89.00 (Inc. VAT)

(Pay in 04 Installments)

Total Price: £138.00 (Inc. VAT)
Level 3 Certificate in Teaching Assistant – Support Learning Activities
Overview Support Learning Activities - Certificate...
  • 365 Days
  • Awarded by 'ABC Awards'
5
Price Options +
£349 £129 (inc. VAT)
or only £49 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £49.00 (Inc. VAT)
Assessment: £89.00 (Inc. VAT)

(Pay in 05 Installments)

Total Price: £138.00 (Inc. VAT)
Diploma in Basic Concrete – Level 3
Overview Diploma in Basic Concrete...
  • 365 Days
  • Awarded by 'ABC Awards'
5
Price Options +
£429 £229 (inc. VAT)
or only £79 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £79.00 (Inc. VAT)
Assessment: £159.00 (Inc. VAT)

(Pay in 04 Installments)

Total Price: £238.00 (Inc. VAT)
Complete Cisco Networking Course Bundle
Overview: Certifications such as this...
  • 365 Days
  • Awarded by "CISCO"
5
Price Options +
£799 £149 (inc. VAT)
or only £33 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Deposit: £33.00
Monthly: £29.00
No of Installments: 4
Total Price: £119.00( Inc. VAT)
Diploma in Health and Mindfulness – Level 3
Gain a holistic view of...
  • 365 Days
  • ACCREDITED BY CPD & iAP
5
£399 £59 (inc. VAT)
Load More