Meer informatie en/of de actuele prijs van deze training opvragen is zo geregeld. We houden hierbij rekening met eventuele lopende acties, subsidies of relatiekortingen.
Vendor:
Microsoft 
Duur:
4 dagen
Categorie:
Deze training geeft je de kennis en vaardigheden om een SQL Server-database-infrastructuur te beheren voor cloud-, on-premise en hybride relationele databases en die werken met het Microsoft PaaS relationele database-aanbod. De stof en labs zijn ook nuttig wanneer je applicaties ontwikkelt die content leveren vanuit SQL-based relationele databases
Deze training bereidt je voor op het bijbehorende en inbegrepen DP-300 Administering Relational Databases on Microsoft Azure examen. Wanneer je slaagt voor dit examen, behaal je de titel Microsoft Certified: Azure Database Administrator Associate.
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
Deze training geeft je de kennis en vaardigheden om een SQL Server-database-infrastructuur te beheren voor cloud-, on-premise en hybride relationele databases en die werken met het Microsoft PaaS relationele database-aanbod. De stof en labs zijn ook nuttig wanneer je applicaties ontwikkelt die content leveren vanuit SQL-based relationele databases
Deze training bereidt je voor op het bijbehorende en inbegrepen DP-300 Administering Relational Databases on Microsoft Azure examen. Wanneer je slaagt voor dit examen, behaal je de titel Microsoft Certified: Azure Database Administrator Associate.
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 slimmer, niet harder. TSTC's unieke werkwijze garandeert het effectief opdoen van skills én de grootste kans van slagen.
Lees meer over TSTC
