Creating Azure SQL Database - Try It Yourself

Creating Azure SQL Database

📖 Scenario: You are setting up a simple Azure SQL Database to store customer data for a small business. This database will be used by the company's web application to save and retrieve customer information securely.

🎯 Goal: Build an Azure SQL Database resource using Azure Resource Manager (ARM) template syntax step-by-step. You will create the database server, configure the database, and finalize the deployment configuration.

📋 What You'll Learn

Create an Azure SQL Server resource with a specific name and location

Add an Azure SQL Database resource linked to the server

Configure the database with a basic performance tier

Complete the ARM template with necessary properties for deployment

💡 Why This Matters

🌍 Real World

Azure SQL Databases are widely used to store application data in the cloud with managed infrastructure.

💼 Career

Knowing how to define and deploy Azure SQL resources is essential for cloud engineers and developers working with Microsoft Azure.

1

Create Azure SQL Server resource

Create a resource dictionary called azure_resources with one entry for an Azure SQL Server. The server must have type set to "Microsoft.Sql/servers", name set to "myserver123", and location set to "eastus". Include an empty properties dictionary.

Azure

# Your code here

Need a hint?

Think of azure_resources as a dictionary holding your cloud resources. Start by adding the SQL Server with the exact keys and values.

2

Add Azure SQL Database resource

Add a new entry to azure_resources called sqlDatabase. This should be a dictionary with type set to "Microsoft.Sql/servers/databases", name set to "myserver123/mydatabase", location set to "eastus", and an empty properties dictionary.

Azure

azure_resources = {
    "sqlServer": {
        "type": "Microsoft.Sql/servers",
        "name": "myserver123",
        "location": "eastus",
        "properties": {}
    }
}
# Add sqlDatabase resource here

Need a hint?

Remember to add the database as a new key in the azure_resources dictionary with the exact structure.

3

Configure database performance tier

Inside the properties dictionary of sqlDatabase, add a key sku with a dictionary value containing name set to "Basic" and tier set to "Basic".

Azure

azure_resources = {
    "sqlServer": {
        "type": "Microsoft.Sql/servers",
        "name": "myserver123",
        "location": "eastus",
        "properties": {}
    },
    "sqlDatabase": {
        "type": "Microsoft.Sql/servers/databases",
        "name": "myserver123/mydatabase",
        "location": "eastus",
        "properties": {
            # Add sku configuration here
        }
    }
}

Need a hint?

The sku property defines the performance level. Use the exact keys and values as shown.

4

Finalize ARM template structure

Wrap the azure_resources dictionary inside a new dictionary called arm_template with a key resources that holds a list of the two resource dictionaries (sqlServer and sqlDatabase).

Azure

azure_resources = {
    "sqlServer": {
        "type": "Microsoft.Sql/servers",
        "name": "myserver123",
        "location": "eastus",
        "properties": {}
    },
    "sqlDatabase": {
        "type": "Microsoft.Sql/servers/databases",
        "name": "myserver123/mydatabase",
        "location": "eastus",
        "properties": {
            "sku": {
                "name": "Basic",
                "tier": "Basic"
            }
        }
    }
}
# Wrap azure_resources in arm_template with resources list

Need a hint?

The ARM template expects a list of resources under the resources key. Put both server and database inside that list.