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

  • Course Name: Implementing a Data Warehouse with Microsoft SQL Server 2014()
  • Major Subject:
  • Course Category: Certificate Courses

Institutions Offering Implementing a Data Warehouse with Microsoft SQL Server 2014

  • MasterGrade IT 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