Azure SQL Database Tutorial | Azure SQL Overview | Microsoft Azure Training | Edureka Rewind

Key Takeaways

the question of whether or not to put your business data in the cloud is getting easier and easier these days and a lot of that is thanks to Microsoft's investment in Microsoft azour their strategy is to create an infrastructure like Microsoft Azure SQL database that can manage big data and everything on down from that is working and it's working well the advancements made in SQL database are making it more and more possible for businesses of all sizes to save money and scale up or down efficiently hello everyone this is Dr from edura and I welcome you all to this session where I will be talking about Azure SQL database so without any further Ado let's take a look at today's agenda so we will start this session by first having an overview of Microsoft Azure as well as of a database and Azure SQL family we will then understand the need of azure SQL database and what actually it is as well as its key features and use cases finally we will then deploy the SQL database on Microsoft Azure so first let's get an overview of the Microsoft Azure Microsoft Azo formerly known as Windows azod is Microsoft's public cloud computing platform created by Microsoft for building testing deploying and managing applications and services through Microsoft manage data centers it provides software as a service platform as service and infrastructure as a service that can be used for services such as analytics virtual Computing storage networking and much it can be used to replace or supplement your on premise servers as well as it can support many different programming languages tools and Frameworks including both Microsoft specific and thirdparty software and systems Azure uses large scale virtualization at Microsoft data centers worldwide and it offers more than 600 Services now let's understand and what a database actually is a database is an organized collection of structured information or data typically stored electronically in a computer system a database is usually controlled by a database management system together the data and the database management system along with the applications that are associated with them are referred to as a database system often shortened to just database data within the most common types of databases in operation today is typically modeled in row and columns in a series of tables to make processing and data query efficient the data can then be easily accessed managed modified updated controlled and organized most databases use a structured query language for writing and querying data database are used to support internal operations of organizations and to underpin online interactions with customers and suppliers databases are used to hold administrative information and more specialized data such as engineering data or economic models examples include computerized Library systems flight reservation systems computerized parts inventory system and many content Management systems that store websites as collections of web pages in a database now that you have an overview of azure as well as off a database let's look into the family of azure SQL so first one in the family is SQL server on Virtual machines so with this you can lift and shift your SQL Server workloads to the cloud to get the combined performance security and analytics of SQL server with flexibility and hybrid connectivity of azure with 100% code compatibility access the latest SQL Server updates and releases including SQL Server 2019 register your virtual machines with SQL infrastructure as a service agent extension for automated virtual machine management at no additional cost SQL server on Azure virtual machines is part of the Azure SQL family which allows you to migrate existing apps or build new apps on the best cloud Des destion for a mission critical SQL Server workloads so its features are first of all best TCO that is total cost of ownership with Azure hybrid benefit with Azure SQL Server you can save up to 84% compared to Amazon web services migrating SQL Server databases with Azure hybrid benefit and get free extended support for SQL Server 2008 R2 images in Azure infrastructure as a service activate Azure hybrid benefit when you provision SQL server on Azure virtual machines images from the Azure Marketplace second feature is high performance virtual machines for SQL server on Linux and windows so you can take advantage of SQL Server virtual machines with industry leading performance choose from images with Windows Server redhead Enterprise Linux susc Enterprise Linux server or ubben to Linux gain collocated integrated support for your SQL workloads with redhead and suc the third feature is buil-in security and manageability so you can ease maintenance with automatic security updates and restore your database to a specific point in time with Azure backup help protect your data addressed and in motion with the database stated as least vulnerable over the last 9 years in the cloud with the most global national and Industry certifications second member in the family is azure SQL managed instance so part of the Azure SQL service portfolio Azure SQL managed instance is the intelligent scalable Cloud database service that combines the broadest SQL Server engine compatibility with all the benefits of a fully managed and everen platform as a service with SQL managed instance confidently modernize your existing apps at scale by combining your experience with familiar tools skills and resources and do more with what you already have Azure Arc enabled SQL manage instance is now in preview you can run the service on premise on any infrastructure of your choice with Azure Cloud benefits like elastic scale unified management and a cloud building module while staying always current some of features are always operate on the latest version of SQL so SQL manage instance is built on the SQL Server engine it's overgreen meaning it's always up to date with the latest SQL features and functionality never worry about updates upgrades or end of support again second is fully managed and optimized for DBA productivity so boost productivity and operate more efficiently by letting the service perform timec consuming and complex tasks on your behalf features like built-in High availability disaster recovery and automated backups ensure your data is available when you need it while AI power automatic tuning optimizes performance for you SQL manage instance combines all the best of SQL server with the financial and operational benefits of the platform as a service and the third feature is maintain SQL Server application compatibility so accelerate application modernization with the latest SQL Server capabilities in the cloud SQL managed instance provides an entire SQL Server instance within a managed service so so you can continue to use familiar tools and SQL Server features like cross database queries and Link servers SQL managed instance maintains the highest compatibility labels so you can move your on premises workloads without worrying about application compatibility or performance changes and the third member in the family is azure SQL Edge so Azure SQL Edge is an optimized relational database engine geared for iot and iot Edge deployments it provides capabilities to create a high performance data storage and processing layer for iot applications and solutions Azure SQL Edge provides capabilities to stream process and analyze relational and non-relational data such as Json graph and time series data which makes it the right choice for a variety of modern iot applications Azure SQL Edge is built on the latest version of the SQL Server database engine which provides industry-leading performance security and quering processing capabilities since Azure SQL Edge is built on the same engine as SQL server and Azure SQL it provides the same transact SQL programming surface area that makes development of applications or Solutions easier and faster and makes application probability between iot Edge devices data centers and Cloud straightforward so there are two different deployment models in Azure SQL Edge so the first one is connected deployment through Azure iot Edge Azure SQL Edge is available on the Azure Marketplace and can be deployed as a module for Azure iot Edge second is disconnected deployment so Azure SQL Edge container images can be pulled from Docker Hub and deployed either as a standalone Docker container or a kubernetes cluster so some of the features of azour SQL EDR built in data streaming and time series within database machine learning and graph features for low latency analytics then data processing at the edge for online offline and hybrid environments to overcome latency and band withd constraints next is deploy and update from the Azure portal or enterprise portal for consistent security and trunk key management last one is simplified pricing with no upfront cost and subscription offers as low as us $60 per year per device so the fourth and the major family member of azure SPL family is azure SQL database which we're going to briefly understand further first let's understand why one need an Azure SQL database extensively I will tell you the top five benefits that companies are realizing with SQL database so the first one is esal ility and Beyond flexible service plans for SQL database meet the need for both big and small business users SQL is no longer Way Out Of Reach for smaller operations because the pricing structure allows users to pay as little as $4.99 per database per month with a maximum storage set at 150 GB per database that's a lot of space for very small cost second is high speed and minimal downtime so high availability architecture mean High speeed connectivity and data retrival as well as low downtime at your organization there's nothing worse than stopping business because your technology can't keep up and that is no longer a problem with SQL database secondly companies can add application instances as needed through sharing for example shedding is a type of database partitioning that separates very large databases into smaller faster more easily managed Parts called Data shards not only can you spin notes up and down on demand you can leverage a federation infrastructure to scale more easily without affecting other areas of the server SQL azur Federation data migration visard can further automate this process which impacts your organization and the employees much less lastly there are multiple levels of implementation that you can benefit from if you just need a website and a database you can hitch a SQL Azure instance to an Azure website and you are done if you need a full blown virtual machine now or even down the road you can get that as well you can even use a locally deployed instance of SQL server in the virtual machine instead of SQL Azure these implementation options help make your company more adaptable to the inevitable changes it under goes on a regular basis with SQL Azure you are not stuck you are a foundation that encourages growth while working with it third is improved usability so SQL Developers are familiar with all things SQL and SQL database can be updated with SQL CMD or the SQL Server management Studio better yet there is no coding required using a standard SQL it's much easier to manage database systems without having to write or update a huge amount of code fourth time is on your side with no administrative duties on your physical location employees can take time for strategic work to advance grow all around business success when your data datase is hosted in the cloud you don't have to deal with setting up SQL Server appropriating databases and dealing with physical machine maintenance and upkeep all of this results in better alignment of your organization and ultimately more time on your site Fifth and the last one is easy to use migration tools ramp up time with SQL database is now easier than ever and free SQL data synchronization allows you to either synchronize your SQL Server stored data or migrate the data without having to worry about the cost to migrate by syncing gigabyte size tables now that you know why we need azour SQL database let's briefly understand what actually it is the basic fundamental building block that is available in Azure is the SQL database Azure SQL database is fully managed platform as a service database engine that handles most of the database management functions such as upgrading patching backups and monitoring without user involvement Azure SQL database is always running on the latest stable version of the SQL Server database engine and ped OS with 99.99% availability platform as a service capabilities that are built into Azure SQL database enable you to focus on the domain specific database Administration and optimization activities that are critical for your business with Azure SQL database you can create a highly available and high performance data storage layer for the applications and Solutions in azour SQL database can be the right choice for a variety of modern Cloud applications because it enables you to process both relational data and non-relational structures such as graphs Json spatial and XML Azure SQL database is based on the latest stable version of the Microsoft SQL Server database engine you can use Advanced query processing features such as high performance inmemory Technologies and intelligent query processing in fact the newest capabilities of SQL Server are released first to SQL database and then to SQL Server itself you get the newest SQL Server capability with no overhead for patching or upgrading tested across millions of databases SQL database enables you to easily Define and scale performance within two different purchasing models and that we will discuss further so Microsoft handles all patching and updating of the SQL and operating system code you don't have to manage the underlying infrastructure so now let's understand the deployment models Azure SQL database provides the following deployment options for a database so the first one is managed instance this is primarily targeted towards on premises customers in case if we already have a SQL Server instance to on premises Data Center and you want to migrate that into Azure with minimum changes to our application and the maximum compatibility then new will go to the manage instance second is single database so single database represents a fully managed isolated database you might use this option if you have modern Cloud applications and microservices that need single reliable data source a single database is similar to a contained database in the SQL Server database engine last one is elastic pool so elastic pool is a collection of single databases with a shred set of resources such as CPU or memory single databases can be moved into and out of an elastic pool now let's understand the purchasing models so SQL database offers the following purchasing models you can see here so the first one is vord based purchasing model which is new and it offers a totally different approach to sizing your database it is easier to translate local workloads to a vcore based model because the components are what we are used to the vcore based model lets you choose the number of vour the amount of memory and the amount and speed of storage the Vore based purchasing model also allows you to use aure hybrid benefit for SQL Server to gain cost savings and the next one is DTU based purchasing model so the DTU based purchasing model offers a bland of compute memory and input output resources in three service tires to support light to heavy database workloads computer sizes within each CH provide a different mix of these resources to which you can add additional storage resources as you can see from the following diagram the DTU model offers a pre-configured and predefined amount of compute resources voree is all about independent scalability where you can look into a specific area such as the CPU core count and memory resources something that you cannot control at the same granular level when using the DTU based model so the third one is the serverless model which automatically scales compute based on workload demand and builds for the amount of compute used per second the serverless compute Tire also automatically pauses databases during inactive periods when only storage is built and automatically resumes databases when activity returns now let's see the service ties for Azure SQL database so the first one is general purpose or standard model it is based on a separation of Computing and storage service this architecture model depends on the high availability and reliability of azure premium storage that transparently copies database files and guarantees for zero data loss if underlying infrastructure failure happens second is business critical of premium service Tri model it is based on a cluster of database engine processes both the SQL database engine process and underlying MDF or ldf files are placed on the same node with locally attached SSD storage providing low latency to a workload High availability is implemented using technology similar to SQL Server always on availability groups the third one is hyperscale service TI model it is the newest Service Tire in the Vore based purchasing model this tire is a highly scalable storage and compute Performance Tire that leverages the Azure architecture to scale out the storage and compute resources for an Azure SQL database Beyond the limits available for the general purpose and business critical service ties now let's understand the self-contained services in Azure SQL database so Azure SQL database is a database as a platform service designed for applications that will use database as self-contained service databases can be grouped together to simplify management options or share the resources there are different options that can be used to bound databases in the group so the first one is databases in logical server so logical server is the default container for azzo SQL database logical server enables you to perform administrative tasks across multiple databases including specifying Regions login information firewall rules auditing thread detection and failover groups all databases within the server are self-contained with independent service triers that can be specified per each database each database can be independently scaled up or down by changing performance tries on the database which will not affect other databases databases cannot share resources and each database has guaranteed and predictable performance defined by its own service style some server level specific features such as cross database quering linked servers SQL agent service broker or CLR are not supported in Azure SQL database placed in logical servers second one is databases in elastic pool so databases need to share resources can be stored in elastic pools instead of The Logical server all databases within the elastic pool share the same resources associated with the elastic pool label currently there are three service ties in the elastic pools basic standard and premium databases within the elastic pools cannot have different service tires because they share resources that are assigned to the entire pool resources usage in one database might affect others however you can specify Reserve performance for the database in the pool that will guarantee a minimal amount of resources that the database can have this model is a good choice for datab bases that have performance Peaks or heavy usage in different time periods because the amount of resources associated with the pool can be assigned to the databases that need them while the others are inactive elastic pool model is designed for resource sharing and it still does not support server lbel features such as SQL agents service broker Etc these are other mechanisms that can be used as a replacement of these features such as elastic jobs and elastic queries instead of some service label features so now let's look at some of the key features of azure SQL database the first one is extensive monitoring and alerting capabilities so Azure SQL database provides Advanced monitoring and trouble shooting features that help you get deeper insights into workload characteristics these features and tools include the buil-in monitoring capabilities provided by the latest version of the SQL Server database engine they enable you to find realtime performance insights also platform as a service monitoring capabilities provided by AO that enable you to Monitor and troubleshoot a large number of database instances query store a built-in SQL Server monitoring feature records the performance of your queries in real time and enables you to identify the potential performance issues and the top resource consumers automatic tuning and recommendation provides advice regarding the queries with the reest performance and missing or duplicated indexes automatic tning in SQL database enables you to either manually apply the script that can fix the issues or let SQL database apply the fix SQL database can also test and verify that the fix provides some benefit and retain or rever the change depending on the outcome in addition to query store and automatic twinning capabilities you can use extended DMVs and XC event to monitor the workload performance Azure provides buil-in performance monitoring and alerting tools combined with performance ratings that enable you to monitor the status of thousands of databases using these tools you can quickly asset the impact of scaling up or down based on your current or projected performance needs additionally SQL database can emit metrics and resource logs for easier monitoring you can configure SQL database to store resource usage workers and sessions and connectivity into one of these Azure resources so these resources are first one is azure storage so for achieving vast amounts of telemetry for a small price so the second one is azure event hubs for integrating SQL database Telemetry with a custom monitoring solution or hot pipelines and the third one is azure monitor logs for a built-in monitoring solution with reporting alerting and mitigating capabilities so the second feature is availability capabilities so Azure SQL database enables your business to continue operating during disruptions in a traditional SQL Server environment you generally have at least two two machines locally set up these machines have synchronously maintained copies of the data to protect against a failure of a single machine or component this environment provides High availability but it doesn't protect against a natural disaster destroying your data center Disaster Recovery assumes that a catastrophic event is geographically localized enough to have another machine or set of machines with a copy of your data for far away in SQL Server you can use always on availability groups running in asynchronous mode to get the skip ability people often don't want to wait for replication to happen that far away from committing a transaction so there's potential for data loss when you do unplanned failovers so databases in the premium and business critical service tires already do something similar to the synchronization of an availability group databases in lower service tires provide dependency through storage by using a different but equivalent mechanism like buil-in logic helps protect against a single machine failure the active Geo replication feature gives you the ability to protect against disaster where a whole region is destroyed Azure availability zones strives to protect against the outage of a single Data Center building within a single region it helps you protect against the loss of power or network to a building in SQL database you place the different replicas in different availability zones in fact the service level management of azour powered by a Global Network of Microsoft manag data centers helps keep your app running 24/7 the Azure platform fully manages every database and it guarantees no data loss and a high percentage of data availability Azure automatically handles patching backups replication failure detection underlying potential Hardware software or network failures deploying bug fixes failovers database upgrades and other maintenance tasks standard availability is achieved by a separation of compute and storage layers premium availability is achieved by integrating compute and and storage on a single Lo for performance and then implementing technology similar to always on availability groups in addition SQL database provides built-in business continuity and Global scalability features these include automatic backups so SQL database automatically performs full differential and transaction log backups of database to enable you to restore to any point in time for single databases and pool databases you can configure SQL database to store full database backups to Azure storage for long-term backup retention for managed instances you can also perform copy only backups for long-term backup retention second is point in time restor so all SQL database deployment options Support Recovery to any point in time within the automatic backup retention period for any database third one is active Geo replication the single database and full databases option allow you to configure up to four readable secondary databases in either the same or globally distributed Azure data centers for example if you have a service as a platform application with a catalog database that has a high volume of concurrent read only transactions use active GE application to enable global read scale this removes B on the primary data due to read workloads for managed instances use autof fail groups fourth is autof fail groups all SQL database deployment options allow you to use failover groups to enable High availability and load balancing at global scale this includes transparent GE application and failover of large sets of databases elastic pools and managed instances failover groups enable the creation of globally distributed Service as a platform applications with minimal Administration overhead this leaves all the complex monitoring routing and failover orchestrations to SQL database Fifth and the last one is Zone indendent databases SQL database allows you to provision premium or business critical databases or elastic pools across multiple availability zones because these databases and plastic pools have multiple rendent replicas for high availability placing these replicas into multiple availability zones provides higher resilience this includes the ability to recover automatically from the data center scale features without data loss so the next feature is built-in intelligence with SQL database you get built-in intelligence that helps you dramatically reduce the costs of running and managing databases and that maximizes both performance and security of your application running millions of customers work clads Around the Clock SQL database collects and processes a massive amount of telemetry data while also fully respecting customer privacy various algorithms continuously evaluate the Telemetry data so that service can learn and adapt with your application so in its process of work first step is automatic performance monitoring and tuning so SQL database provides detailed insight into the queries that you need to monitor SQL database learns about your database patterns and enables you to adapt your database schema to your work workload SQL database provides Performance Tuning recommendations where you can review tuning actions and apply them however constantly monitoring a database is hard and tedious task especially when you are dealing with many databases intelligent insights does this job for you by automatically monitoring SQL database performance at scale it informs you of performance degradation issues it identifies the root cause of each issue and it provides performance Improvement recommendations when possible managing huge number of data bases might be impossible to do efficiently even with all available tools and reports that SQL database and Azure provide instead of monitoring and tuning your database manually you might consider delegating some of the monitoring and tuning actions to SQL database by using automatic tuning SQL database automatically applies recommendation test and verifies each of its tuning actions to ensure the performance keeps improving this way SQL database automatically adapts to your workload in a controlled and Safe Way automatic tuning means that the performance of a database is carefully monitored and compared before and after every tuning action if the performance doesn't improve the twinning action is diverted many of our partners that run Service as a platform multitenant apps on top of SQL database are relying on automatic Performance Tuning to make sure their applications always have stable and predictable performance for them this feature tremendously reduces the risk of having a performance incident in the middle of the night in addition because part of their customer base also uses SQL Server they are using the same indexing recommendations provided by SQL database to help their SQL Server customers two automatic TW aspects are available in SQL database so first one is automatic index management which identifies indexes that should be added in your database and indexes that should be removed second one is automatic plan correction which identifies problematic plans and fixes SQL plan performance problems so the next step in the process of work is adaptive query processing you can use adaptive query processing including inter execution for multi statement table valued functions batch mode memory Grant feedback and batch mode adictive joints each of these adaptive query processing features apply similar learn and adapt techniques helping further address Performance issues related to historically inable optimization problems so the next feature is Advanced security and compliance SQL database provides a range of built-in security and compliance features to help your application meet various security and compliance requirement note this that Microsoft has a certified Azure SQL database against number of compliance standards for more information see the Microsoft Azure press Center where you can find the most current list of SQL database compliance certifications so built-in security and compliance features so there are certain buil-in security and compliance features so the first one is Advanced threat protection aure Defender for SQL is a unified package for advanced SQL security capabilities it includes functionality for managing your database vulnerabilities and detecting an nous activities that might indicate a threat to your database it provides a single location for enabling and managing these capabilities so there are two kinds of assessment in advanced protection the first one is vulnerability assessment this service can discover track and help you remediate potential database vulnerabilities it provides visibility into your Security State and includes actionable steps to resolve security issues and enhance your database fortifications second is threat protection so this feature detect anomalous activities that indicate unusual and potentially harmful attempts to access or exploit your database it continuously monitors your database for suspicious activities and provides immediate security alerts on potential vulnerabilities SQL injection attacks and anomalous database access patterns threat detection alert provide details of the suspicious activity and recommend action on how to investigate and mitigate the threat so under this the second sub feature is auditing for compliance and security so auditing tracks database events and writes them to an audit log in your Azure storage account auditing can help you maintain Regulatory Compliance understand database activity and gain insight into discrepancies and anomalies that might indicate business concerns or suspected security violations the third one is data encryption SQL database helps secure your data by providing encryption for data addressed it uses transparent data encryption for data in use it uses always encrypted fourth feature is data Discovery and classification data Discovery and classification provides capabilities built into Azure SQL database for discovering classifying labeling and protecting the sensitive data in your databases it provides visibility into your database classification State and tracks the access to sensitive data within the database and Beyond its borders and the last one is azure active directory integration and multiactor authentication so SQL database enables you to centrally manage identities of database user and other Microsoft services with aured active directory integration this capability simplifies permission management and enhances security Azure active directory supports multiactor authentication to increase data and application security while supporting a single signin process the last major feature is easy to use tools SQL database makes building and maintaining applications easier and more productive SQL database allows you to focus on what you do best building great applications so you can manage and develop an SQL database by using tools and skills you already have so the first tool is the Azure portal a web- based application for managing all Azure Services second is azure data Studio a crossplatform database tool that runs on Windows Mac OS and Linux third is SQL Server management Studio a free downloadable client application for managing any SQL infrastructure from SQL Server to SQL database fourth is SQL Server data Tools in Visual Studio a free downloadable client application for developing SQL Server relational databases databases in AO SQL database Integrations service packages analysis service data models and Reporting Services reports and the last tool is Visual Studio code a free downloadable open-source code editor for Windows Mac OS and Linux it support extensions including the mssql extension for quaring Microsoft SQL Server Azure SQL database and Azure SS analytics now let's look at some of the use cases for Azure SQL database so the first one is developer or test environment it's an important use case for replic getting or migrating data to SQL hosted on Azure is for developer or test environments before deploying to the production environment it is pertinent that the data is tested against developer or test environments Azure SQL databases can act as a target for just such environments the life production environment can be replicated to the developer or test environment using a database copy second is business continuity one of the most important use cases for SQL on is using it as a Dr Target to maintain business continuity a your SQL databases can provide an SLA of up to 99.99% by maintaining several copies of the data this provides business continuity as it allows you to restore Geor redundant copies of the data or use active Geor redundant copies as failover points in case of outages at data centers or in regions besides aure SQL databases you can also use availability groups to fulfill business continuity demands not only can you use availability groups in aour SQL virtual machines but also use azour SQL virtual machine instances as a target for high availability and Disaster Recovery third is scaling out readon workloads apart from providing BC or Dr capabilities active GE application can also be used to offload readon workload such as reporting jobs to secondary copies you can also extend on premises SQL Server instances using readable always on replicas fourth is backup and restore Azure SQL databases are backed up automatically on a regular basis and there are no storage costs for up to 200% of the maximum provision database storage you can restore backups to any point in time going back to the retention period which is determined by the Azure SQL service tier in use on premises SQL Server databases and transaction locks can also be bagged up directly to Azure using the backup to URL feature and stored in Azure storage Azure SQL databases can also be stored on local storage by exporting them to backpack files means BS PSC files and the last use case is Advanced analytics another important reason for hosting SQL in Azure is to make use of azure's advanced analytics platforms such as Azure storage blob and Azure data L store Common scenario with Advanced analytics is when users reference data from various data sources use Azure data Lake store as the stacking area perform transformation activities using Hive or spark and finally load the data into Azure data warehouse for business intelligence and Reporting now that you have a theoretical understanding of aure SQL database let's now see a deployment of a SQL database service on Microsoft Azure we will also connect this database with SQL management server as well as with Azure data studio so let's move ahead you can just simply go to the Azure portal if you don't have an account on Azure what you can do is you can create a free account like can start free here and you will get a 12 months free services access as well as if you are from India the currency will be around like 14,500 INR means Indian rupees free currency we will get for free use that's the amount you will get so I already have an account so I will just log in from here no I don't want to I will just go to Microsoft asro here this is the portal so I don't want to buy see these are the credits it is showing you get 14,500 credits I have used some of the credits and this much I left so what you can do is you can go to SQL databases right now because is I have a pin here but what what you can do is you can go to SQL databases from here like here or you can search it from here SQL database yeah now let's create the database from here so free trial is here we have chosen this then we can choose the resource Group and create one group so let's create with a new one so let's give the name as resource SQL demo okay so new resource has been created then enter database name can give some name to like demo SQ l so yeah that's okay so we have the server name also so create a new server server name so let's give it like remember these names SQL demo server I have given so the specified server name is already in user we can give like SQL demo server 662 but you have to remember this don't forget this like login information okay so you can give some server admin login so Azure admin will be okay I think yeah now let's move ahead to give a password don't forget these information we will require these information later on in this process and choose your region also so my region is Central India so it will be Asia Pacific Central India just AE yeah so okay the next process if you want to use SQL elastic pool right now we don't require so we will choose no if you want to then you can choose yes then we can configure the database and storage also so these are the plans like I have explained you basic standard premium the service tires are there similarly purchasing models are there vco purchasing models are there general purpose hypers scale business critical the also have explained you so like whichever you choose on the basis of that it shows the price so right now it's costing 29,9 but we don't require that much big so you can just you can choose it from here also like not available because it's the free tire account that's why we don't have the premium version so can use the standard one so in this standard one if you decrease the storage then it will also decrease the price not in this manner like from you can go to basic here you get 2 GB and the price decreased you can choose for 1 GB also but price will remain the same so you can go to 2 gb so we will choose the basic one because we don't require that much of configuration so just apply from here just review and create a simple review plan so yeah create so it's getting created the process it takes a little time so that's why taking a Time few minutes it take so you can see the deployment is complete so you can go to resource SQL demo so we have game to Resource here you see that server is created but you have to refresh once again just a second where is the database let's refresh again I don't know it's get created usually yeah so you can see have to refresh it so it will takes a little time so database is also created now so what we can do from here is first step is you have to create the firewall so you can go to database so you have to set the firewall set firewall servers you can go from here set the fireable so you have to choose the like all these client IP is given from start IP and end IP so you can just you have to add the client IP so it has been added so you have to give it from 0 to 255 complete you have to give 255 so save and just go back then you can see different cool features are given on the left side of this dashboard so you go to like query editor this is here you can like connect your database to the browser and you can configure and then there is Compu and storage if you have like you can yeah not a problem so computer and storage is given if you want to like change your plan purchasing model and everything then you can change it from here again like all the things are given here you can again change it it's not a problem then there are like connection string no problem then you can go to connection strings where you can connect your and make connection to the strings like there's ado.net or if you are working on Java then jdbc is there obbc is there PHP go everything is there it's quite cool feature then there are synchronous to other database where you can synchronize to other databases also then also you can like add aure search also then there are different security features are there advanc security features are there for data also Advanced Data security features are given here now what we can do major thing we have to do is we have to connect it to the management SQL Server so if you don't have a management SQL Server you can download it from here you can just give management SQL Server just go here and download it from here it's given you can just click here and it will get downloaded it will ask for a restart it will restart your computer and all the settings will be saved in your computer then you can start using SQL Server I already have downloaded it so I already have downloaded it so we can just go here I have it PR here so Microsoft SQL Server management so yeah you have to give your server name so let's see the server name first here it is know from database only so server name is given so you can just copy it from here paste it here you can just select the SQL Server authentication here and give you a login also so remember the login I told you to remember the login password so my is your admin password can just connect it from here so yeah we got it here so we can just ose the databases can see the demo SQL we can find the our database here under the different tables and everything is there so we can just start the new query from here can create the table so let's create the table create table with the name Person persons so yeah it will be enough let's now execute it you can see command completed successfully we can now insert values into it so like before that we can view in tables Also the table right we created the name of persons spending so yeah you can see persons is created so let's now insert values you can give like my name so6 from person let's execute now oh sorry it's a little mistake let's execute now so yeah you can see we have got the table contents everything is there now we can also see for Azure data studio also so we will just go to Azure data Studio it's like you have a visual studio code also similarly there's a studio can start the new connection then we have to give the server name here just like we have the server name there so what was the server name let's copy it from here so yeah just give here and then we will chose the SQL login username Azure admin the password yeah we can just remember the password not a problem then database we have to select so what was the name of the database demo SQL that's why it's showing here yeah so we connected from here yeah we are here like different features are given like new query new notebook just like you have in Visual Studio code in that way V is given and all the other like it has a very good UI also here we go to the database person it is showing just maximize it okay yeah so it's open now just like you can give it here Al all the details it is showing like it's been executed and details are shown here this is how it looks like also one cool thing about a data studio is you can go here and you can see like it actually remembers all the databases like this one it remembers this one I have closed actually this database I have closed I have created it some time back but it still remembers it databases if you give the aure like server ID now so like it will remember all the databases like from where initially we have selected now from there on so this is how it looks like let's go back to Azure one now we have understood how to do it in Azure data studio also and how to connect it with the management SQL Server also so there are certain other features also you can see here for performance overview like how it's working and to track the performance and everything also the auditing and things are given here so just like these are the things but I have mainly told you about the purchasing models and deployment models and how service tires are there and how we can create the database connected with management SQL Server as well as a studio I think it might be a little hectic but I have explained you in a little simpler manner so please try it with your hands on experience like take your handson experience also by trying it on deploying aure SQL database on this Azure portal with this we come to the end of today's session of azure SQL database I hope you had a great time learning and understanding about about it and if you have any queries please feel free to leave them down in the comment section below until next time thank you