Menu Close

Best Azure Data Engineer Training in Dilsukhnagar

MS Soft Technologies Offers  Azure Data Engineer Course in dilsukhnagar Hyderabad.The Azure data engineer focuses on data-related tasks in Azure. Primary responsibilities include using services and tools to ingest, egress, and transform data from multiple sources. Azure data engineers collaborate with business stakeholders to identify and meet data requirements. They design and implement solutions.

Azure data engineer course content

Module 1: Cloud Computing Concepts

  • What is the “Cloud”?
  • Why cloud services
  • Types of cloud models
    • Deployment Models
    • private Cloud deployment model
    • public Cloud deployment model,
    • hybrid cloud deployment model
  • Types of cloud services
  • Infrastructure as a Service,
  • Platform as a Service,
  • Software as a Service
  • Comparing Cloud Platforms
    • Microsoft Azure,
    • Amazon Web Services,
    • Google Cloud Platform
  • characteristics of cloud computing
    • On-demand self-service
    • Broad network access
    • Multi-tenancy and resource pooling
    • Rapid elasticity and scalability
    • Measured service
  • Cloud Data Warehouse Architecture
  • Shared Memory architecture
  • Shared Disk architecture
  • Shared Nothing architecture

Module 2: Core Azure services

  • Core Azure Architectural components
  • Core Azure Services and Products
  • Azure solutions

Module 3: Security, Privacy, Compliance

  • Securing network connectivity
  • Core Azure identity services
  • Security tools and features
  • Azure Governance methodologies
  • Monitoring and reporting
  • Privacy, compliance, and data protection standards

Module 4: Azure Pricing and Support

  • Azure subscriptions
  • Planning and managing costs
  • Azure support options
  • Azure Service Level Agreements (SLAs)
  • Service Lifecycle in Azure

Module 5: Azure SQL Database

  • Introduction Azure SQL Database.
  • Comparing Single Database
  • Managed Instance
  • Creating and Using SQL Server
  • Creating SQL Database Services.
  • Azure SQL Database Tools.
  • Migrating on premise database to SQL Azure.
  • Purchasing Models
  • DTU service tiers
  • vCore based Model
  • Serverless compute tier
  • Service Tiers
    • General purpose / Standard
    • Business Critical / Premium
    • Hyperscale
  • Deployment of an Azure SQL Database
  • Elastic Pools.
  • What is SQL elastic pools
    • Choosing the correct pool size
  • Creating a New Pool
  • Manage Pools
  • Monitoring and Tuning Azure SQL Database
  • Configure SQL Database Auditing
  • Export and Import of Database
  • Automated Backup
  • Point in Time Restore
  • Restore deleted databases
  • Long-term backup retention
  • Active Geo Replication
  • Auto Failover Group

Module 6:Azure Storage Service

  • Storage Service and Account
  • Creating a Storage Account
  • Standard and Premium Performance
  • Understanding Replication
  • Hot, Cold and Archive Access Tiers
  • Working with Containers and Blobs
  • Types of Blobs
  • Block Blobs,
  • Append Blobs,
  • Page Blobs
  • Blob Metadata
  • Soft Delete
  • Azure Storage Explorer
  • Access blobs securely
  • Access Key
  • Account Shared Access Token
  • Service Shared Access Token
  • Shared Access Policy
  • Storage Service Encryption
  • Azure Key Vault

Module 7: Azure Data Lake

  • Introduction to Azure Data Lake
  • What is Data Lake?
  • What is Azure Data Lake?
  • Data Lake Architecture?
  • Working with Azure Data Lake
  • Provisioning Azure Data Lake.
  • Explore Data Lake Analytics
  • Explore Data Lake Store
  • Uploading Sample File
  • Using Azure Portal
  • Using Storage Explorer
  • Using Azure CLI

Module 8: Azure Data Factory

  • Introduction to Data Factory
  • What is Data Factory?
  • Data Factory Key Components
  • Pipeline and Activity
  • Linked Service o Data Set
  • Integration Runtime Provision Required Azure Resources
  • Create Resource Group
  • Create Storage Account
  • Provision SQL Server and Create Database
  • Provision Data Factory

Register for Azure Data Engineer training today! Questions? Contact us at  +91 7995920133