Applied Skills
Microsoft Learn
Provision a SQL Server on an Azure Virtual MachineCompare on-premises Azure costsDeploy an Azure SQL DatabaseIdentify compatibility issuesMigrate a SQL Server database to Azure SQL DatabaseMigrate a SQL Server database to Azure SQL Managed InstanceMigrate SQL Server databases to SQL Server on Azure Virtual MachineAccess to Azure SQL Database with Microsoft Entra IDConfigure a server-based firewall rule using the Azure portalEnable Microsoft Defender for SQL and Data ClassificationIsolate problems with monitoringDetect and correct fragmentation issuesIdentify and resolve blocking issuesIdentify database design issuesIsolate problem areas in poorly performing queriesDiagnose a slow query and generate a fix with CopilotDeploy an Azure SQL Database using an Azure Resource Manager templateCreate a CPU status alert for a SQL ServerDeploy an automation runbook to automatically rebuild indexesConfigure geo replication for Azure SQL DatabaseBackup to URLDeploy Azure Arc-enabled data services - directly connected modeWork with SQL Database in Microsoft FabricImplement a Geo-Distributed SolutionCreate SQL Server VM with PowerShellEnable Periodic Assessment and Scheduled Patching Using a PolicyAzure Resource Manager: Create a single databaseCreate, configure, and manage elastic jobsAzure Resource Manager: Create an Azure SQL Managed InstanceCreate Azure SQL Managed InstanceConfigure Availability Groups for SQL Server on RHEL Virtual Machines in Azure - Linux Virtual MachinesConfigure availability groups for SQL Server on SLES virtual machines in Azure - Linux virtual machinesConfigure an Availability Group for SQL Server on Ubuntu Virtual Machines in Azure - Linux Virtual MachinesTutorial to assess SQL instances for migration to SQL Server on Azure VM, Azure SQL Managed Instance and Azure SQL DatabaseConfigure geo-replication for Azure SQL DatabaseCreate a watcher to monitor Azure SQLEnable Microsoft Entra-Only AuthenticationCreate and Utilize Microsoft Entra Server LoginsAssign Directory Readers Role to a Microsoft Entra Group and Manage Role AssignmentsCreate Microsoft Entra Users Using Service PrincipalsT-SQL Tutorial: Configure permissions on db objectsCreate a server-level firewall rule in the Azure portalGetting started using Always Encrypted with secure enclaves in SQL ServerGetting started using Always Encrypted with secure enclaves in SQL Server with attestation using HGSGetting started with Always Encrypted - SQL ServerGetting Started Using Always Encrypted with VBS EnclavesCreate a private endpoint - BicepCreate a private endpointCreate a private endpoint (quickstart)Create a private endpoint - ARM templateBack Up SQL Server Databases to AzureExtended EventsDatabase Engine Tuning AdvisorUsing automation to set up the Microsoft Entra admin for SQL ServerBackup & restore to Azure Blob StorageBack Up and Restore a Database by Using SSMSGeo-replication & failover in portalConfigure a SQL Server Always on Availability Group
