Implementing a SQL Data Warehouse

DB-DW

This 4-day instructor led course provides students how to design and build a data warehouse, how to implement ETL processes, how to validate, clean, consolidate and check data using SQL Server Integration Services (SSIS), Data Quality Services (DQS), and Master Data Services.

Course length: 4 days (8:30 - 16:00)

List price: 23 600 CZK (without VAT)

This course has no dates set. If you are interested in setting a new one, please contact skoleni@oksystem.cz.

PDF to download Expand allCollapse all

  • Students will be able to

    • Describe the basic elements of data warehouse.
    • Describe HW and SW requirements for data warehouse.
    • Implement logical and physical data warehouse structure.
    • Implement data flow in SSIS.
    • Implement control flow in SSIS.
    • Create dynamic packages using parameters and variables.
    • Debug SSIS packages.
    • Describe and implement the ETL solution.
    • Implement Data Quality Services.
    • Implement Master Data Services.
    • Describe and use custom components to extend SSIS.
    • Deploy and secure SSIS projects.

  • Course requirements

    • TSQL-Language.
    • Basic knowledge of SQL Server and databases.
    • Basic knowledge of the Microsoft Windows operating system.

  • This course is intended for

    This course is intended for end users, Database Administrators, IT Managers, Database Developers, and BI professionals.

  • Literature

    All participants will get internal OKsystem student materials.

  • Hardware

    Classrooms are equipped with high-performance computers with Internet access and the possibility of wireless connection.

  • Syllabus

    Module 1: Design and implementation of the data warehouse

    • Lesson 1: Data Warehouses
    • Lesson 2: Data Warehouse Design
    • Lesson 3: Infrastructure Planning
    • Lesson 4: Dimensions
    • Lesson 5: Facts
    • Lesson 6: Indexes

    Module 2: Creating ETL solutions

    • Lesson 1: Introduction to ETL using SSIS
    • Lesson 2: Data Sources
    • Lesson 3: Implementing Data Flow
    • Lesson 4: Implementing Control Flow
    • Lesson 5: Dynamic packages, parameters, variables
    • Lesson 6: Checkpoints, transactions

    Module 3: Debugging and Troubleshooting

    • Lesson 1: Debugging packages
    • Lesson 2: Logging
    • Lesson 3: Troubleshooting

    Module 4: Implementing Data Transfers

    • Lesson 1: Incremental ETL
    • Lesson 2: Extraction of modifications
    • Lesson 3: Load data
    • Lesson 4: Change tracking

    Module 5: Data Quality Services

    • Lesson 1: Introduction to Data Quality Services
    • Lesson 2: Data cleansing, validation, deduplication
    • Lesson 3: Implementing DQS in SSIS

    Module 6: Master Data Services

    • Lesson 1: Introduction to Master Data Services
    • Lesson 2: Implementing the Master Data Services model
    • Lesson 3: Creating the Master Data Hub

    Module 7: Extending Integration Services

    • Lesson 1: Using and creating scripts
    • Lesson 2: Using components and connectors

    Module 8: Deploying, running and configuring SSIS packages

    • Lesson 1: Deploying SSIS packages, configuring SSIS
    • Lesson 2: Running SSIS packages
    • Lesson 3: Permissions and security
    • Lesson 4: Using DW data

     

Prices do not include VAT. OKsystem a.s. reserves the right to change dates and prices of courses.