 Hey guys, welcome to SSU Intellect Social Decide and this is continuation of azure tutorial. So today we are going to see how we can create the azure SQL account and how we can create the azure SQL databases as well. So go to on the browser and we will try to create that. So here we are in the browser, in the top side we can search for the SQL. So that you can see the option for SQL Server, SQL databases or we can search for the azure SQL. So that option is here. So we want to create a azure SQL Server. So we can click on this. So as of now we don't have any SQL Server there. So let me click on this create and we will try to create now. Here we can see we are how to use this. So first we can see the SQL databases. That is the SQL Managed Instance and third is the SQL Virtual Machine. So these three flavors are available for the azure SQL. So let me going to use the single database and in the single database we can see the option for the Elastic Pool database server. So I am going to use as a single database inside the SQL databases. Let me click on the create. Now it is going to ask create the SQL database. So here we can see we have to select the resource group under which we want to create it. So we are having this ADF training so we can select that and we can go down on this. Here we need to specify the database name and the server name. Now I am going to specify the database name as SSU and inside the server name as we can see we don't have any server yet. So we have to create a server so click on this create new. We need to enter the server name here. So SSU will be the server name so we can see all good. Now below of this we can see the option for the use SQL authentication. Use only as your active directory use both SQL and as your active directory authentication. So I am going to use the use SQL authentication. Here we can enter the login id. So I am going to write this as pvi and in the password I am going to enter some password here and again I am going to write the same password. Now we can click on OK so it will take little bit time. Now here we are having this review and create option. Now we can see the compute and storage. So here let me go on the configure database option. So here we have to select the purchasing model. So inside the purchasing model if you want to change the configuration as of now we can see it is very high configuration using and we have to spend this much amount on the monthly basis. So I am not going to use this I am going to create this only for the testing purpose we can go here and here we can see the option for the serverless. I am going to use this serverless and after that we are good with all these. Now let me click on the apply. So this has been changed with the serverless and here other information is available. Now we can see in the town side in the backup storage where we want to keep the backup locally, zone or geography wise. So I am going to keep it as geography wise and other things are good. Now we can click on the review and create. Now here we can see the product details everything that we can see the this much amount we have to spend for the storage and this compute cost that we can see in the per second. Everything looks good. Now we can click on the create it will take a little bit time to create it. We can wait as we can see it is validating here in the right side. You can see the submitting deployment it will take a little bit time. Deployment is in progress. So here we can see the SS unit tech which is in progress status is accepted. So now you can see deployment is completed. So now go back to the home and here you can see this is created. Let me click on this. So now you can see this is SSU and that is SQL Server Database. Now you can see here we are having the option for query editor preview. We can click on that. Now we need to connect. So we have to enter the password here and click on OK. So here you can see it is going to say cannot open the server SS unit tech by this IP. So it is not allowed with this IP due to the firewall setting rule for the master database. Now we need to add this. So here it is updating the server firewall rules. So it is added successfully. Now let me click on OK. So now it will be connected. So here it is connected as we don't have any table here that you can see. So let me try to create a table. So create table. Table name will be like employee and it will be having EMP ID as integer EMP name will be where care and this would be 50. If we run this so one table should be created. So go here try to refresh it again. We can see this table and if you want to insert the data in this then we can also insert the data from here like inserting to this and we can add one comma. We can add the name with Susie. Let me run this. So it is got fail due to we did not specify when this here. Let me run it again. So one rows are added. So that looks good. Now let me go and try to select this table and we will see the data in it. So select a stick from the table. Run this. So we can see we have one data like EMP ID 1 and name is Susie and in the message we can see a vector rows is one. So we have successfully configured the SQL server and we have also created the database under that. So I hope guys you have understand how we can create it. If you really like this video please subscribe our channel to get many more videos. Don't forget to press the bell icon to get the notification of our newly uploaded videos. See you in the next video.