Azure Training Course

✅ What is Stream Analytics?

✅ Get started with Azure Stream Analytics to process data from IoT devices

✅ Data connection

✅ Event Processing Ordering Design Choices for Azure Stream Analytics

✅ Stream Analytics outputs: Options for storage, analysis

✅ Machine Learning integration in Stream Analytics

✅ Performing sentiment analysis by using Azure Stream Analytics and Azure Machine Learning

✅ Machine Learning-based anomaly detection in Azure Stream Analytics

✅ What is Diagnostics logs

✅ Enabling Diagnostics logs

✅ Diagnostics logs Categories

✅ Data Errors

✅ Generic Events

✅ Stream Analytics Query Language Reference

✅ Built-in Functions (Azure Stream Analytics)

✅ Data Types (Azure Stream Analytics)

✅ TIMESTAMP BY (Azure Stream Analytics)

✅ Event Delivery Guarantees
(Azure Stream Analytics)

✅ How to achieve exactly-once delivery for SQL output

✅ Introduction to Azure Data Lake Store

✅ Get started with Azure Data Lake Store using the Azure portal

✅ Copy data to and from Data Lake Storage Gen1 by using Data Factory

✅ Tuning Azure Data Lake Store for performance

✅ Overview of Microsoft Azure Data Lake Analytics

✅ Get started with Azure Data Lake Analytics using Azure portal

✅ Manage Azure Data Lake Analytics by using the Azure portal

✅ Manage Jobs using the Azure portal

✅ Azure Data Lake Analytics Quota Limits

✅ Azure Data Lake Developer Tools

✅ Troubleshoot Azure Data Lake Analytics jobs using Azure Portal

✅ Use Job Browser and Job View for Azure Data lake Analytics jobs

✅ U-SQL programmability guide

✅ Develop U-SQL user-defined operators (UDOs)

✅ Extending U-SQL Expressions with User-Code

✅ Get started with the U-SQL Catalog

✅ Develop U-SQL scripts by using Data Lake Tools for Visual Studio

✅ Connect to an Azure Data Lake Analytics account

✅ Extend U-SQL scripts with Python code in Azure Data Lake Analytics

✅ Get started with the Cognitive capabilities of U-SQL

✅ Registering Cognitive Extensions in U-SQL

✅ Setup Azure Data Lake Analytics federated U-SQL queries to Azure SQL Database

✅ Transform data by running U-SQL scripts on Azure Data Lake Analytics

✅ Azure Data Lake & Azure HDInsight Blog

✅ Directly store streaming data into Azure Data Lake with Azure Event Hubs

✅ Distributed tables in Azure SQL Data Warehouse

✅ Table Categories in Azure SQL Data Warehouse

✅ Schema & Different Tables in Azure SQL Data Warehouse

✅ Common distribution methods for tables

✅ Columnstore indexes Key Terms & Concepts

✅ Columnstore indexes Use Cases

✅ PolyBase and Azure Data Lake

✅ PolyBase to access to Non relational data

✅ Introduction to Azure Data Factory

✅ How Does Data Factory Works

✅ Key Components in Data Factory

✅ Relationship Between Data Factory Entities

✅ Azure Data Factory pipelines

✅ Creating alert in the Azure Server

✅ Create an Azure SQL Data Warehouse

✅ Creating a Server Level Firewall Rule

✅ Connecting to SQL Server

✅ Clean up Resources in Azure SQL Data Warehouse

✅ What is Azure Active Directory

✅ Azure Active Directory Licenses

✅ Working With Azure Active Directory

✅ Creating an Azure Active Directory Group and the assign the user the group

✅ Adding an Azure Active Directory user/group an SQL Administrator

✅ Secure a database in SQL Data Warehouse

✅ What is auditing? & Auditing basics

✅ Setting up server-level auditing for all database

✅ Setting up database-level auditing for a single database

✅ server-level policy audit logs

✅ SQL Data Warehouse backups

✅ Restore Azure SQL Data Warehouse

✅ Backups in Azure SQL Data Warehouse

✅ Migrate Your Data

✅ Workload management & Resourse Classes

✅ Suppoted Resourse class operations

✅ Scale & Compute

✅ Monitor your workload using DMVs

✅ Tuning Azure Data Lake Store for performance

✅ Optimizing I/O intensive jobs on Hadoop and Spark on HDInsight

✅ General Considerations for an HDInsight cluster

✅ Cloud Design Patterns