Data Warehousing with Azure: Working with SQL Data Warehouse Objects

Azure    |    Intermediate
  • 17 videos | 1h 26m 11s
  • Includes Assessment
  • Earns a Badge
Rating 3.8 of 5 users Rating 3.8 of 5 users (5)
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

  • 5m 18s
    Find out how to identify the important factors that can impact design decisions when developing a distributed data warehouse. FREE ACCESS
  • 4m 47s
    After completing this video, you will be able to recall the key terms and concepts of data warehouse modeling. FREE ACCESS
  • Locked
    3.  Tables in SQL Data Warehouse
    5m 47s
    After completing this video, you will be able to illustrate the concept of tables and creating tables to implement in SQL Data Warehouses. FREE ACCESS
  • Locked
    4.  T-SQL Commands for Table Creation
    5m 35s
    Learn how to work with the essential commands that are generally used to create tables in SQL Data Warehouse. FREE ACCESS
  • Locked
    5.  Unsupported Features
    3m 38s
    After completing this video, you will be able to recall the various unsupported features that differentiate SQL Data Warehouses from traditional databases. FREE ACCESS
  • Locked
    6.  Distributed Table Concepts
    4m 36s
    During this video, you will learn how to define the concepts of distributed tables in SQL Data Warehouse. FREE ACCESS
  • Locked
    7.  Data Loading Techniques
    4m 28s
    Upon completion of this video, you will be able to list the various approaches for loading data in SQL Data Warehouse. FREE ACCESS
  • Locked
    8.  Load Data to SQL Data Warehouse
    4m 28s
    In this video, you will learn how to load data into SQL Data Warehouse. FREE ACCESS
  • Locked
    9.  Load Data Using Azure Data Factory
    7m 10s
    During this video, you will learn how to load data into SQL Data Warehouse using Azure Data Factory. FREE ACCESS
  • Locked
    10.  Load Data Using SQL Server Integration Services
    10m 23s
    In this video, learn how to load data into SQL Data Warehouse using SQL Server Integration Services. FREE ACCESS
  • Locked
    11.  Import and Export Data from SQL Data Warehouses
    4m 53s
    Learn how to import and export data to and from SQL Data Warehouse using Microsoft Excel. FREE ACCESS
  • Locked
    12.  T-SQL Loops in SQL Data Warehouse
    3m 11s
    Find out how to work with loops in SQL Data Warehouse. FREE ACCESS
  • Locked
    13.  Stored Procedure Essential Elements
    2m 40s
    Upon completion of this video, you will be able to specify the various clauses that are generally used in stored procedures while working with SQL Data Warehouse. FREE ACCESS
  • Locked
    14.  Transaction Management Concepts
    3m 29s
    After completing this video, you will be able to illustrate the essential transaction management features, including isolation level and transaction state, in SQL Data Warehouse. FREE ACCESS
  • Locked
    15.  Architectural Abstraction Using Views
    3m 7s
    Learn how to create architectural abstraction using views. FREE ACCESS
  • Locked
    16.  Workload Management and Performance
    5m 40s
    During this video, you will learn how to identify various performance issues and manage workloads in SQL Data Warehouse. FREE ACCESS
  • Locked
    17.  Exercise: Working with Tables and Data
    7m
    During this video, you will learn how to create tables and load data using Azure Data Factory and SQL Server Integration Services. FREE ACCESS

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.

YOU MIGHT ALSO LIKE

Journey Working with Microsoft Azure SQL
Rating 4.5 of 4 users Rating 4.5 of 4 users (4)
Book Azure SQL Hyperscale Revealed: High-performance Scalable Solutions for Critical Data Workloads
Channel Microsoft Certified: Azure Developer Associate
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Audiobook Making Work Visible: Exposing Time Theft to Optimize Work & Flow
Course Data Engineering on Microsoft Azure: Data Factory
Rating 4.6 of 161 users Rating 4.6 of 161 users (161)
Book Beginning T-SQL: A Step-by-Step Approach, Fourth Edition