Azure SQl DBA

Azure Cloud SQl Server DBA Course Content

PreRequiste : Candidates should have basic knowledge of SQL DBA technologies and activities to learn this course. 

 

Course Modules:

Module 1: Introduction to Azure

Module 2: Creation of Azure free account and how to use the Azure portal

Module 3: Implementing virtual machines

Module 4: Managing virtual machines

Module 5: Implementing and managing Azure networking

Module 6: Implementing Azure App services

Module 7: Planning and implementing storage, backup, and recovery services

Module 8: Planning and implementing Azure SQL Database

Module 9: Implementing Azure Active Directory

Module 10: Administration of cloud resources Using powershell and CLI

 

Module 1: Introduction to Azure

This module introduces cloud solutions in general and then focuses on the services that Azure offers.

vCloud technology overview.

vHistorical details of Cloud technology

vDiscussion about virtualization

vExplanation about managed cloud providers before the cloud technologies evolved.

vDiscussion about why cloud technologies became popular during late 90’s

vBenefits of cloud technologies

vDiscussion about cloud deployment model (public, private and hybrid cloud discussion )

vDiscussion about categories of cloud technologies (IaaS, PaaS, SaaS)

vDiscussion about Different cloud providers in the market.

vWhy Azure cloud is popular in the market

vAzure cloud certifications

Module 2: Creation of Azure free account and how to use the Azure portal

vBasic requirements to create the azure free account

vProcedure to create free account

vBasic navigation of Azure services within the portal

Module 3: Implementing virtual machines

This module introduces the fundamentals of Azure Virtual Machines, and discusses the different ways in which you can deploy and manage them.

vCreation of Windows virtual Machine using Portal and Powershell

vOverview of Azure Resource Manager and virtual machines

vConfiguration and discussion about the availability sets, update domain and fault domain

vConfiguration and discussion about Proximity placement group

vConfiguration and discussion about host groups in azure cloud

vDiscussion about different computing family that are exists in the cloud.

vCreation of Windows VM servers and connectivity procedure.

vDiscussion about temporary drive on the VM servers.

vCreation of Linux VMs and authentication modes.

 

Module 4: Managing virtual machines

This module explains how to manage virtual machines including configuring virtual machines, configuring virtual machine disks, and managing and monitor virtual machines.

v Managing and monitoring Azure virtual machines

vDiscussion about Virtual Machine Disk types

vAdding new drive to existing Virtual Machine

vExpanding the existing drive on the VM server

vUploading on-premise VHD to storage account

vConverting VHD to Azure managed disk and attached to the Azure VM

vCapture VM images from existing VM

vDeploying a new VM from Captured VM images

vDifference between Stop and De-allocating the Virtual Machine

vUnderstand and capture VM images and building new server from the OS snapshot.

vScaling up an Scaling down VM server

vHow to assign the static public IP to virtual machine

vHow to assign the static private IP to virtual machine

vHow to configure Virtual Machine Auto Scaling based on the load on the servers.

vHow to create disk snapshots on the VM server and how to create another VM server using the Snapshot disks.

vCreation of golden OS as per the requirement.

vHow to add or expand existing drives on Linux servers

vMigration of VMs from one Vnet to another VNet

vCreation and basic administration of Linux machines in cloud.

vDiscussion about ssh-key based authentication on Azure Linux servers

 

Module 5: Implementing and managing Azure networking

v Overview of Azure networking components and functionality.

vTypes of IP addresses.

vRole of Private IP addresses in Azure cloud.

v Virtual Network Benefits.

vConfiguring Azure virtual networks.

vConfiguring and understanding Network Security Groups.

vConfiguring Azure virtual network connectivity.

vDiscussion about to how to segment the network into multiple subnets within the Virtual private network

vSetup Network Security Group to control the access between subnets

vConfiguring internal and external load balancers.

vConfiguring Peering between the Vnets to allow connections between the VNets.

vConfiguring the Azure traffic manager to route the connections based on the geo-graphic regions.

vConfiguring point-site VPN to connect to Azure resources using private IP

Module 6: Implementing Azure App services

v Introduction to App Service

vConfiguring web apps

vConfiguring the Traffic Manager to route the traffic based on the rule assigned.

Module 7: Planning and implementing storage, backup, and recovery services

vTypes of Azure Storages

vStorage access Tires.

v Creating and configuring Azure storage

vHow to create the file share and mount the file share within the VMs for sharing the data between the VMs

vFiles and file recovery methods using snapshots.

vScheduling the job for file share using azure recovery vault.

vMigrating and protecting on-premise file system using Azure vault recovery method and scheduling it to take regular files snapshot.

vUsage of Blob, Tables Queue storage.

vConfiguring the Azure backup recovery vault.

vHow to take the VM server backups and recover the VM servers using the recovery Vault service in Azure

vHow to take VM disks snapshots using the recovery vault.

vScheduling the SQL server backups using recovery vault service.

Module 8: Planning and implementing Azure SQL Database

vCreation of PASS SQL server

vUnderstanding Database as a Service

vDifference between On-Prem SQL server and Azure SQL

vAzure SQL pricing model

vDifferent authentication methods to connect to the Azure SQL server

vCreation of Azure SQL databases using on-premise SSMS

vExploring the cloud database properties

vManaging Azure SQL Database security

vHow to configure and manage DB pools and eDTUs

vDiscussion about DTU and eDTU usage model.

vDiscussion about difference between DTU, eDTU and vCore based model databases.

vAzure Active directory authentication to connect Cloud SQL server.

vConfiguration of cloud firewalls for SQL server and Database for access.

v Monitoring Azure SQL Database

vBackup methods for cloud SQL servers.

vHow to maintain and rebuild the indexes on cloud PASS Database.

vHow to implement column Encryption on critical tables.

vConfiguration Dynamic data masking on the database and its usage.

vRestore and recovery methods for cloud SQL server

vDiscussion about Transparent Data Encryption on database.

vConfiguring Server level and database auditing in cloud database.

vConfiguring alerting and Monitoring for Azure SQL servers.

vMigration of On-premise database to cloud and from cloud to on-premise using multiple methods.

vConfiguring Geo-Replication for cloud SQL database

vData Recovery procedures of PAAS databases and SQL server within the VM as well.

vConfiguring the transactional and Merge replication cloud to cloud and cloud to On-premise databases.

vConfiguring regular backups on Azure cloud VM’s using cloud recovery vault.

vConfiguration of Always on Groups using cloud VMs

vLinking on premise SQL server and Cloud PASS SQL server.

vDifferent methods to migrate a on-premise database to Cloud VM and Cloud SQL server

vProcedure to do the live migration of On-premise SQL servers to cloud SQL server and Cloud VM SQL server using Database migration Assistant tool, Database Migration Service and backup methods using the storage credential keys.

vAutomating tasks using azure Runbooks and using linked servers from Onpremise to cloud.

vHow to use AZCOPY tool and Azure storage explorer tool to migrate the data from Onpremise to cloud.

Module 9: Implementing Azure Active Directory

This module explains how to implement Azure AD.

vCreating and managing Azure AD tenants

vConfiguring application and resource access with Azure AD

vImplementing directory synchronization by using Azure AD Connect

vConfiguration of single sign on in azure cloud

vCreation of multiple Azure domain directories.

Module 10: Administration of cloud resources Using powershell and CLI

#azuresqldbatraining #azuretraining #azureonlinetraining #azurecourse

#azuresqldbaonlinetraining #azurejobsupport #sqldbaonlinetraining

#futurepoint #jjobsupport #onlinetraining #sqldbaonlineclasses