Data Warehousing with Azure: Working with SQL Data Warehouse Objects
Azure 2018
| Intermediate
- 17 videos | 1h 26m 11s
- Includes Assessment
- Earns a Badge
Explore how to create and utilize SQL Data Warehouse objects and work with T-SQL to implement tables of diversified categories.
WHAT YOU WILL LEARN
-
Identify the important factors that can impact the design decisions when developing a distributed data warehouseRecall the key terms and concepts of data warehouse modellingIllustrate the concept of tables and creating tables to implement in sql data warehousesWork with the essential commands that are generally used to create tables in sql data warehouseRecall the various unsupported features that differentiate sql data warehouses from the traditional databasesDefine the concepts of distributed tables in sql data warehouseList the various approaches of loading data in sql data warehouseLoad data to sql data warehouseLoad data to sql data warehouse using the azure data factory
-
Load data to sql data warehouse using sql server integration servicesImport and export data to and from sql data warehouse using microsoft excelWork with loops in sql data warehouseSpecify the various clauses that are generally used in stored procedures while working with sql data warehouseIllustrate the essential transaction management features with isolation level and transaction state in sql data warehouseCreate architectural abstraction using viewsIdentify the various performance issues and workload management in sql data warehouseCreate tables and load data using azure data factory and sql server integration services
IN THIS COURSE
-
5m 18s
-
4m 47s
-
5m 47s
-
5m 35s
-
3m 38s
-
4m 36s
-
4m 28s
-
4m 28s
-
7m 10s
-
10m 23s
-
4m 53s
-
3m 11s
-
2m 40s
-
3m 29s
-
3m 7s
-
5m 40s
-
7m
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.