• Online, Self-Paced
Course Description

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

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.