Course code: GOC636« Back

Microsoft SQL Server – Optimal Data Warehouse Design and ETL Tools Summary

In this course, students will design, optimize and create a data warehouse for BI solutions with the respect to chosen strategy used for creating data warehouse. The main focus is on solving requirements of data warehouse such as the change of data granularity, data historization etc... A summary of TSQL orders and tools which are possible to use for data warehouse fulfillment is also a part of this course.

GOPAS Official Curriculum This course has been removed from our portfolio
This section contains overview of retired courses which don’t belong to GOPAS course offer any more or were replaced by new course versions.
For more information about possibility to buy retired courses contact our customer services department (__Klientskyservis@gopas.cz) or business department (__Obchod@gopas.cz).

AffiliateDurationCatalogue priceHandbook priceITB
Praha2 10 400 CZK included in course price 20
Brno2 10 400 CZK included in course price 20
Bratislava2 420,00 EUR included in course price 20

User intensity level

Who is the course for

  • This course is for IT professionals who are supposed to create data warehouse for data unification, processing and cleaning.

After completing this course, students will be able :

  • To set requirements for data warehouse
  • To design an optimal data warehouse (single-layer X N-layer)
  • To minimize the effect of change requirements
  • Data historization on the dimension level (SCD)
  • Solve different requirement to facts tables (different currencies, currency conversion, warehouse supplies)
  • To use optimal ELT technologies for data warehouse fulfillment

      Required skills

      • Knowledge based on the content of the course GOC34

      Teaching methods

      Expert instruction with practical examples, computer practice

      Literature

      Printed presentation

      Course Outline

      Introduction to data warehousing
      • Types of data warehouses
      • Optimal design of data warehouse
      • Typical development of data warehouse
      Types of tables and their use
      • Dimensional tables
      • Fact tables
      Data warehouse requirements
      • Optimization for data reading
      • Records historization
      • Setting of record/ granularity
      Data warehouse fulfillment
      • Types of data
      • Choosing a strategy for data warehouse tables fulfillment
      • Restart ability of fulfillment process
      ETL tools
      • TSQL – merge vs. Insert
      • SSIS
      • BCP
          • Previous courses

            no preceding courses

            Next courses

            no following course
            Tištěné nebo elektronické studijní materiály GOPAS

            Price:
            included in course price
            The prices are without VAT.