Data Warehousing with Azure E-Learning Ausbildung

Bestellen Sie diesen großartigen, preisgekrönten Data Warehousing mit Azure E-Learning-Schulungs kurs online, 1 Jahr rund um die Uhr Zugriff auf umfangreiche interaktive Videos, Reden, praktische Aufgaben und Fortschrittsüberwachung. Nach dem Kurs erhalten Sie eine Teilnahmebescheinigung.

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

• 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

• 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

• 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

• 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