Step 4: Enter a name for resource group, name for database.
Step 5: Click on “Create new” in Server.
Step 6: Now, enter a name in Server name, select Location & Authentication method & click on “OK”.
Step 7: Select Workload environment, Select the size of the database for most student work loads choose the basic (which is the most cost effective & Backup storage redundancy. Click on “Next: Networking >”.
For Database sizes we recommend :
In DTU-based SQL purchase models, a fixed set of resources is assigned to the database or elastic pool via performance tiers: Basic, Standard and Premium. This model is best for customers who prefer the simplicity of fixed payments each month, where the simplicity of pre-configured options is desired. With a cost of $0.0068/hour which is $6.11 per month
Standard-series (Gen 5)
Intel E5-2673 v4 (Broadwell) 2.3 GHz, Intel SP8160 (Skylake), Intel Xeon Platinum 8272CL 2.5 GHz (Cascade Lake) and Intel(R) Xeon Scalable 2.8 GHz processor (Ice Lake) processors. In the standard-series (Gen 5), 1 vCore = 1 hyper thread. The standard-series (Gen 5) logical CPU is great for most relational database servers. and cost approx $0.51/hour
Step 9: Enable Microsoft Defender for SQL & Click on “Next: Additional settings >”
Step 10: Select Data source & Click on “Next: Tags >”
Step 11: Click on “Next: Review + create > here you can can see the costs of the datbase, you can change the size under the basic tab and understand costs of cloud services based on the "Compute Storage size”.
Step 12: Click on “Create”, once you review all the sections.
Step 13: Once the Validation will complete & show message, “your deployment is complete”. Click on “Go to resource".
Now, a tab will open from where you will get options to Configure, connect to application & start developing your application.
Congratulations, you have deployed Azure SQL. If you have any query, feel free to contact.
Want to learn more about SQL Databases, here are some Go to following Microsoft Learn resources and interactive handson labs: