Migrating Client Applications


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description
Connection strings are used to allow client applications to interact with Azure SQL databases. This course covers the application connections strings, as well as the Azure Traffic Manager, which is used to control the distribution of incoming user traffic. In addition, this course covers the various types of application patterns available for SQL Server-based applications in an Azure environment. This course is one of a series of courses that cover the objectives for the 70-765: Provisioning SQL Databases exam.

Target Audience
SQL Server database administrators and application developers

Prerequisites
None

Expected Duration (hours)
1.4

Lesson Objectives

Migrating Client Applications

  • start the course
  • explain the role of connection strings
  • describe the use of connection strings in Azure
  • discuss how to create connection strings for Azure storage accounts
  • create a connection string using a shared access signature
  • create a connection string to an explicit storage endpoint
  • parse a connection string from a configuration file
  • develop application retry connection logic
  • describe the different options for distributing network traffic using Azure
  • describe the traffic manager feature found in Azure
  • explain the priority traffic routing method
  • explain the weighted traffic routing method
  • explain the performance traffic routing method
  • describe the 1-tier application pattern
  • explain the 3-tier application pattern
  • explain the presentation tier scale out application pattern
  • describe the business tier scale out application pattern
  • describe the 2-tier and 3-tier presentation and business tiers scale out and HADR application pattern
  • describe the 2-tier and 3-tier using the Azure VMs and Cloud services application pattern
  • explain the N-Tier hybrid application pattern
  • demonstrate how to create a traffic manager profile

    • Course Number:
    df_sqlp_a10_it_enus

    Expertise Level
    Intermediate