Create SQL Database on Azure from scratch and Create a Table and insert some data

I know many of you will think it is a very simple tutorial but when i have started learning azure it took me some time to grab all of these concepts so here i have made a short tutorial for you so that you can create your very own azure sql database , create your first table on azure and write some data and request the data.

1. CREATE A RESOURCE GROUP

we will first create a resource group to put all the resources in one place.It is like a folder to put all your resources.Choose any name and a nearby region.

2. CREATE A SQL DATABASE AND A SQL SERVER

once the resource group is created open the resources group and click on add resources and search SQL database

after the search is done click on create a sql database. In this Choose a resource group, choose a name for your database and create a new server for your database.

Server is created to host the SQL database. Server is like a system which will run our database in future we can host multiple databases on a single server

3. OPEN THE DATABASE QUERY EDITOR

when the database is created click on the left side query editor to write all the sql queries. It will ask you for the server credentials .

4. CREATE A TABLE,INSERT SOME DATA AND VIEW THE CONTENT

now we will write the very basic SQL query we will create a table with two column ID and EmployeeName. Hope you now the basic SQL or you can go to WSchools and learn.

now insert some record in the table

now view all the record in our case we have just entered one record and we will be viewing that

Conclusion:-

so this is the basic tutorial to create a database if you have any query regarding this just drop a comment down below. I would love to help you out. My next article will be based on connecting this sql database to visual studio so that you can write all your queries directly on visual studio.