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


Course Description

This course is preparation for the 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.

Course Videos

This course contains the following modules and videos. Click the down arror to view video details.

  • Introduction
  • Introduction To Data Warehouse-Part1
  • Introduction To Data Warehouse-Part2
  • Introduction To Data Warehouse-Part3
  • Introduction To Data Warehouse-Part4
  • Introduction To Data Warehouse-Part5
  • Introduction To Data Warehouse-Part6
  • Creating Dimensions And Changing Granularity Of Dimensions-Part1
  • Creating Dimensions And Changing Granularity Of Dimensions-Part2
  • Creating Dimensions And Changing Granularity Of Dimensions-Part3
  • Creating Dimensions And Changing Granularity Of Dimensions-Part4
  • Creating Dimensions And Changing Granularity Of Dimensions-Part5
  • Creating Dimensions And Changing Granularity Of Dimensions-Part6
  • Creating Fact Tables And Column Store Indexes-Part1
  • Creating Fact Tables And Column Store Indexes-Part2
  • Creating Fact Tables And Column Store Indexes-Part3
  • Creating Fact Tables And Column Store Indexes-Part4
  • Creating Fact Tables And Column Store Indexes-Part5
  • Implementing Data Warehouse-Part1
  • Implementing Data Warehouse-Part2
  • Implementing Data Warehouse-Part3
  • Implementing Data Warehouse-Part4
  • Working With Integration Services-Part1
  • Working With Integration Services-Part2
  • Working With Integration Services-Part3
  • Working With Integration Services-Part4
  • Working With Integration Services-Part5
  • Working With Integration Services-Part6
  • Managing Control Flow-Part1
  • Managing Control Flow-Part2
  • Managing Control Flow-Part3
  • Managing Control Flow-Part4
  • Managing Control Flow-Part5
  • Working With Dynamic Variables-Part2
  • Working With Dynamic Variables-Part3
  • Working With Dynamic Variables-Part4
  • Working With Dynamic Variables-Part5
  • Working With Dynamic Variables-Part6
  • Working With Dynamic Variables-Part7
  • Working With Dynamic Variables-Part8
    • Implementing DataFlow-Part1
    • Implementing DataFlow-Part2
    • Implementing DataFlow-Part3
    • Implementing DataFlow-Part4
    • Implementing DataFlow-Part5
    • Implementing DataFlow-Part6
    • Implementing DataFlow-Part7
    • Implementing DataFlow-Part8
    • Managing DataFlow-Part1
    • Managing DataFlow-Part2
    • Managing DataFlow-Part3
    • Managing DataFlow-Part4
    • Managing SSIS Package Execution-Part1
    • Managing SSIS Package Execution-Part2
    • Managing SSIS Package Execution-Part3
    • Managing SSIS Package Execution-Part4
    • Managing SSIS Package Execution-Part5
    • Managing SSIS Package Execution-Part6
    • Debugging And Troubleshooting-Part1
    • Debugging And Troubleshooting-Part2
    • Debugging And Troubleshooting-Part3
    • Debugging And Troubleshooting-Part4
    • Deploying Packages-Part1
    • Deploying Packages-Part2
    • Deploying Packages-Part3
    • Securing Packages And Databases-Part1
    • Securing Packages And Databases-Part2
    • Working With MDS And Windows Azure

    Instructor led lectures

    All IT Nuggets Courses replicate a live class experience with an instructor on screen delivering the course’s theories and concepts.

    These lectures are pre-recorded and available to the user 24/7. They can be repeated, rewound, fast forwarded.

    Visual Demonstrations, Educational Games & Flashcards

    IT Nuggets recognizes that all students do not learn alike and different delivery mediums are needed in order to achieve success for a large student base. With that in mind, we delivery our content in a variety of different ways to ensure that students stay engaged and productive throughout their courses.

    Mobile Optimization & Progress Tracking

    Our courses are optimized for all mobile devices allowing students to learn on the go whenever they have free time. Students can access their courses from anywhere and their progress is completely tracked and recorded.

    Practice Quizzes and Exams

    IT Nuggets Online’s custom practice exams prepare you for your exams differently and more effectively than the traditional exam preps on the market. Students will have practice quizzes after each module to ensure you are confident on the topic you are learning.

    World Class Learning Management System

    IT Nuggets provides the next generation learning management system (LMS). An experience that combines the feature set of traditional Learning Management Systems with advanced functionality designed to make learning management easy and online learning engaging from the user’s perspective.