Menu Icon

Available Training Rooms

  • PRIVATE BATCH
  • PUBLIC PROGRAM
  • ON DEMAND
  • BLENDED

Course Details

  • Course Overview
  • Skills Gained
  • Who Can Benefit
  • Prerequisites
  • Syllabus

In this course, you will learn how to implement a data warehouse infrastructure to support information worker analytics using SQL Server 2012. You will discover how to create a data warehouse with SQL Server 2012, implement extract, transform, and load (ETL) with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services (DQS) and SQL Server Master Data Services. This course incorporates materials from Implementing a Data Warehouse with Microsoft SQL Server 2012 (MS-10777) and covers the skills and knowledge measured by Exam 70-463. Along with on-the-job experience, this course helps prepare you for the exam.

Data warehouse concepts and architecture considerations
Select an appropriate hardware platform for a data warehouse
Design and implement a data warehouse
Implement Data Flow in a SQL Server Integration Services (SSIS) package
Debug and troubleshoot SSIS packages
Implement a SSIS solution that supports incremental data warehouse loadsand changing data
Integrate cloud data into a data warehouse ecosystem infrastructure
Implement data cleansing using Microsoft DQS
Implement Master Data Services to enforce data integrity at source
Extend SSIS with custom scripts and components
Deploy and configure SSIS packages
How information workers can consume data from the data warehouse
Database professionals who need to fulfill a BI developer role focused on hands-on work, creating BI solutions included data warehouse implementation, ETL, and data cleansing
Database professionals responsible for implementing a data warehouse, developing SSIS packages for data extraction, loading, transferring, transforming, and enforcing data integrity using Master Data Services, and cleansing data using DQS
Knowledge of relational databases
Basic knowledge of Microsoft Windows operating systems and its core functionality

1. Data Warehousing

  • Concepts and Architecture Considerations
  • Considerations for a Data Warehouse Solution

2. Data Warehouse Hardware Considerations

  • Challenges of Building a Data Warehouse
  • Reference Architectures
  • Appliances

3. Designing and Implementing a Data Warehouse

  • Logical Design
  • Physical Design

4. Creating an ETL Solution with SSIS

  • ETL with SSIS
  • Exploring Source Data
  • Implementing Data Flow

5. Implementing Control Flow in an SSIS Package

  • Control Flow
  • Creating Dynamic Packages
  • Using Containers
  • Managing Consistency

6. Debugging and Troubleshooting SSIS Packages

  • Debugging an SSIS Package
  • Logging SSIS Package Events
  • Handling Errors in an SSIS Package

7. Implementing an Incremental ETL Process

  • Incremental ETL
  • Extracting Modified Data
  • Loading Modified Data

8. Incorporating Data from the Cloud into a Data Warehouse

  • Cloud Data Sources
  • SQL Server Database
  • Windows Azure Marketplace

9. Enforcing Data Quality

  • SQL Server 2012 Data Quality Services (DQS)
  • Using DQS to Cleanse Data
  • Using DQS to Match Data

10. Using Master Data Services

  • Master Data Services Concepts
  • Implementing a Master Data Services Model
  • Using the Master Data Services Excel Add-In

11. Extending SSIS

  • Custom Components in SSIS
  • Scripting in SSIS

12. Deploying and Configuring SSIS Packages

  • Deployment
  • Deploying SSIS Projects
  • Planning SSIS Package Execution

13. Consuming Data in a Data Warehouse

  • Business Intelligence
  • Reporting
  • Data Analysis

Lab 1: Explore a Data Warehouse Solution

Lab 2: Implement a Data Warehouse Schema

Lab 3: Implement Data Flow in a SSIS Package

Lab 4A: Implement Control Flow in a SSIS Package

Lab 4B: Use Transactions and Checkpoints

Lab 5: Debug and Troubleshoot a SSIS Package

Lab 6A: Extract Modified Data

Lab 6B: Load Incremental Changes

Lab 7: Use Cloud Data in a Data Warehouse Solution

Lab 8A: Cleanse Data

Lab 8B: De-Duplication Data

Lab 9: Implement Master Data Services

Lab 10: Use Scripts and Custom Components

Lab 11: Deploy and Configure SSIS Packages

Lab 12: Business Intelligence Tools


Audience

  • Database Developer
  • Database Administrator

Public Program Schedule

Course Name Duration Brochure Location Schedule Enroll
There is no upcoming Public Batch Schedule, you can ask for Private Batch or for On-Demand Learning

Download the syllabus

Download

The highest standard, The happiest learners

Our Enterprise Clients

FAQ

  • Why should I choose RPS?
  • I am working, is it possible to arrange the classes on weekends?
  • Please confirm if your office is open on weekends?
  • Can I get the courseware in advance before start of training?
  • What are the timings (class hours)?
  • How can I make the payment?
  • What is the mode of payment?
  • Candidate authorized RPS to charge $200. But the bank has charged $208. Why is this?
  • If we need training on one of the modules only how does that work?
  • How long before do we need to book the exams?
  • Where are your training centers available?
  • Can I pay the fee in installments?
  • What are the refund policies? Can i get my money back in case i am unable to attend the training?
  • Do you provide a bank loan facility?
  • 10+ years of Training Expertise
  • Gold Learning Partner for Microsoft
  • Certified instructors with industry standard experience
  • Tailor made training available
  • 6+ training Locations
  • 100000 + professional trained
  • Customer Satisfaction
  • Reliable and Most cost effective Training

Yes, we do offer weekend classes for professionals in group or 1-to-1 Training depending upon the technology.

The administrative and sales staff works on weekdays (Monday - Friday). System Admins and Operation team are available on all days.

Yes, after you have paid the booking amount (which will be non–refundable in this case). Booking amount depends on the technology selected.

Training timings are from 9 am to 5 pm.

You can send the deposit by any of the following methods:-

  • PayPal
  • Credit Card
  • Bank Transfer
  • Demand Draft
  • Cash
  • Purchase Order (in case of Corporates / Government).
  • If you are an International student, the registration amount of USD 200 can be paid by Bank Transfer or PayPal/PayUMoney . The balance amount has to be paid by traveler's cheque or cash after arrival in India. You can also pay the balance by PayPal. There is a surcharge of 4% in this case.
  • For Indian Resident students, the course fees including registration can be paid by Cash, Cheque, Demand Draft or Bank transfer.To Know more Please call +919883305050 or Email us at info@rpsconsulting.in for any of your queries.

Overseas credit card payments through PayPal involve a mark-up of up to 4% as surcharge.

We can provide customized 1-to-1 training for a technology as per your requirement.

Most exams can be booked once you are on the course (e.g. Microsoft, ITIL, VEEAM, EC-Council). Red Hat and some other exams have to be booked in advance.

Our training centers are available in Bangalore, Chennai, Hyderabad, Pune and Delhi.

We do not have facility to pay in installments

If the course fee has been paid for and RPS cancels the Course, a refund will be provided, else the courses are non-refundable.

We do not provide loan facility.

Other Related Courses

Related courses will be updated soon...
123movies