Connection from applications in Azure - Mini Project: Build & Apply

Connection from applications

📖 Scenario: You are setting up a simple Azure environment where an application needs to connect to an Azure SQL Database securely. This project will guide you through creating the necessary resources and configuring the connection string for the application.

🎯 Goal: Build an Azure SQL Database and configure a connection string in an application configuration dictionary to enable secure connection from the application.

📋 What You'll Learn

Create a dictionary called azure_resources with keys for server_name, database_name, and resource_group with exact values.

Add a configuration variable called connection_timeout set to 30 seconds.

Create a connection string called connection_string using the values from azure_resources and connection_timeout.

Add the connection_string to an application configuration dictionary called app_config.

💡 Why This Matters

🌍 Real World

Applications often need to connect to cloud databases securely. This project shows how to prepare connection details and configuration in code.

💼 Career

Cloud engineers and developers must configure connection strings and manage resource details to enable application connectivity to cloud services.

1

Create Azure resource details

Create a dictionary called azure_resources with these exact entries: 'server_name': 'myazuresqlserver', 'database_name': 'appdb', and 'resource_group': 'myresourcegroup'.

Azure

# Create the azure_resources dictionary with server_name, database_name, and resource_group
# Your code here

Need a hint?

Use curly braces to create a dictionary with the exact keys and values.

2

Add connection timeout configuration

Add a variable called connection_timeout and set it to 30 (seconds).

Azure

azure_resources = {
    'server_name': 'myazuresqlserver',
    'database_name': 'appdb',
    'resource_group': 'myresourcegroup'
}
# Set connection_timeout to 30 seconds
# Your code here

Need a hint?

Just assign the number 30 to the variable connection_timeout.

3

Create the connection string

Create a variable called connection_string that uses f-string formatting to combine azure_resources['server_name'], azure_resources['database_name'], and connection_timeout into this exact format: Server=myazuresqlserver.database.windows.net;Database=appdb;Connection Timeout=30;

Azure

azure_resources = {
    'server_name': 'myazuresqlserver',
    'database_name': 'appdb',
    'resource_group': 'myresourcegroup'
}
connection_timeout = 30
# Create connection_string using f-string formatting
# Your code here

Need a hint?

Use an f-string with curly braces to insert the dictionary values and timeout into the string.

4

Add connection string to application config

Create a dictionary called app_config with a key 'connection_string' and assign it the value of the connection_string variable.

Azure

azure_resources = {
    'server_name': 'myazuresqlserver',
    'database_name': 'appdb',
    'resource_group': 'myresourcegroup'
}
connection_timeout = 30
connection_string = f"Server={azure_resources['server_name']}.database.windows.net;Database={azure_resources['database_name']};Connection Timeout={connection_timeout};"
# Create app_config dictionary with connection_string key
# Your code here

Need a hint?

Create a dictionary with the key 'connection_string' and assign the existing variable to it.