In this article we will learn to create SQL database using Azure.
Prerequisite: for this, should have Microsoft Azure account. In case don’t have then go to Microsoft site for practice purpose they have given sandbox which can be utilized to create one.
- Once you have Azure account then go to https://portal.azure.com and login.
- Add resource and search SQL ->Click on Azure SQL -> click on Create.

- Click on Create

- Select SQL Database -> Click on Create

- Select Create a resource > Databases > SQL database. Fill in the following information present in below screen shot. As I am creating database in microsoft sandbox so adding below details on it, which is mention by Microsoft. In case your creating your own database then make sure add unique name in server name and server admin login should be unique and remeber password.
Server name: sqlservernnnn (must be unique, replace nnnn with custom value)
Server admin login: sqluser
Password: Pa$$w0rd1234
Location: (US) East US
- Click on OK button, which will create database

- Click on configure database. As per your need select different packages then click on Apply button. As using Microsoft sandbox so leave this as default.

- Click on Next button, select Public endpoint, in case you want to access this database via Azure service then click on Yes to Allow Azure service and resource to access this server. If you want to give access to particular Client IP then click on Yes and add client IP for this. this settings can be done afterwards via setup firewall.

- Click on next button and go to security tab, select Not now,

- Click on additional settings and update below setting add as sample

- Click on review + create, after review you plan click on Create, in case changes in plan please make it.
- It will kick start for create database, it will take approx. 5-10 min to create sample database and deploy it

- Once database created you can go to resource and check it.


- In case not able to access database then click on resource and go to setting then go to set server firewall and add you client IP to access database from your machine or you can use Azure AD for login into database.
- In case you want run some queries on Azure SQL on cloud then you can follow below steps

Type and run query which you want to run to check database running or not.

I have taken refernce from Microsoft learning portal in case more details please check this link. https://docs.microsoft.com/en-us/learn/modules/azure-database-fundamentals/exercise-create-sql-database












