USA:+1-703-445-4802
India:+91-8143111555 / +91-8790216888
Whats app: +91-8143110555
Azure Data & Analytics Training in Hyderabad India

Azure Data & Analytics Training in Hyderabad India

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.

Duration:

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