Data Warehousing with Azure: Working with SQL Data Warehouse Objects from Skillsoft

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

Learning 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