One great advantage of the cloud is the ability to utilize Platform as a Service (PaaS) offerings to offload server and database administration, freeing you to focus on what drives success for your business. Azure SQL Database is one such offering. In this scenario, you are the DBA for Awesome Company. You have been tasked with delivering a database backend for a new cloud-native app. This solution should both integrate closely with Azure services and require as little hands-on maintenance as possible, allowing your team to focus on other tasks. Performing the actions of this lab will help you become familiar with how to provision an Azure SQL database.
Successfully complete this lab by achieving the following learning objectives:
- Log in to the Azure Portal
Log in to the Azure Portal using the provided credentials.
- Create an Azure SQL Database
- In the search box at the top of the page, search for "Azure SQL", and click on Azure SQL under Services.
- Click Create Azure SQL resource.
- Under SQL databases, leave Single database as the selection and click Create.
- Select the resource group the lab created for you.
- Provide a database name.
- Under Server, click Create new.
- Provide a server name (which must be globally unique), server admin login, and password.
- Set the location as (US) West US.
- Click OK.
- Under Compute + storage, click Configure database.
- At the top left, click Looking for basic, standard, premium?.
- Select Basic and click Apply.
- Click Review + create.
- Verify all is well and click Create.
- Once the deployment is complete, click Go to resource.
Congratulations! You now have a fully operational SQL Database that is tightly integrated with other Azure services, has its infrastructure fully managed by Microsoft, and has a number of advanced features built right in.