• what is Cloud computing
  • what are services offering Microsoft azure
  • Advantages of cloud computing
  • Types of cloud deployments
  • Types of cloud Services
  • Microsoft Azure vs AWS
  • How to Create Azure Account
  • Azure Architecture & Services
  • How to Create Resources and Resource Groups in Microsoft Azure
  • Azure Resource Manager vs. classic deployment
  • How to create Virtual Machine
  • Blob
  • File
  • Queues
  • Tables
  • Security in Storage Account
  • Acceas keys
  • Share Accese Signatures
  • What is Azure SQL
  • Different deployments of SQL in Azure
  • Azure SQL Managed Instance
  • Azure SQL in Virtual Machine
  • How to create Azure SQL Server
  • How to Create Database in Azure SQL Server
  • What is Elastic Pool in Azure SQL Database
  • Different kind of Pricing Tiers in Azure SQL
  • How to Query Azure SQL Server from On-premises SSMS and Cloud
  • How to Query Data from Azure Blob files into SQL using Poly base
  • What is Polybase in Azure SQL
  • What is External tables
  • What are limitations compared On-premises to Cloud SQL Server
  • How to Load Data from On-premises to Cloud SQL using data factory
  • Migration of Existing Data from on premises to SQL Azure
  • Compare SQL Database vs Azure DW
  • How to Create Azure DW
  • How to cross query data in DW
  • Poly base using Azure Data warehouse
  • How to Query Azure SQL DW from On-premises SSMS and Cloud
  • How to Load Data to Azure DW using data Factory from Azure SQL
  • How to Load Data from on premises to Cloud SQL DW using data factory
  • Azure Data Factory vs SSIS
  • Linked Services
  • Data Sets
  • Pipelines
  • Parameters vs Variables
  • Copy Data
  • Monitor Manage
  • Autor and Deploy
  • Different kinds of integration runtimes
  • How to create pipelines from template
  • How to configure different Integration Runtimes
  • Azure Integration runtime
  • Azure Bell Hosted Integration Runtime
  • SSIS Integration runtime.
Move & transform
  • Copy Data
General activities
  • Append Variable
  • Execute Pipeline
  • Execute SSIS Package
  • Get Metadata
  • Lookup
  • Stored procedure
  • Set Variable
  • Delete
  • Wait
  • Until
Iteration & Conditionals
  • Filter
  • For Each
  • If Condition
  • Until
Incremental Loading in Azure Data factory using Blob Storage to SQL Implementing Slowly changing Dimension Data Flow
  • Source
  • Lookup
  • Derived Column
  • Alter Row
  • Conditional Split
  • Sink
  • What are ARM Templates using for Deployment
  • How to Deploy Data Factory Pipelines DEV, Test, Prod environment
  • Version Control and Code Repository in Git Hub
  • Debugging and Monitoring Pipelines
  • Error handling and Logging error records
  • Lift and Shift SSIS packages in to Azure Data Factory
  • What is Logic Apps
  • How to Create Workflow using Logic Apps in Azure.
  • How to Send Mail using Logic app in Azure Data Factory
  • What is Azure Analysis Services Tabular Model
  • How to create Azure Analysis Service Tabular model project
  • What is Workspace database
  • Import Data
  • Direct Query Mode
  • Tables and Columns
  • Relationships
  • Calculations
  • Measures
  • KPIs
  • Hierarchies
  • Partitions
  • Perspectives
  • Translations
  • Roles
  • Deployment of Tabular Project
  • Migration of Tabular Project
  • Installation of On premises Gateway
  • Blob Storage vs Data Lake
  • What is Data Lake
  • Date Lake Gen1 Vs Gen2
  • How to store Data into data lake
  • How to Query data from data lake to SQL Server.
  • Introduction to Azure Data Lake U-SQL Batch Job
  • Data Lake Analytics
  • How to Schedule Data Lake Analytics Jobs using Data Factory
  • Azure Blob to Data Lake Gen 2 using Data Factory
  • What is HD-insight
U SQL
  • Introduction
  • Introduction to U SQL
  • U-SQL vs SQL
  • How to Run U-SQL scripts
  • Extractors and Out putters
  • How to extract Data from Data Lake gen1
  • Query TSV Files
  • Create Database and Table
  • Populate Table
  • Create Rowset
  • Defining parameters
  • Performing Grouping and aggregation
  • Conditionally counting
  • Filtering aggregated rows
  • Aggregate functions
  • The U-SQL catalog
  • Databases
  • How to create Tables
  • How to create Views
  • How to create Stored Procedures
  • How to create Functions
  • How to create Table-valued functions (TVFs)
  • What is Data bricks
  • How to Create Data Bricks Free Account
  • What is Workspace in Data Bricks
  • Different Kind of Clusters in Data Bricks
  • Basics of Spark.
  • What is Note Books
  • How to Mount Data take to data bricks using Scala
  • Reading data From Blob storage and Writing into Azure sqL
  • Reading data From Data Lake storage and Writing into Azure SQL
  • using Python and scala
  • Explore, Analyze, Clean, Transform and Load Data in Data bricks using Python and SqL
  • Python vs scata vs SQL
  • Configure data bricks
  • schedule and Run Notebooks in Azure Data Factory
  • Introduction to Azure Cosmos Db
  • Features of Azure Cosmos DB
  • Different kind of Consistency Levels In Cosmos DB
  • Cosmos DB - Multi Model 5 APIs
  • Create Azure Cosmos DB
  • Create Database and Collection
  • Add an Item to a Collection
  • Read selected data from a collection
  • Creating and calling a stored procedure
  • Updating and querying from Collection
  • Creating Indexlng at Collection
  • Level Security of Cosmos DB
  • Access Keys
  • Shared Access Signature
  • Azure Active Directory
  • How to register App in Azure Active Directory
  • Role Based Access Control
  • what is power BI
  • How to create Reports in Power BI desktop Using Azure Data sources
  • Publish Reports into power BI cloud
Azure Data Engineer Training in Hyderabad

Preview this course

  • Duration 45 Hours
  • Students 21
  • Days 40 Days
  • Resume Preparation Yes
  • Interview Guidance Yes