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