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
Course Location
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 coursesSQL Server Related Questions
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- MCSA Windows Server 2016 (70-740) Lead AcademyAED 93
AED 1,432Duration: Upto 6 Hours - Administering Microsoft SQL Server 2012 Databases Global EdulinkAED 368
AED 2,596Duration: Upto 16 Hours