Colleges and Universities Offering Implementing a Data Warehouse with Microsoft SQL Server 2014 in South Africa

Institutions Offering Implementing a Data Warehouse with Microsoft SQL Server 2014

•  MasterGrade IT, Cape Town  
  Course entry requirements
  -At least 2 years’ experience of working with relational databases, including:
  -Designing a normalized database.
  -Creating tables and relationships.
  -Querying with Transact-SQL.
  -Some exposure to basic programming constructs (such as looping and branching).
  -An awareness of key business priorities such as revenue, profitability, and fina
  
  Course duration
  (i) Instructor Led Learning
  -5 Days
  
  (ii) 5 Days
  
  Course content
  -Debug and Troubleshoot SSIS packages.
  -Implement an ETL solution that supports incremental data extraction.
  -Implement an ETL solution that supports incremental data loading.
  -Implement data cleansing by using Microsoft Data Quality Services.
  -Implement Master Data Services to enforce data integrity.
  -Extend SSIS with custom scripts and components.
  -Deploy and Configure SSIS packages.
  -Describe how BI solutions can consume data from the data warehouse.
  -Describe 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 an SSIS Package.
  -Implement Control Flow in an SSIS Package.

---

More Certificate Courses in South Africa

---

View all courses in South Africa

---