Data Warehousing with Azure E-Learning Kurs

Data Warehousing with Azure E-learning Training

Order this amazing, award-winning Data Warehousing with Azure E-learning Training course online, 1 year 24/7 access to extensive interactive videos, speeches, hands-on tasks and progress monitoring. After the course you will receive a certificate of attendance.

Kursinhalt

Data Warehousing with Azure: Architecture & Modeling Techniques
Course: 1 Hour, 18 Minutes

Data Warehouse Features
Data Warehouse Architectures
Data Warehouse Alternatives
Data Warehouse Generation
Variations of Data Warehouse
Federated Data Warehouse Features
Star Schema and Data Mart Approach
Data Warehouse Lifecycle Phases
Metadata Concepts in Data Warehouse
Structured and Unstructured Data
Structured and Unstructured Data - Examples
Analytics and Reporting Approach
Cloud Data Warehouse
Hybrid Data Warehouse Architecture
Exercise: Implementing Data Warehouse Features

Data Warehousing with Azure
Course: 1 Hour, 8 Minutes

Azure SQL Data Warehouse Features and Architecture
MPP and Workload Management
Creating SQL Data Warehouse
Connect and Query SQL Data Warehouse
Create and Query SQL Data Warehouse using PowerShell
Data Warehouse Design
Design and Best Practices for SQL Data Warehouse
Pause and Resume Functionality
Scale Compute in Azure SQL Data Warehouse
ELT Process for Azure SQL Data Warehouse
Exercise: Working with SQL Data Warehouse

Data Warehousing with Azure
Course: 1 Hour, 27 Minutes

Design Decision Making
Data Warehouse Modeling
Tables in SQL Data Warehouse
T-SQL Commands for Table Creation
Unsupported Features
Distributed Table Concepts
Data Loading Techniques
Load Data to SQL Data Warehouse
Load Data Using Azure Data Factory
Load Data Using SQL Server Integration Services
Import and Export Data from SQL Data Warehouses
T-SQL Loops in SQL Data Warehouse
Stored Procedure Essential Elements
Transaction Management Concepts
Architectural Abstraction Using Views
Workload Management and Performance
Exercise: Working with Tables and Data

Data Warehousing with Azure
Course: 45 Minutes

Introducing Azure Analysis Services
Create an Analysis Services Server Using PowerShell
Create an Analysis Services Server Using Portal
Add Models to the Analysis Server
Create Reports Using Power BI
Exploring Data Using Excel and Power BI
Power BI and SQL Data Warehouse
AdventureWorks Data Warehouse
Azure Data Lake and Power BI
Exercise: Preparing Data and Creating Reports

Data Warehousing with Azure
Course: 59 Minutes

Essential Goals and Features of a Data Lake
Introducing the Azure Data Lake
Azure Gen1 Data Lake Storage
Azure Gen2 Data Lake Storage
Gen1 Azure Data Lake Storage Using Portal
Gen1 Azure Data Lake Storage Using PowerShell
Gen1 Azure Data Lake Storage Using VSCode and CLI
Azure Storage Explorer
Gen2 Azure Data Lake Storage Creation
Loading Data in an Azure Data Lake
Data Lake and SQL Data Warehouse
Comparing V1 and V2 Azure Data Factory
Exercise: Creating the Azure Data Lake Storage

Data Warehousing with Azure
Course: 1 Hour

Azure Data Lake and Big Data
Ingesting Data in the Data Store
Data Sources for Azure Data Lake
Data Loading Approaches for Huge Data
Moving Data from a Data Lake to Other Sources
Moving Data Using AdlCopy
Using the Offline Copy Method
Security Mechanism for Azure Data Lake
Securing Data in Azure Data Lake
Tuning Data Lake
Log Analytics
Implementing Log Analytics
Exercise: Moving Offline Data