Azure Database Admin Associate DP-300 Training
Crafted with meticulous attention to detail by a seasoned industry professional with over 5 years of Azure expertise, the course “Mastering Azure” provides learners with a comprehensive curriculum to acquire comprehensive knowledge and proficiency in this domain. AZURE DP-300 Prepare for the Azure DP 300 certification with the Azure DP-300 training. Learn how to plan and implement data platform resources, secure environment, and high availability and disaster recovery (HADR) environment. The Azure DP-300 training will enable you to monitor and optimize operational resources and query performance, perform automation of tasks and perform administration by using T-SQL.
In This Module We Will Learn :
THE ROLE OF DATABASE ADMINISTRATOR
- Azure data platform roles
- Azure database platforms and options
- SQL Server compatibility level
- Azure preview features
PLAN AND IMPLEMENT DATA PLATFORM RESOURCE
- Deploy resources using manual methods
- Recommend an appropriate database offering based on requirements
- Configure Azure resources
- Evaluate and implement a strategy for moving a database to Azure
IMPLEMENT A SECURE ENVIRONMENT
- Configure database authenticationโฏ
- Configure database permissions
- Implement security for data at restโฏ
- Implement security for data in transit
- Implement compliance controls for sensitive data
MONITOR AND OPTIMIZE OPERATIONAL RESOURCE
- Monitor activity and compare to a baseline
- Define maintenance tasks related to performance
- Identify major causes of performance problems
- Configure resources for optimal performance
- Configure a user database for optimal performance
OPTIMIZE QUERY PERFORMANCE
- Analyze query plans and identify problem areas
- Evaluate potential query improvements
- Review table and index design
- Determine whether a query or design changes have had a positive effect
AUTOMATION OF TASKS
- Deploy Azure Resources using automated deployment scripts
- Create Scheduled Tasks in SQL Server
- Create notifications for failures and performance alerts
- Configure automation for PaaS Services
PLANNING AND IMPLEMENTING A HIGH AVAILABILITY AND DISASTER RECOVERY ENVIRONMENT
- The difference between recovery time and recovery point objectives
- The available HADR options for both IaaS and PaaS
- PaaS platform and database tools for HADR
- Database backup and restore
Course Content
Similar Courses:
Azure Data Engineer DP-203 Training
The Azure Database Engineer Associate DP-203 training prepares you for the Azure DP-203 certification exam.…
Azure AI Fundamentals AI-900 Training
Crafted with meticulous attention to detail by a seasoned industry professional with over 5 years…
Azure Data Fundamentals DP-900 Training
Crafted with meticulous attention to detail by a seasoned industry professional with over 5 years…
Azure Admin Associate AZ-104 Training
Crafted with meticulous attention to detail by a seasoned industry professional with over 5 years…