Azure Data Engineer Training in Dilsuknagar.+91-6301580980
azure data engineer course contentModule 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
- Core Azure Architectural components
- Core Azure Services and Products
- Azure solutions
- Securing network connectivity
- Core Azure identity services
- Security tools and features
- Azure Governance methodologies
- Monitoring and reporting
- Privacy, compliance, and data protection standards
- Azure subscriptions
- Planning and managing costs
- Azure support options
- Azure Service Level Agreements (SLAs)
- Service Lifecycle in Azure
- 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
- Server less 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
- 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
- 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
- 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