Powershell For Azure Cloud Sql Dba With Networking Concept

Azure Cloud, IAAS - Infrastructure as a Service (IaaS), Networking, Automation using Powershell, AZURE SQL DBA

What you'll learn

Students will learn and understand how Powershell will work with Azure SQL DBA

Students can also learn the Networking Concept which will be used for Azure Cloud.

PowerShell for Azure Cloud SQL DBA

Fulfill their own dream for automation using PowerShell with Networking Concept for Azure SQL DBA

Requirements

Basic knowledge of the SQL Server DBA fundamentals and Basic PowerShell Programming knowledge

Description

If you are working as SQL Server Database Administrator looking to enhance your skills in Azure Cloud and want to learn all concepts related to Networking + PowerShell Automation for Azure Cloud with streamline your workflow? This course has 100+ downloadable scripts/IMP Documents which includes the PowerShell Scripts + Networking Concepts and Azure Cloud Notes which makes easy to understand all concepts. In this course, we will learn a lot including the following1. In this course you will get in depth knowledge of Azure IAAS with Networking and PowerShell automation. After that you will be able to develop the script for Azure Cloud using PowerShell easily.2. In this course has explained about the Networking concepts which is more useful and helpful for those are working as Azure Cloud SQL DBA. 3. Basically, this course has been divided into Multiple of sessions/Module which include the HTML Session, Evendu you will find the others additional session in this course, which will be the subcategory of the main course. For Sub-category you have to go through each Module.4. This course has designed in such a way that anyone having the basic knowledge of DBA, they can easily learn and understand the Azure Cloud concepts (IAAS)and develop the script using PowerShell for Azure SQL DBA at the end of this course.Enroll now and become a proficient Azure Cloud SQL Server DBA!

Overview

Section 1: Introduction to Azure Cloud

Lecture 1 Introduction to Azure

Lecture 2 Introduction to LAB and Environment

Lecture 3 Data Center, Azure Resource Manager, Resource, Resource Group, Region and Zone

Section 2: Creation of Azure Virtual Machines using Azure Portal and Using Powershell

Lecture 4 Install Azure PowerShell Module

Lecture 5 Create Resource Group

Lecture 6 Automation For Creating ResourceGroup Using Application Object

Section 3: Azure Virtual Machine

Lecture 7 Create Virtual Machine using Azure Portal and PowerShell Commands

Section 4: Create Virtual Machine using Powershell (Each component Individually )

Lecture 8 Understanding of Virtual Network, IP Address, AddressSpace , Subnet and Range IP

Lecture 9 Creation of Virtual Network using Powershell

Lecture 10 Creation of Virtual Network Interface for Azure VM

Lecture 11 Creation of Public IP for Azure VM

Lecture 12 Creation of Network Security Group - NSG

Lecture 13 Creation of Virtual Machine (VM) Using PowerShell Code

Section 5: How Two Machine or Two VM can communicate with each other

Lecture 14 What is Port and why its used

Lecture 15 What is MAC Address

Lecture 16 What is OSI Module - How client and Server will communicate with each other

Section 6: Virtual Machine Creation for SQL Server using Azure GUI and Powershell Scripts

Lecture 17 Virtual Machine Size (VM Size)

Lecture 18 SQL Server Virtual Machine Creation Using PowerShell

Section 7: Creation of Domain Controller Server and Adding multiple of Servers to Domain

Lecture 19 Creation of Domain Controller Server Installing AD and DNS

Lecture 20 Creation of SQL Server Azure VM and Adding to Domain Control

Lecture 21 Cluster Installation on Both SQL Server VM and adding both SQL VM to Cluster

Lecture 22 Cluster Creation on OS 2022 - Always On Creation

Lecture 23 Cluster Creation on OS 2016 - Always On Creation

Section 8: Difference between Cloud VM and On-Prem VM + Differences of CapEx and OpEx

Lecture 24 Differences between Cloud VM and On-Prem + Difference between AzureVM and Onprem

Section 9: PowerShell Scripts for Azure Cloud - Part 1

Lecture 25 HTML Report for List of Resources using Dynamic IP-Send the HTML Report in email

Section 10: Always on troubleshooting in sql server

Lecture 26 In Always On Database is Suspend or Pause - Troubleshooting - 1

Lecture 27 Primary replica Down and Secoundary database is Not Sync Troubleshooting - 2

Lecture 28 Primary replica Host Down and Secoundary database is Not Sync Troubleshooting -3

Section 11: Always on troubleshooting in SQL server - Advanced Level

Lecture 29 Always on troubleshooting - 4

Lecture 30 Always on troubleshooting - 5

Lecture 31 Always on troubleshooting - 6

Lecture 32 Always on troubleshooting - 7

Lecture 33 Always on troubleshooting - 8

Section 12: Create Listener for AlwaysOn in Azure with Help of Load Balancer

Lecture 34 Availability Zones and availability set in azure

Lecture 35 How to Enable Virtual Machine Scale Set in Azure

Lecture 36 Creation of Virtual machine scale set in Azure

Lecture 37 AG Listener and Load Balancer-Why we need Load Balancer for AG Listener (OS2016)

Lecture 38 Creation of DNN-Distributed Network Name in Azure for AG Listener to work-OS2019

Section 13: PowerShell Scripts for Azure Cloud - Part 2

Lecture 39 HTML Report for NSG - Network Security Group and Send the HTML Report in email

Section 14: Creation of AlwaysOn in Multisubnet with different scenarios and Advantages

Lecture 40 How two machine in two different VNET and two different Subnet can communicate

Lecture 41 How to Create Peerings between two different VNET

Lecture 42 Creating Always On Listener in Multisubnet

Lecture 43 Creating Always On Listener in Multisubnet and doing Testing

Lecture 44 Creating Always On Listener in Three Multisubnet node

Lecture 45 Different scenarios on MultiSubnet for Always On Listener Creation

Section 15: Distributed Availability Group (DAG) in Azure

Lecture 46 How to Configure the DAG In Azure and what are the extra Step has to be performe

Lecture 47 How to Do DAG Failover in Azure

Section 16: Azure Role-based Access Control (RBAC) , User and Azure Group

Lecture 48 Azure User and Azure Group and assigning the permission using RBAC

Section 17: PowerShell Scripts for Azure Cloud - Part 3

Lecture 49 Generate HTML Report for List of User ,Group and Permission. Send Report in emai

Section 18: Different Types of Issue After Always On Failover from one Replica to Other.

Lecture 50 What to Do if User not able to connect the AlwaysOn Detabase After Failover

Lecture 51 Database having Column Level of Encryption

Section 19: How to Create Windows Failover Cluster for SQL Server in Azure Cloud

Lecture 52 Creating SQL Server Failover Cluster Instance (FCI) in Azure

Lecture 53 Creating Load Balancer for SQL FCI

This Course is for those Students those want to Build their carrier as Azure SQL DBA with Networking Concept and Fulfill their own dream for automation using PowerShell.