MCSA 2016 Training | MCSA 70-743 Certification Training

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 today for MCSA Training

MCSA Training : SQL AZURE