MCSA Training : Azure

Design and implement Database Solutions for Microsoft SQL Server and Microsoft Azure SQL Database (20-25%)

Design a hybrid SQL Server solution

  • Design a Disaster Recovery topology for a hybrid deployment, design a data storage architecture, design a security architecture, design a data load strategy, design a data synchronisation strategy

Implement SQL Server on Azure Virtual Machines (VMs)

  • Provision SQL Server on an Azure VM, configure firewall rules, configure and optimise storage, migrate an on-premises database to Microsoft Azure, configure and optimise VM sizes by workload

Design a database solution on Azure SQL database and SQL Server in Azure

  • Design a solution architecture, design a Geo/DR topology, design a security architecture, design a data load strategy, determine the appropriate service tier, determine the appropriate deployment scenario, determine IaaS vs PaaS, determine application access in Azure

Implement Azure SQL Database

  • Provision Azure SQL Database, configure firewall rules, configure Active Geo-Replication, migrate an on-premises database to SQL Database, configure for scale and performance

Design and implement MySQL and PostgreSQL database solutions in Azure

  • Design security, design a data load strategy, determine the appropriate service tier, provision databases and servers, configure firewall rules, migrate to Azure, configure for scale and performance

Design and Implement Security (25–30%)

Design and implement SQL Server Database security

  • Configure firewalls; manage logins, users, and roles; assign permissions; configure auditing; configure Transparent Database Encryption (TDE); configure row-level security; configure data encryption; configure data masking; configure Always Encrypted

Design and implement Azure SQL Database security

  • Configure firewalls; manage logins, users, and roles; assign permissions; configure auditing; configure row-level security; configure data encryption; configure data masking; configure Always Encrypted, configure Automatic Threat Detection

Design for high availability, disaster recovery and Scalability (25–30%)

Design and implement high availability solutions

  • Design a high-availability solution topology, design a high-availability solution for SQL on Azure VMs, implement high-availability solutions

Design and implement scalable solutions

  • Design a scale-out solution, implement multi-master scenarios with database replication, implement elastic scale for Azure SQL Database

Design and implement Azure SQL Database data recovery

  • Implement self-service restore, copy and export databases, implement long-term retention backups

Monitor and manage database implementations in Azure (25–30%)

Monitor and troubleshoot SQL Server VMs on Azure

  • Monitor database and instance activity, monitor by using DMVs and DMFs, monitor performance and scalability

Monitor and troubleshoot SQL Database

  • Monitor and troubleshoot SQL Database, monitor database activity, monitor by using DMVs and DMFs, monitor performance and scalability

Automate and manage database implementations on Azure

  • Automate and manage SQL Server on Azure VMs, automate and manage Azure SQL Database, configure automation and runbooks
 
Register Today  Other Popular Courses: SQL DBA Training, MSBI Training, SSIS Training, SSAS Training, SSRS Training [+] More Courses

Job-Oriented Real-time Training @ SQL School Training Institute - Trainer: Mr. Sai Phanindra T [ 13+ Yrs of Technical Expertise, Microsoft Certified Trainer ]

 

Other Trainings

 
 
 
24x7 LIVE Online Server (Lab) with Real-time Databases. Course includes ONE Real-time Project. Register Today