Implementing a Data Warehouse with Microsoft SQL Server 2012 COMAT Training Services Pte Ltd
Price: TBA
  • Duration: 5 Days

Course details

This instructor-led course describes how to implement a BI platform to support information worker analytics. Students will learn how to create a data warehouse with 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 OUTLINE

  • Introduction to Data Warehousing
  • Data Warehouse Hardware Considerations
  • Designing and Implementing a Data Warehouse
  • Design and implement a schema for a data warehouse
  • Implementing Control Flow in an SSIS Package
  • Debugging and Troubleshooting SSIS Packages
  • Implementing an Incremental ETL Process
  • Incorporating Data from the Cloud in a Data Warehouse
  • Enforcing Data Quality
  • Using Master Data Services
  • Extending SSIS
  • Deploying and Configuring SSIS Packages
  • Consuming Data in a Data Warehouse
Updated on 08 November, 2015

About COMAT Training Services Pte Ltd

To be or not to be; this is the question which resides in us. All man of clay, our innate differences are subtle and few. The void spanning greatness hinges on existence of mean and will. COMAT holds an intrinsic belief that every inpidual has a potential to be realised. Betterment of society through advancement of its basic unit, empowerment through continuous learning – Upon these axioms were we founded, and today proudly uphold.

Love for the people around us, a desire for a better world, our passion is our profession. COMAT believes learning is a lifelong process and key to a meaningful existence. Spearheaded by a renowned team of highly experienced and motivated trainers, COMAT offers an extensive array of IT, safety and leadership & professional development courses, providing inpiduals with the means to excel.

While adhering to globally accepted quality standards, our intention goes beyond training and certification - COMAT provides a holistic experience, focusing on generation of inductive environments for stimulating philosophical thoughts. True learning lies in instillation of a sense of self-realisation, a will to become who they can be.

We pride ourselves on our innovations, our desire for continuous improvement, and the ability to perceive the needs and wants of each inpidual. Customized approaches for varying needs, we conjure solutions tailored to fit.

See all COMAT Training Services Pte Ltd courses
Courses you can instantly connect with... Do an online course on SQL Server starting now. See all courses

Is this the right course for you?

Didn't find what you were looking for ?

or