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