Description
This course provides students with the knowledge and skills to administer a SQL Server database infrastructure.
This course provides students with the knowledge and skills to administer 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.
Doelstellingen:
– Prepare to maintain SQL databases on Azure
– Deploy IaaS solutions with Azure SQL
– Deploy PaaS solutions with Azure SQL
– Evaluate strategies for migrating to Azure SQL
– Migrate SQL Server workloads to Azure SQL Database
– Migrate SQL workloads to Azure Managed Instances
– Configure database authentication and authorization
– Protect data in-transit and at rest
– Implement compliance controls for sensitive data
– Describe performance monitoring
– Configure SQL Server resources for optimal performance
– Configure databases for optimal performance
– Explore query performance optimization
– Evaluate performance improvements
– Explore performance-based design
– Automate deployment of database resources
– Create and manage SQL Agent jobs
– Manage Azure PaaS tasks using automation
– Describe high availability and disaster recovery strategies
– Explore IaaS and PaaS solutions for high availability and disaster recovery
– Back up and restore databases
Voorkennis:
– Working with, maintaining, and developing with SQL Server
– Experience with Azure, such as deploying and managing resources
In addition to their professional experience, students who take this training should have technical knowledge equivalent to the following courses:
– Azure Fundamentals | AZ-900
– Azure Data Fundamentals | DP-900
Voor wie:
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.
Inhoud:
– Module 1 : Plan and implement data platform resources
– Module 2 : Implement a secure environment for a database service
– Module 3 : Monitor and optimize operational resources in Azure SQL
– Module 4 : Optimize query performance in Azure SQ
– Module 5 : Automate database tasks for Azure SQL
– Module 6 : Plan and implement a high availability and disaster recovery environment
– Module 7 : Configure database authentication and authorization
– Module 8 : Protect data in-transit and at rest
– Module 9 : Implement compliance controls for sensitive data
– Module 10 : Describe performance monitoring
– Module 11 : Configure SQL Server resources for optimal performance
– Module 12 : Configure databases for optimal performance
– Module 13 : Explore query performance optimization
– Module 14 : Evaluate performance improvements
– Module 15 : Explore performance-based design
– Module 16 : Automate deployment of database resources
– Module 17 : Create and manage SQL Agent jobs
– Module 18 : Manage Azure PaaS tasks using automation
– Module 19 : Describe high availability and disaster recovery strategies
– Module 20 : Explore IaaS and PaaS solutions for high availability and disaster recovery
– Module 21 : Back up and restore databases
Exclusief examen:
DP-300 Administering Relational Databases on Microsoft Azure
DutchTrain is een officieel geaccrediteerd Test Center voor Pearson Vue Test, Prometric, Kryterion, Castle Worldwide, Certiport & PSI. U bent bij ons van harte welkom voor examens welke via deze Test Centers beschikbaar zijn. Examens kunnen elke dag, binnen kantooruren, worden afgenomen.
Datum:
Wanneer u op onderstaande link klikt zult u de beschikbare data te zien krijgen.
Bij inschrijving kunt u de gewenste trainingsdata aangeven in het notitieveld.
Kalender Implement scalable database solutions using Azure SQL – DP-300 2026
Duur:
4 dagen
Deze training is ook beschikbaar als:
– Maatwerktraining, neem hiervoor contact op met een van onze opleidingsadviseurs.
Voor veelgestelde vragen tijdens het bestelproces, bekijk onze F.A.Q. pagina.
