Course details

Migrating Client Applications

Migrating Client Applications

Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level

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


Expected Duration (hours)

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:

    Expertise Level