MCSA Training : SQL AZURE

EXAM 70-473 :

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 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 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 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 for Certification Training
 
 

Register today for MCSA Training

 
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 ]

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