Course Name Location Price Start Date Duration Enquire Order
Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012 £11.99 EnquireOrder Now

Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012 Training Course


9k learners

This course serves professionals interested in creating business intelligence solutions, data warehousing and ETL. It prepares participants to measure their knowledge and skills in rendering effective decisions on implementing Data warehouse in Microsoft SQL Server 2012.

Key Features

  • 1-year e-learning access

  • Course completion certificate

  • 100% money back guarantee

The Microsoft 70-463 exam is meant for people working in SQL Server Database administrators, System engineers and experienced Data Warehouse developers. This exam tests their skills and knowledge of writing queries. Here we bring you the best in a class course that prepares you for taking up the Microsoft 70-463 exam.

Implementing a Data Warehouse with Microsoft SQL Server 2012
Course Introduction
Course Modules
Module 1
Introduction to Data Warehousing
OLTP vs. OLAP Part1
OLTP vs. OLAP Part2
Data Warehouse
Data Warehouse Architecture
Creating a Data Warehouse Part1
Creating a Data Warehouse Part2
Presenting OLAP Data
OLTP & OLAP Comparison Demonstration Part2
OLTP & OLAP Comparison Demonstration Part1
Exam Scenarios
Module Review
Module 2
Designing a Data Warehouse
Data Modeling
Data Warehouse Schemas
Time Dimensions
Data Modeling Considerations Part1
Data Modeling Considerations Part2
Implementing a Data Model
Logical Model
Physical Model
Dimensions and Facts Part1
Dimensions and Facts Part2
Exam Scenarios Part1
Exam Scenarios Part2
Module Review
Module 3
Introduction to SSIS
Upgrading SSIS Packages
SSIS Tools
Data Flow Tasks
Data Sources
Utilizing SQL Server Data Tools
Data Flow Task Part1
Data Flow Task Part2
Exam Scenarios
Module Review
Module 4
SSIS Control Flow
Control Flow Tasks
Integration Services Variables
Containers and Annotation
Control Flow Tasks & Precedence Part3
Control Flow Tasks & Precedence Part4
Control Flow Tasks & Precedence Part1
Control Flow Tasks & Precedence Part2
Exam Scenarios
Module Review
Module 5
Troubleshooting Packages
Overview of Troubleshooting
Debugging Part1
Debugging Part2
Error Handling
SSIS Log Providers
Custom Logging
Troubleshooting and Logging Part1
Troubleshooting and Logging Part2
Troubleshooting and Logging Part3
Exam Scenarios
Module Review
Module 6
Advanced Packages
Maintaining a Data Warehouse
Change Data Capture
Slowly Changing Dimensions
Script Components
Incremental Updates Part2
Incremental Updates Part1
Exam Scenarios Part1
Exam Scenarios Part2
Module Review
Module 7
Data Quality Services
Introduction to Data Quality Services
Data Quality Services Components
Working with Data Quality Services Part1
Working with Data Quality Services Part2
Working with Data Quality Services Part3
Exam Scenarios
Module Review
Module 8
Master Data Services
Introduction to Master Data Services
How MDS Works
Exam Scenarios
Module Review
Module 9
Deployment and Security
Deployment Options
Package Deployment
Securing Packages
Deploying SSIS Packages & Projects Part1
Deploying SSIS Packages & Projects Part2
Exam Scenarios
Module Review
Program Review


Eligibility criteria for CISSP

  • Applicants must have at least five years of paid work experience acquired in 2 or more domains of the CISSP Common Body of Knowledge. Obtaining a 4-year college degree or regional equivalent or an additional credential from the list approved by (ISC)² will serve as 1 year of the experience required. Education credit will satisfy only 1 year of experience.
  • An applicant who does not have the experience required to become a CISSP can become an Associate of (ISC)² by passing the CISSP exam successfully. Then, the candidate will have 6 years to earn the 5 years experience required.

Certified Information Systems Security Professional.Not to be confused with CISSP Program Concentrations.

Intermediate - Professional. Base certification isAssociate of (ISC)2


  1. Exam Duration: 6 hours.
  2. Number of questions: 250.
  3. Question format: Multiple choice and advanced innovative questions.

Industry sector(s): 

  • Information Technology
  • Information Security Designations
  • Security Consultant
  • Security Analyst
  • Security Manager
  • Security Systems Engineer
  • Security Auditor
  • Security Architect
  • Network Architect
  • Director of Security
  • IT Director/Manager
  • Chief Information Security Officer

Official (ISC)² Guide to the CISSP CBK, Fourth Edition. Hardcover, iTunes, Kindle versions. Kindle version @ $56 (Amazon)

The additional aids endorsed by (ISC)²

  • Official (ISC)² CISSP Study Guide (Wiley). - Hardcover, e-Book. Kindle eBook @ $7.76
  • Official (ISC)² CISSP Practice Tests (Wiley). - Hardcover, e-Book. Kindle eBook @ $8.0 
  • CISSP for Dummies (Wiley). Paperback, Kindle. Kindle version @ $5.0 
  • Official CISSP Study App. Android, iOS versions. Individually @ <$10

8 Domain Areas -

  • Security & Risk Management
  • Asset Security
  • Security Engineering
  • Communications & Network Security
  • Identity & Access Management
  • Security Assessment & Testing
  • Security Operations
  • Software Development Security

Note: CBK = Common Body of Knowledge

For all variants - Online Self-learning, Live Online, In-person Classroom

  • Immediately when you register: An automated email with your receipt and your access credentials (online self-learning component) is sent to your registered email ID.

    For Live Online and In-person Classrooms*

  • The next working day: You receive a welcome email directly from the training coordinator managing the specific workshop you've registered for.

  • 3 working days before the workshop start date: You receive a reminder from the training coordinator about the upcoming training.
  • On the workshop start date (1 hour before starting off): Your training coordinator attempts to reach you to check if you're having issues in reaching the location/ logging in online.
  • Last day of the workshop: Your training coordinator reminds you to leave your feedback for the training.
  • 1 working day from the last day of the workshop: Your training coordinator reaches out to you with the next steps, like how to download your certificate(s) and how to avail the post-training helpline (as applicable).

*Note: The overall process may have some variations based on your location/ Country and the specific course/ variant you opt for.

Recertification process for CISSP credential

  • Requirement: 40 Continuing Professional Education (CPE) credits each year for 3 years, and a total of 120 CPE credits for the 3 year period.
  • Fee payable: US $85 each year, billed at the end of a 3-year cycle. Failure to meet CPE requirements results in ‘suspension’ status for 90 days. Failure to meet CPE requirements within the Suspension period results in decertification.

The process of getting a CISSP certification is:

Step 1: Register with Pearson Vue and book an exam ((ISC)² membership recommended).

Step 2: Review background questions, Agree to the Code of Ethics and Pass the exam.

Step 3: Complete Endorsement process (membership required). A current & active (ISC)² certified professional (any certification) must complete an online Endorsement Form. This needs to be done within 9 months from the exam date. After this, the exam needs to be re-taken. Alternatively, a candidate can opt for theAssociate of (ISC)2within this period.

Step 4 (Optional): On submission of the endorsement form, the candidate may be selected randomly for an audit. If so, the candidate needs to submit additional information as required before certification is granted.

Online Self-Learning courses have a 3-day refund policy. If you are not satisfied with the course and report this over an email to within 3 days from the date of purchase, we will refund the entire amount.

This guarantee is considered void in any of the following cases. If the candidate has-

  • Completed more than 30% of the course
  • Downloaded any of the offline materials
  • Attempted one or more mock exams
  • Used exam vouchers

If any participant is not satisfied with the live online or classroom session, he/she needs to inform us within 24 hours of the first session. We will refund the entire amount. Participants should communicate the same to us via email to

The guarantee is valid for participants who have paid the entire enrollment fee.

Mode: CBT (Pearson Vue) No. of questions: 250 Duration: 6 hours Question type: Multiple choice, Drag & Drop, Hotspot Scoring pattern: Scaled 0 - 1000 similar to standardised tests. No. of questions correctly answered in an exam by an expert panel is given a scaled score of 700. Candidates’ scores are derived based on this. Results: Pass/ Fail. Failed candidates get extra details (rank order of domains by the percentage of questions answered correctly). Domain weightage:Security&Risk Management(16%), Asset Security (10%), Security Engineering (12%), Communication & Network Security (12%), Identity & Access Management (13%), Security Assessment & Testing (11%), Security Operations (16%), Software Development Security (10%)

The average salary of CISSP certification holders ranges between $78,788 and $119,184 in the US (according to 

  • The most common job positions for CISSP holders include the following:

  • Chief information security officer

  • Security systems administrator

  • Information assurance analyst

  • IT security engineer

  • Senior IT security consultant

and many more.

No, this course does not include the exam. However, the CISSP exam voucher can be purchased separately.

There is no review for this course

Leave a Reply