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

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