Azure SQL demo session on 25-Feb-19 i.e. Monday at 9AM(IST)--Acutelearn Technologies.

AcuteLearn will provide Azure SQL Corporate and online training.

Azure Data & Analytics Training

Azure Data Lake Store (ADLS) is a cloud-based repository for both structured and unstructured data.

ADLS is designed for big data analytics in a Hadoop environment. It is compatible with Hadoop Distributed File System (HDFS), so you can run your existing Hadoop jobs by simply telling them to use your Azure data lake as the filesystem.

Alternatively, you can use Azure Data Lake Analytics (ADLA) to do your big data processing tasks. It’s a service that automatically provisions resources to run processing jobs.

In this course, you will learn to import data into ADLS, then secure, process, and export it. How to create data-driven pipelines to direct the movement of data. You will also be introduced to an alternative option to Azure Data Factory and that is using SSIS to work with your cloud resources. How to troubleshoot processing jobs and optimize I/O.

Course Content

Overview of the Microsoft Azure Platform

• Introduction to Azure
• Basics of Cloud computing
• Azure Infrastructure
• Walkthrough of Azure Portal
• Overview of Azure Services

Azure Data Architecture

• Traditional RDBMS workloads.
• Data Warehousing Approach
• Big data architectures.
• Transferring data to and from Azure

Azure Storage options

• Blob Storage
• RDBMS
• Hadoop
• NoSQL
• Disk

Blob Storage

• Azure Blob Resources
• Types of Blobs in Azure
• Azure storage account data objects
• Azure storage account types and Options
• Replications in distribution
• Secure access to an application's data
• Azure Import/Export service
• Storage Explorer
• Practical section on Blob Storage

Azure SQL Server

• Azure SQL Database Overview
• Understanding Azure SQL Features
• Azure SQL Database Tools
• Securing and Recovering an AzureSQL Database Instance
• Understanding Azure SQL pricing
• Migrating Data to Azure SQL
• Establish data sync
• Monitoring/Tuning Azure SQL

Azure DataWarehouse

• Introduction to Azure DWH
• Overview of architecture of AzureDWH
• Features of Azure DWH
• Polybase in detail
• Loading Azure SQL DWH
• Querying and tuning Azure DWH

Azure Data Factory

• Introduction to Azure DataFactory
• Azure Data Factory components
• Orchestrate the Extract and loadwith ADF
• Develop and Run Pipelines
• Scheduling your ADF
• Monitoring your ADF
• Manage ADF

Azure Data Lake & Azure Data Lake Analytics

• Introduction to Azure Analysis Services
• Creating a sample Azure Analysis Services model – Web Designer
• Connecting to the model through SSMS
• Connect using Excel
• Create a new model from scratch -Web designer
• Create relationship
• Create new measures
• Create new calculated columns
• Develop an Azure AS model using Visual Studio
• Migrating on premise SSAS model to Azure AS

For more information please do reach us +91-7702999361/371, [email protected], www.acutelearn.com.

Others Details

Acutelearn is leading training company provides corporate and online trainings on various technologies like AWS, Azure, Blue prism, CCNA, CISCO UCS, CITRIX Netscaler,CITRIX Xendesktop, Devops chef, EMC Avamar, EMC Data Domain, EMC Networker, EMC VNX, Exchange Server 2016, Hyper-V, Lync server, Microsoft windows clustering, Netapp, Office 365, Red Hat Linux, openstack, SCCM, vmware nsx 6.0, vmware vrealize, vmware vsphere, windows powershell scripting, DataScience, Azure Data & Analytics.