DP-300T00: Implement scalable database solutions using Azure SQL

About this course

This course provides students with the knowledge and skills to create a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases. Audience Profile The audience for this course is data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure. This course is also valuable for data architects and application developers who need to understand what technologies are available for the data platform with Azure and how to work with those technologies through applications.

Instructor-led training for professionals and companies in Chile. Request dates, schedules, seats and commercial terms. Training hours and daily scheduling follow Netsolutions planning and are confirmed in the commercial proposal.

Course syllabus

1. Plan and implement data platform resources
2. Deploy IaaS solutions with Azure SQL
3. Deploy PaaS solutions with Azure SQL
4. Migrate SQL Server workloads to Azure SQL Database
5. Migrate SQL Server workloads to Azure SQL Managed Instance
6. Implement a secure environment for a database service
7. Configure database authentication and authorization
8. Protect data in-transit and at rest
9. Implement compliance controls for sensitive data
10. Monitor and optimize operational resources in Azure SQL
11. Describe performance monitoring
12. Configure SQL Server resources for optimal performance
13. Configure databases for optimal performance
14. Optimize query performance in Azure SQL
15. Explore query performance optimization
16. Explore performance-based database design
17. Evaluate performance improvements
18. Automate database tasks for Azure SQL
19. Automate database deployment
20. Create and manage SQL Agent jobs
21. Manage Azure PaaS tasks using automation
22. Plan and implement a high availability and disaster recovery environment
23. Describe high availability and disaster recovery strategies
24. Explore IaaS and PaaS solutions for high availability and disaster recovery
25. Back up and restore databases