From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press
Unlock this course with a free trial
Join today to access over 24,900 courses taught by industry experts.
Automate deployment using Azure CLI
From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press
Automate deployment using Azure CLI
- Welcome back. This is lesson 11.3, automate deployment by using Azure CLI. This is another one we touched on way back in lesson 1.2. The Azure CLI is a cross-platform tool that provides a way to deploy and manage Azure resources through the command line. The CLI is built on the bash shell. If you look at the syntax closely, you'll think that it looks a lot like PowerShell. Not exactly but pretty close. But the goal with the CLI is to simplify the deployment of resources through integration with the Azure resource manager and as well executed via the command line. Microsoft really wanted to emphasize the simplicity of managing resources because they integrated this directly or they integrated the CLI directly into the Azure portal. And this allows you to manage resources via the Azure Cloud Shell. You can also, if you choose, install the Azure CLI locally and manage resources through the command prompt. The emphasis here is for the Azure CLI is that it is optimized for automation and…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
(Locked)
Module introduction1m 18s
-
(Locked)
Learning objectives1m 13s
-
(Locked)
Deploy database offerings on selected platforms19m 4s
-
Understand automated deployment6m 57s
-
(Locked)
Apply patches and updates for hybrid and IaaS deployment4m 25s
-
(Locked)
Deploy hybrid SQL Server solutions7m 4s
-
(Locked)
Recommend an appropriate database offering to meet your needs7m 56s
-
(Locked)
Evaluate security aspects of the possible database offering4m 20s
-
(Locked)
Recommend a table partitioning solution3m 43s
-
(Locked)
Recommend a database sharding solution4m 36s
-
(Locked)
-
-
(Locked)
Learning objectives57s
-
Evaluate requirements for the migration8m 5s
-
(Locked)
Evaluate offline or online migration strategies3m 1s
-
(Locked)
Implement an online migration strategy4m 33s
-
(Locked)
Implement an offline migration strategy6m 29s
-
(Locked)
Perform post-migration validations4m 9s
-
(Locked)
Troubleshoot a migration2m 57s
-
(Locked)
Set up SQL Data Sync for Azure4m 16s
-
(Locked)
Implement a migration to Azure3m 20s
-
(Locked)
Implement a migration between Azure SQL services2m 38s
-
(Locked)
Implement Azure SQL Managed Instance database copy and move5m 58s
-
(Locked)
-
-
(Locked)
Module introduction1m 13s
-
(Locked)
Learning objectives1m 5s
-
(Locked)
Configure authentication with Active Directory and Entra ID2m 28s
-
Create users from Microsoft Entra identities2m 2s
-
(Locked)
Configure security principals2m 44s
-
(Locked)
Configure database and object-level permissions using graphical tools3m 38s
-
(Locked)
Apply the principle of least privilege for all securables2m 2s
-
(Locked)
Troubleshoot authentication and authorization issues3m 38s
-
(Locked)
Manage authentication and authorization using T-SQL3m 1s
-
(Locked)
-
-
(Locked)
Learning objectives55s
-
(Locked)
Implement transparent data encryption (TDE)3m 8s
-
(Locked)
Implement object-level encryption1m 30s
-
(Locked)
Configure server- and database-level firewall rules1m 50s
-
Implement Always Encrypted3m 39s
-
(Locked)
Implement Always Encrypted with VBS enclaves2m 22s
-
(Locked)
Configure secure access1m 23s
-
(Locked)
Configure Transport Layer Security (TLS)1m 47s
-
(Locked)
-
-
(Locked)
Learning objectives1m 9s
-
(Locked)
Apply a data classification strategy5m 11s
-
(Locked)
Configure server and database audits4m 51s
-
Implement data change tracking4m 39s
-
(Locked)
Implement dynamic data masking4m 46s
-
(Locked)
Manage database resources using Microsoft Purview3m 25s
-
(Locked)
Implement database ledger in Azure SQL2m 50s
-
(Locked)
Implement row-level security1m 57s
-
(Locked)
Configure Microsoft Defender for Azure SQL2m 41s
-
(Locked)
-
-
(Locked)
Module introduction1m 25s
-
(Locked)
Learning objectives1m 10s
-
(Locked)
Prepare an operational performance baseline4m 35s
-
(Locked)
Determine sources for performance metrics4m 6s
-
Interpret performance metrics4m 49s
-
(Locked)
Configure and monitor activity and performance3m 48s
-
(Locked)
Monitor by using Azure SQL Database Watcher4m 3s
-
(Locked)
Monitor by using Extended Events5m 24s
-
(Locked)
-
-
(Locked)
Learning objectives1m 37s
-
(Locked)
Configure Query Store4m 27s
-
(Locked)
Monitor by using Query Store4m 19s
-
(Locked)
Identify sessions that cause blocking3m 14s
-
(Locked)
Identify performance issues using DMVs6m 17s
-
(Locked)
Identify and implement index changes for queries5m 2s
-
(Locked)
Recommend query changes based on resource usage2m 34s
-
(Locked)
Assess the use of query hints for query performance3m 52s
-
(Locked)
Review execution plans5m 29s
-
(Locked)
Monitor by using Intelligent Insights2m 16s
-
(Locked)
-
-
(Locked)
Learning objectives1m 43s
-
(Locked)
Implement index maintenance tasks4m 21s
-
(Locked)
Implement statistics maintenance tasks3m 40s
-
(Locked)
Implement database integrity checks4m 53s
-
(Locked)
Configure database automatic tuning1m 29s
-
(Locked)
Configure server settings for performance3m 11s
-
(Locked)
Configure Resource Governor for performance3m 16s
-
Implement database-scoped configuration2m 37s
-
(Locked)
Configure compute and storage resources for scaling2m 43s
-
(Locked)
Configure intelligent query processing (IQP)2m 34s
-
(Locked)
-
-
(Locked)
Module introduction1m 38s
-
(Locked)
Learning objectives1m 8s
-
(Locked)
Strategy based on RPO or RTO requirements4m 22s
-
(Locked)
Evaluate HA or DR for hybrid deployments4m 51s
-
(Locked)
Evaluate Azure-specific HA or DR solutions4m 49s
-
(Locked)
Recommend a testing procedure for an HA/DR solution2m 59s
-
(Locked)
-
-
(Locked)
Learning objectives1m 23s
-
(Locked)
Recommend a database backup and restore strategy4m 30s
-
(Locked)
Perform a database backup using database tools5m 24s
-
(Locked)
Perform a database restore using database tools4m 36s
-
(Locked)
Perform a database restore to a point in time4m 10s
-
Configure long-term backup retention3m 13s
-
(Locked)
Backup and restore a database using T-SQL4m 35s
-
(Locked)
Backup and restore to and from cloud storage6m 21s
-
(Locked)
-
-
(Locked)
Learning objectives1m 29s
-
(Locked)
Configure active geo-replication3m 2s
-
(Locked)
Configure an Always On availability group on Azure Virtual Machines10m 50s
-
(Locked)
Configure failover groups2m 36s
-
Configure quorum options for a Windows Server failover cluster4m 41s
-
(Locked)
Configure Always On failover cluster instances on Azure Virtual Machines5m 19s
-
(Locked)
Configure log shipping6m 58s
-
(Locked)
Monitor an HA/DR solution4m 4s
-
(Locked)
Troubleshoot an HA or DR solution6m 55s
-
(Locked)