Data Warehousing with Azure: Working with SQL Data Warehouse Objects

Azure 2018    |    Intermediate
  • 17 Videos | 1h 34m 11s
  • Includes Assessment
  • Earns a Badge
Likes 17 Likes 17
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 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

IN THIS COURSE

  • Playable
    1. 
    Design Decision Making
    5m 18s
    UP NEXT
  • Playable
    2. 
    Data Warehouse Modeling
    4m 47s
  • Locked
    3. 
    Tables in SQL Data Warehouse
    5m 47s
  • Locked
    4. 
    T-SQL Commands for Table Creation
    5m 35s
  • Locked
    5. 
    Unsupported Features
    3m 38s
  • Locked
    6. 
    Distributed Table Concepts
    4m 36s
  • Locked
    7. 
    Data Loading Techniques
    4m 28s
  • Locked
    8. 
    Load Data to SQL Data Warehouse
    4m 28s
  • Locked
    9. 
    Load Data Using Azure Data Factory
    7m 10s
  • Locked
    10. 
    Load Data Using SQL Server Integration Services
    10m 23s
  • Locked
    11. 
    Import and Export Data from SQL Data Warehouses
    4m 53s
  • Locked
    12. 
    T-SQL Loops in SQL Data Warehouse
    3m 11s
  • Locked
    13. 
    Stored Procedure Essential Elements
    2m 40s
  • Locked
    14. 
    Transaction Management Concepts
    3m 29s
  • Locked
    15. 
    Architectural Abstraction Using Views
    3m 7s
  • Locked
    16. 
    Workload Management and Performance
    5m 40s
  • Locked
    17. 
    Exercise: Working with Tables and Data
    7m

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 36 Likes 36  
Likes 193 Likes 193  
Likes 24 Likes 24