In this instructor-led, online training course, students will learn 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.
Overview
Skills Learned
After completing this online training course, students will be able to:
Understand the differences between Azure SQL offerings and how best to leverage their features
Implement a secure database environment
Monitor database and server performance
Optimize database and server performance
Automate database tasks
Implement high availability and disaster recovery
Use T-SQL to perform database administration tasks
- Students who want to become an Azure SQL Database administrator
- Those preparing for Microsoft’s DP-300 exam
None but we recommend general knowledge of Relational Database concepts.
01. Plan and implement data platform resources
- Deploy IaaS solutions with Azure SQL
- Deploy PaaS Azure SQL
- Migrate to Azure SQL
- Migrate SQL Workloads to Azure SQL
- Migrate SQL Workloads to Azure Managed Instance
02. Implement a secure environment
- Configure database authentication and authorization
- Data encryption – At rest vs in-flight
- Implement compliance controls for sensitive data
03. Configure, monitor and optimize database resources in Azure
- Performance monitoring
- Configure SQL Server resources for optimal performance
- Configure databases for optimal performance
04. Configure and manage automation of tasks
- Automate deployment of database resources
- Create and manage SQL Agent jobs
- Manage Azure PaaS tasks using automation
05. Plan and configure a high availability and disaster recovery (HA/DR) environment
- Describe high availability and disaster recovery strategies
- Explore IaaS and PaaS solutions for high availability and disaster recovery
- Backup and restore
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Understand the differences between Azure SQL offerings and how best to leverage their features
Implement a secure database environment
Monitor database and server performance
Optimize database and server performance
Automate database tasks
Implement high availability and disaster recovery
Use T-SQL to perform database administration tasks
WHO SHOULD ATTEND
- Students who want to become an Azure SQL Database administrator
- Those preparing for Microsoft’s DP-300 exam
PREREQUISITES
None but we recommend general knowledge of Relational Database concepts.
COURSE OUTLINE
01. Plan and implement data platform resources
- Deploy IaaS solutions with Azure SQL
- Deploy PaaS Azure SQL
- Migrate to Azure SQL
- Migrate SQL Workloads to Azure SQL
- Migrate SQL Workloads to Azure Managed Instance
02. Implement a secure environment
- Configure database authentication and authorization
- Data encryption – At rest vs in-flight
- Implement compliance controls for sensitive data
03. Configure, monitor and optimize database resources in Azure
- Performance monitoring
- Configure SQL Server resources for optimal performance
- Configure databases for optimal performance
04. Configure and manage automation of tasks
- Automate deployment of database resources
- Create and manage SQL Agent jobs
- Manage Azure PaaS tasks using automation
05. Plan and configure a high availability and disaster recovery (HA/DR) environment
- Describe high availability and disaster recovery strategies
- Explore IaaS and PaaS solutions for high availability and disaster recovery
- Backup and restore
