YoVDO

Azure PowerShell Playbook: Azure SQL

Offered By: Pluralsight

Tags

Azure SQL Courses PowerShell Courses Database Migration Courses

Course Description

Overview

This course covers how to manage your Azure SQL instance from PowerShell. You'll learn how to set up and configure SQL Servers, migrate local databases to Azure, and run SQL Scripts against your Azure SQL servers. Take this intermediate course and learn from Pluralsight today!

Azure SQL is a powerful database platform, providing a stable environment to migrate your local SQL Server databases to the cloud. PowerShell is key to that effort, letting you automate the migration process as well as maintenance. In this course, Azure PowerShell Playbook: Azure SQL, you'll explore how to set up a SQL Server in Azure SQL and configure its firewall. First, you'll learn how to migrate an on-premises database to your new Azure SQL Server. Along the way, you'll discover how to set up resource groups and storage accounts, as well as automating the export of your local databases to bacpac files. Next, you’ll learn how maintenance is a key component to managing your Azure SQL installation, so you will see techniques for applying multiple SQL scripts against your Azure SQL. Finally, Azure can get expensive, so you'll learn how to remove everything you've created, both individually and in bulk, so you can manage your valuable resources only using them when needed. By the end of this course, you'll have a better understanding of how to utilize PowerShell to manage your Azure SQL databases.

Taught by

Robert Cain

Related Courses

Hands-On with AWS Database Migration Service (DMS)
A Cloud Guru
Introduction to Cloud Migration Using Amazon Web Services
A Cloud Guru
Introduction to Migrating Databases and Virtual Machines to Google Cloud Platform
A Cloud Guru
Add Passkeys to a Laravel App
Laracasts
Amazon Aurora MySQL and Amazon RDS MySQL (Japanese)
Amazon Web Services via AWS Skill Builder