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

(4 customer reviews)
Sale!

Leading the way

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

(4 customer reviews)

| Total Course Video Hours: 6 Hrs 55 Min
|  Videos: 69
|  Course Access: 12 Months Unlimited Access
|  Study Method: Online Video Lessons
|  Course Type: Certificate Course
|  Award: Cyber Studies Institute / Microsoft (optional)
|  International Certification (optional): Microsoft 70-463 Implementing a Data Warehouse with SQL Server 2012 exam

Course Fee:

R1600,00

Current Special Ends in:

  • 00Days
  • 00Hours
  • 00Min
  • 00Sec

Overview 

This course is preparation for the Microsoft 70-463 Implementing a Data Warehouse with SQL Server 2012 exam. The course covers topics that are featured on the exam, such as how to implement a data warehouse platform to support a BI solution, how to create a data warehouse with Microsoft SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

 

Exams

This course includes an exam and certification by the Cyber Studies Institute.

International Certification (optional)
This course is preparation for the Microsoft 70-463 Implementing a Data Warehouse with SQL Server 2012 exam

Claim your FREE R500 Gift Voucher

FREE R500 gift voucher, especially for you 🎁

Join our mailing list and get your free exclusive R500 discount voucher.

This Voucher can be used for any of our Bundle Courses.

Curriculum

Lesson 1: Introduction to Data Warehouses
Topic A: Overview of Data Warehouses
Topic B: Examine Data Warehousing Concepts
Topic C: Introduction to Data Analysis and Reporting Concepts

Lesson 2: Creating Dimensions and Changing Granularity of Dimensions
Topic A: Create Dimensions
Topic B: Change Granularity

Lesson 3: Creating Fact Tables and Columnstore Indexes
Topic A: Create Fact Tables
Topic B: Create Columnstore Indexes

Lesson 4: Implementing Data Warehouses in SQL Server 2012
Topic A: Overview of Data Warehouse Components
Topic B: Install Integration Services

Lesson 5: Working with Integration Services
Topic A: Create an SSIS Project
Topic B: Add Packages to an SSIS Project

Lesson 6: Managing Control Flow
Topic A: Deploy a Control Flow
Topic B: Execute Packages from Different Control Flow

Lesson 7: Working with Dynamic Variables
Topic A: Create Expressions with Variables
Topic B: Create Package Templates

Lesson 8: Implementing Data Flow
Topic A: Add Data Flow Components to a Data Flow Task
Topic B: Perform Transformation Tasks
Topic C: Track Changed Data

Lesson 9: Managing Data Flow
Topic A: Add Script Tasks and Script Components to an SSISPackage
Topic B: Profile OLTP Data
Topic C: Cleanse Data Using DQS

Lesson 10: Managing SSIS Package Execution
Topic A: Execute SSIS Packages on the Server
Topic B: Configure the Package Execution Strategy

Lesson 11: Debugging and Troubleshooting Packages
Topic A: Debug Package Execution Components
Topic B: Troubleshoot Package Failures

Lesson 12: Deploying Packages
Topic A: Deploy SSIS Packages
Topic B: Examine MSI Packages

Lesson 13: Securing Packages and Databases
Topic A: Secure Packages
Topic B: Secure Databases

Lesson 14: Working with MDS and Windows Azure
Topic A: Configure MDS
Topic B: Work with MDS Databases
Topic C: Work with Windows Azure

4 reviews for Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012

  1. Grace

    The course material was easy to grasp, and the content was excellent.

  2. Liam

    I loved the interactive discussions and forums where I could connect with other learners and share insights.

  3. Ziyanda

    You’ve set the bar incredibly high. Best course ever!

  4. Ava

    The course introduced me to new tools and techniques that have enhanced my productivity.

Add a review

Your email address will not be published. Required fields are marked *

Excited to Study Enroll Qualify

If you are ready to take the next step, click on the “Enroll Now” button below or “Contact us now” on this course for a detailed course outline or if you have any questions. An expert course adviser is standing by to assist you.

CompTIA Authorized Partner

Cyber Studies Institute (Pty) Ltd is proud to be an Official CompTIA Authorized Partner. Ensuring that you receive the best training in the world.

CompTIA Authorized Partner

How does studying with CSI work?

Click here to read how the process of studying at CSI work.