Course details

Data Warehousing with Azure: Working with SQL Data Warehouse Objects

Data Warehousing with Azure: Working with SQL Data Warehouse Objects


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Explore how to create and utilize SQL Data Warehouse objects and work with T-SQL to implement tables of diversified categories.



Expected Duration (hours)
1.5

Lesson Objectives

Data Warehousing with Azure: Working with SQL Data Warehouse Objects

  • identify the important factors that can impact the design decisions when developing a distributed data warehouse
  • recall the key terms and concepts of data warehouse modelling
  • illustrate the concept of tables and creating tables to implement in SQL Data Warehouses
  • work with the essential commands that are generally used to create tables in SQL Data Warehouse
  • recall the various unsupported features that differentiate SQL Data Warehouses from the traditional databases
  • define the concepts of distributed tables in SQL Data Warehouse
  • list the various approaches of loading data in SQL Data Warehouse
  • load data to SQL Data Warehouse
  • load data to SQL Data Warehouse using the Azure data factory
  • load data to SQL Data Warehouse using SQL Server Integration Services
  • import and export data to and from SQL Data Warehouse using Microsoft Excel
  • work with loops in SQL Data Warehouse
  • specify the various clauses that are generally used in stored procedures while working with SQL Data Warehouse
  • illustrate the essential transaction management features with isolation level and transaction state in SQL Data Warehouse
  • create architectural abstraction using views
  • identify the various performance issues and workload management in SQL Data Warehouse
  • create tables and load data using Azure data factory and SQL Server Integration Services
  • Course Number:
    it_dfdwaz_03_enus

    Expertise Level
    Intermediate