Create A SQL Database 🛢️ In Azure Portal

In my previous article, Create a Windows Virtual Machine in Azure Portal, we created a Windows Virtual Machine on the Azure portal. In this article, we will see how to create an SQL database in the Azure portal and create a sample database.
 
Log into Azure Portal and enter your credentials. Once you are logged in, you will be redirected to the dashboard.
 
Create a SQL database in the Azure portal 
 
An Azure SQL database is created within an Azure Resource group and in an Azure SQL Database logical server as well.
 
Steps to create an SQL database
 
Click on SQL databases from the Azure services on the dashboard. 
 
Create a SQL database in the Azure portal 
 
From the Top Action item, click on the "Add" button to create a new SQL Database. You can also click on 'Create SQL database' to create a database.
 
Create a SQL database in the Azure portal 
 
Enter the database name, select subscription (for now, I have selected the Free Trial option). 
 
Create a SQL database in the Azure portal 
 
Select or create a Resource Group in which you want to create the database. You can see here Default-ApplicationInsights-EastUS and virtual Machine 'vmMandvi'.
 
Create a SQL database in the Azure portal 
You can create a blank database or you can use the sample database (AdventureWorksLT). For now, we use AdventureWorksLT for querying.
 
Create a SQL database in the Azure portal
Next, you have to configure the server settings so click on the "Configure required settings" option.
 
Create a SQL database in the Azure portal
Enter the new server details, like Server name, server admin Id and password, and last location for hosting the database. Click "Select". 
 
Create a SQL database in the Azure portal 
 
Click on the "Create" button to complete the set up. 
 
Create a SQL database in the Azure portal
 
 It will take a few minutes to complete the deployment and you can monitor the progress from the notification bell icon.
 
Create a SQL database in the Azure portal
Create a SQL database in the Azure portal
 
Once you get the deployment success message, you can click on 'Go to resource' and from the left navigation, look for the "Query editor".
 
Create a SQL database in the Azure portal 
 
Enter the server credentials that you have entered during the server configuration. 
 
Create a SQL database in the Azure portal 
 
You can see the Tables, Views, and Stored Procedures.
 
Enter the below query in the editor pane and click on "Run". Then, review the query results in the Results pane.
 
select * from SalesLT.Customer;
 
Create a SQL database in the Azure portal
 
Create a SQL database in the Azure portal 
 
Hope you like these easy steps to create the SQL Server Database on Azure. I'm waiting for your feedback or comments in the comment box. 
 
Reference : https://docs.microsoft.com/en-us/azure/sql-database/sql-database-get-started-portal 


Similar Articles