Vendor:
Microsoft 
Duration:
4 days
Category:
This training provides you with the knowledge and skills to manage a SQL Server database infrastructure for cloud, on-premise, and hybrid relational databases, and those working with the Microsoft PaaS relational database offering. The material and labs are also useful when you develop applications that deliver content from SQL-based relational databases.
Lab : Using the Azure Portal and SQL Server Management Studio
Provision a SQL Server on an Azure Virtual Machine
Connect to SQL Server and Restore a Backup
Lab : Deploying Azure SQL Database
Deploy a VM using an ARM template
Configure resources needed prior to creating a database
Deploy an Azure SQL Database
Register the Azure SQL Database instance in Azure Data Studio and validate connectivity
Deploy PostgreSQL or MySQL using a client tool to validate connectivity
Lab : Implement a Secure Environment
Configure a server-based firewall rule using the Azure Portal
Authorize Access to Azure SQL Database with Azure Active Directory
Enable Advanced Data Security and Data Classification
Manage access to database objects
Lab : Monitor and Optimize Resources
Isolate CPU Problems
Use Query Store observe blocking problems
Detect and correct fragmentation issues
Lab : Query Performance Troubleshooting
Identify issues with database design AdventureWorks2017
Isolate problem areas in poorly performing queries in AdventureWorks2017
Use Query Store to detect and handle regression in AdventureWorks2017
Use query hints to impact performance in AdventureWorks2017
Lab : Automating Tasks
Deploy an Azure template from a Quickstart template on GitHub
Configure notifications based on performance metrics
Deploy an Azure Automation Runbook (or elastic job) to rebuild indexes on an Azure SQL Database
Lab : Plan and Implement a High Availability and Disaster Recovery Environment
Create an Always On Availability Group
Enable Geo-Replication for Azure SQL Database
Backup to URL and Restore from URL
This training provides you with the knowledge and skills to manage a SQL Server database infrastructure for cloud, on-premise, and hybrid relational databases, and those working with the Microsoft PaaS relational database offering. The material and labs are also useful when you develop applications that deliver content from SQL-based relational databases.
Lab : Using the Azure Portal and SQL Server Management Studio
Provision a SQL Server on an Azure Virtual Machine
Connect to SQL Server and Restore a Backup
Lab : Deploying Azure SQL Database
Deploy a VM using an ARM template
Configure resources needed prior to creating a database
Deploy an Azure SQL Database
Register the Azure SQL Database instance in Azure Data Studio and validate connectivity
Deploy PostgreSQL or MySQL using a client tool to validate connectivity
Lab : Implement a Secure Environment
Configure a server-based firewall rule using the Azure Portal
Authorize Access to Azure SQL Database with Azure Active Directory
Enable Advanced Data Security and Data Classification
Manage access to database objects
Lab : Monitor and Optimize Resources
Isolate CPU Problems
Use Query Store observe blocking problems
Detect and correct fragmentation issues
Lab : Query Performance Troubleshooting
Identify issues with database design AdventureWorks2017
Isolate problem areas in poorly performing queries in AdventureWorks2017
Use Query Store to detect and handle regression in AdventureWorks2017
Use query hints to impact performance in AdventureWorks2017
Lab : Automating Tasks
Deploy an Azure template from a Quickstart template on GitHub
Configure notifications based on performance metrics
Deploy an Azure Automation Runbook (or elastic job) to rebuild indexes on an Azure SQL Database
Lab : Plan and Implement a High Availability and Disaster Recovery Environment
Create an Always On Availability Group
Enable Geo-Replication for Azure SQL Database
Backup to URL and Restore from URL
Train smarter, not harder. TSTC's unique approach guarantees the effective acquisition of skills and the greatest chance of success.
Learn more about TSTC
