Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

CloudLabs Shop

0

DP-300 Administering Relational Databases on Microsoft Azure

0.0
(0)
15 Labs

This track consists of 15 labs, each provided as a separate lab instance, and has to be completed in one uninterrupted session. Once you launch a lab, your session time begins. The estimated duration to complete each lab is around 1 hour. This track and all associated labs will be available for 30 days once you redeem the voucher code. After 30 days, all labs and related data will be automatically deleted from the CloudLabs portal.

About Course

Introducing DP-300 Hands-on Lab, an immersive and comprehensive learning experience offered by CloudLabs. This lab is specifically designed to provide participants with practical knowledge and skills in implementing and managing Azure data solutions. The lab focuses on key data platform management concepts such as backup and restore, monitoring, and troubleshooting. Participants will gain practical skills in implementing backup and restore strategies, monitoring and optimizing database performance using Azure Monitor and Azure SQL Database Advisor, and troubleshooting common data platform issues.
During the lab, participants will have the opportunity to explore various aspects of data platform implementation, including provisioning and managing databases, implementing data security, and optimizing performance. They will gain hands-on experience in tasks such as deploying and configuring Azure SQL Database, implementing security measures such as encryption and auditing, and optimizing database performance.

Hands-on Labs Covered

  • Provision a SQL Server on an Azure Virtual Machine
  • Provision an Azure SQL Database
  • Authorize access Azure SQL database
  • Configure Azure SQL Database firewall rules
  • Enable Microsoft Defender for SQL and Data Classification
  • Isolate performance problems through monitoring
  • Detect and correct fragmentation issues
  • Identify and resolve blocking issues
  • Identify database design issues
  • Isolate problem areas in poorly performing queries in a SQL Database
  • Deploy an Azure SQL Database from a template
  • Create a CPU status alert for a SQL Server
  • Deploy an automation runbook to automatically rebuild indexes
  • Configure geo-replication for Azure SQL Database
  • Backup to URL and Restore from URL

Audience

  • Database Administrators

No Review Yet
No Review Yet