PowerShell for Azure SQL DBA (IAAS) with Networking Concept

Name: PowerShell for Azure SQL DBA (IAAS) with Networking Concept
Rating: 4.7 (3 reviews)

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

Created byRajesh J

Last updated 7/2025

English

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

Course content

19 sections • 53 lectures • 29h 44m total length

Introduction to Azure47:58
Explore Azure cloud fundamentals and the why behind adoption, highlighting cost savings and on-demand provisioning. See how PowerShell automates Azure SQL DBA tasks on IAAS with essential networking concepts.
Introduction to LAB and Environment11:31
Explore the lab setup for PowerShell automation, including PowerShell ISE, PowerShell 7.5, VS Code, and Notepad++. Identify how to connect to sql server with ssms, virtual machines, and dag concepts.
Data Center, Azure Resource Manager, Resource, Resource Group, Region and Zone33:28

Install Azure PowerShell Module15:07
Install the Azure PowerShell module, set the execution policy to remote sign, import and verify the module, then authenticate and connect to your Azure subscription.
Create Resource Group10:19
Automation For Creating ResourceGroup Using Application Object31:24
Learn to automate Azure resource group creation with PowerShell using an app registration and secret, handling tenant and subscription context, and RBAC permissions, via a reusable PS1 script.

Understanding of Virtual Network, IP Address, AddressSpace , Subnet and Range IP1:30:34
Creation of Virtual Network using Powershell16:09
Create a virtual network with PowerShell, defining the address space and subnet to allocate IP ranges for Azure resources.
Creation of Virtual Network Interface for Azure VM23:45
Creation of Public IP for Azure VM22:42
Creation of Network Security Group - NSG37:55
Learn to create and attach an Azure network security group with inbound and outbound rules to a virtual network subnet, using PowerShell automation for public ip addresses and rdp access.
Creation of Virtual Machine (VM) Using PowerShell Code24:22

What is Port and why its used36:13
Learn how networking ports enable communication between machines using IP addresses, MAC addresses, port numbers, and OSI transport layer concepts, including SQL Server 1433 and dynamic ports.
What is MAC Address15:51
What is OSI Module - How client and Server will communicate with each other51:02
Explore how the OSI model governs client-server communication, detailing application to physical layers, ports, IPs, encryption, and how SQL Server uses tds protocol, tcp, and dns for cloud networking.

Virtual Machine Size (VM Size)42:36
Explore virtual machine size selection for Azure sql server on iaas, analyzing series, cpu, ram, iops, and storage configurations (data, log, tempdb) in the Azure portal.
SQL Server Virtual Machine Creation Using PowerShell21:05
Use PowerShell to create an Azure SQL Server on a virtual machine, connect via public IP and RDP, and manage networking and VM lifecycle for cost efficiency.

Creation of Domain Controller Server Installing AD and DNS41:59
Learn to use PowerShell to create a domain controller in Azure, install Active Directory and DNS, and deploy two SQL Server nodes in a subnet within a shared virtual network.
Creation of SQL Server Azure VM and Adding to Domain Control12:14
Cluster Installation on Both SQL Server VM and adding both SQL VM to Cluster8:50
Cluster Creation on OS 2022 - Always On Creation41:08
Cluster Creation on OS 2016 - Always On Creation52:32

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 following

1. 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!

Who this course is for:

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.

PowerShell for Azure SQL DBA (IAAS) with Networking Concept

What you'll learn

Explore related topics

Course content

Introduction to Azure Cloud3 lectures • 1hr 33min

Creation of Azure Virtual Machines using Azure Portal and Using Powershell3 lectures • 57min

Azure Virtual Machine1 lecture • 24min

Create Virtual Machine using Powershell (Each component Individually )6 lectures • 3hr 35min

How Two Machine or Two VM can communicate with each other3 lectures • 1hr 43min

Virtual Machine Creation for SQL Server using Azure GUI and Powershell Scripts2 lectures • 1hr 4min

Creation of Domain Controller Server and Adding multiple of Servers to Domain5 lectures • 2hr 37min

Difference between Cloud VM and On-Prem VM + Differences of CapEx and OpEx1 lecture • 28min

PowerShell Scripts for Azure Cloud - Part 11 lecture • 1hr 11min

Always on troubleshooting in sql server3 lectures • 49min

Requirements

Description

Who this course is for: