Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-800-268-7737 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

MOD+DMOC: Architecting Microsoft Azure Solutions (M20535)

Deploy Azure solutions using built-in DevOps tools such as Azure Resource Manager templates

GK# 5487

Course Overview

TOP

This course is intended for architects who have experience building infrastructure and applications on the Microsoft Azure platform. Students should have a thorough understanding of most services offered on the Azure platform. The students typically work for organizations that have an active solution on Azure and are planning to enhance existing solutions or deploy more solutions to the Azure platform. This course also is intended for architects who want to take the Microsoft Certification exam, 70-535, Architecting Microsoft Azure Solutions.

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP
  • Describe Azure architecture components, including infrastructure, tools, and portals.
  • Create and deploy Azure Resource Manager (ARM) templates for various all-up solutions.
  • Compare and contrast various infrastructure, serverless, database and communication services; such as App Services, Virtual Machine Scale Sets, Azure Cosmos DB, SQL Database, and Container Service in Azure.
  • Incorporate various Azure platform services, such as Cognitive Services and Media Servicers into an overall Azure solution.
  • Secure, monitor and backup solutions deployed to Azure.
  • Create automated DevOps solutions using a combination of ARM templates, configuration management utilities, Azure CLI, and the Cloud Shell.

Outline

TOP
Viewing outline for:

On-Demand Outline

1. SQL Server Security

  • Authenticating connections to SQL Server
  • Authorizing logins to access databases
  • Authorization across servers
  • Partially contained databases

2. Assigning Server and Database Roles

  • Working with server roles
  • Working with fixed database roles
  • Creating user-defined database roles

3. Authorizing Users to Access Resources

  • Authorizing user access to objects
  • Authorizing users to execute code
  • Configuring permissions at the schema level

4. Protecting Data with Encryption and Auditing

  • Options for auditing data access in SQL Server
  • Implementing SQL Server audit
  • Managing SQL Server audit
  • Protecting data with encryption

5. Recovery Models and Backup Strategies

  • Understanding Backup strategies
  • SQL Server transaction login
  • Planning a SQL Server backup strategy

6. Backup of SQL Server Databases

  • Backing up databases and transaction logs
  • Managing database backups
  • Working with backup options

7. Restoring SQL Server 2016 Databases

  • The restore process
  • Restoring databases
  • Working with point-in-time recovery
  • Advanced Restore Scenarios

8. Automating SQL Server Management

  • Working with SQL Server agent
  • Managing SQL Server agent jobs
  • Multiserver management
  • 9. Configuring Security for SQL Server Agent
  • SQL Server Agent Security
  • Configuring credentials
  • Configuring proxy accounts

10. Monitoring SQL Server with Alerts and Notifications

  • Configuring database mail
  • Monitoring SQL Server errors
  • Configuring operators, alerts and notifications
  • Alerts in Azure SQL database

11. Introduction to Managing SQL Server by Using PowerShell

  • Configure SQL Server using PowerShell
  • Administer  and Maintain SQL Server using PowerShell
  • Managing Azure SQL Server databases using PowerShell

12. Tracing Access to SQL Server with Extended Events

  • Extended Events Core Concepts
  • Working with Extended Events

13. Monitoring SQL Server

  • Monitoring activity
  • Capturing and managing performance data
  • Analyzing collected performance data
  • SQL Server utility

14. Troubleshooting SQL Server

  • SQL Server troubleshooting methodology
  • Resolving service related issues
  • Resolving login and connectivity issues

15. Importing and Exporting Data

  • Transferring data to/from SQL Server
  • Importing and exporting table data
  • Using BCP and BULK INSERT to import data
  • Deploying and upgrading data-tier applications

 

Labs

TOP
Viewing labs for:

On-Demand Labs

Lab 1: Authenticating Users
Lab 2: Assigning Server and Database Roles
Lab 3: Authorizing Users to Access Resources
Lab 4: Using Auditing and Encryption
Lab 5: Understanding SQL Server Recovery Models
Lab 6: Backing Up SQL Server Databases
Lab 7: Restoring SQL Server User Databases
Lab 8: Automating SQL Server Management
Lab 9: Configuring Security for SQL Server Agent
Lab 10: Monitoring SQL Server with Alerts and Notifications
Lab 11:  Using PowerShell to Manage SQL Server
Lab 12: Extended Events
Lab 13: Monitoring SQL Server
Lab 14: Troubleshooting Common Issues
Lab 15: Importing and Exporting Data

Prerequisites

TOP
  • Create resources and resource group in Azure.
  • Manage users, groups, and subscriptions in an Azure Active Directory instance.
  • Build an Azure Virtual Machine with related resources.
  • Manage containers and blobs stored in an Azure Storage account.
  • Create App Service Plans and manage apps related to the plan.
  • Configure an Azure Virtual Network and enable S2S and P2S connectivity.
  • Protect networked application components using Network Security Groups.
  • Automate everyday Azure resource tasks using Azure CLI or Azure PowerShell.
  • Deploy an Azure SQL, MySQL, Postgres or Cosmos database instance.
  • Monitor existing Azure solutions using built-in metrics, Application Insights, or Operational Insights.
  • Monitor existing Azure solutions using built-in metrics, Application Insights, or Operational Insights.

Who Should Attend

TOP

This course is intended for students who have experience building infrastructure and applications on the Microsoft Azure platform. Students should have a thorough understanding of most services offered on the Azure platform.

For the interactive component, this course offers students the opportunity to deploy Azure solutions using built-in DevOps tools such as Azure Resource Manager templates, deployments, resource groups, tags and Role-Based Access Control.

This course does not require any direct experience writing application code or configuring server machines. This course focuses on the architectural comparisons between services and technical decision making needed to deploy well-designed solutions on the Azure platform. This course also prepares the students for the 70-535: Architecting Microsoft Azure Solutions certification exam.

The candidates targeted by this training have intermediate experience in designing, implementing and monitoring Azure solutions.  Candidates are also proficient with the tools, techniques, and approaches used to build solutions on the Azure platform.

Training Exclusives

This course comes with 12 months access to the following benefits:

  • Practice Labs
  • 24x7 Mentoring
  • Indexed Class Recordings
  • Unlimited Course Retakes
  • Digital courseware
Find out more
Course Delivery

This course is available in the following formats:

On-Demand

Train at your own pace with 24/7 access to courses that help you acquire must-have technology skills.



Request this course in a different delivery format.
Enroll