In this DP-900 lecture, we explore how to provision relational databases in Microsoft Azure. Whether you're preparing for the DP-900 certification or learning how to set up Azure SQL Database, PostgreSQL, MySQL, and MariaDB, this session provides a step-by-step guide to deploying and managing relational databases in the cloud.
🔍 What You’ll Learn in This Session:
✅ Overview of Relational Database Provisioning in Azure
✅ Setting Up Azure SQL Database, Managed Instances & SQL Server on VMs
✅ Provisioning Azure Database for MySQL, PostgreSQL & MariaDB
✅ Understanding Deployment Models – Single vs. Hyperscale vs. Flexible Server
✅ Configuring Security, Backup & Performance Optimization
✅ Cost & Scalability Considerations for Azure Relational Databases
🛠️ Who Should Watch This?
Beginners & IT professionals learning Azure database provisioning
Students & aspiring data engineers preparing for DP-900 certification
Developers & database administrators deploying SQL databases in Azure
Cloud architects & business analysts exploring Azure relational database solutions
📌 Key Highlights:
✅ Step-by-step database deployment in Azure
✅ Live demos of provisioning Azure SQL, MySQL & PostgreSQL
✅ Best practices for security, backup & cost management
✅ DP-900 exam-focused insights
💡 Learn how to provision relational databases in Azure & enhance your cloud data skills!
Explore Our Other Courses and Additional Resources on: https://skilltech.club/
🔍 What You’ll Learn in This Session:
✅ Overview of Relational Database Provisioning in Azure
✅ Setting Up Azure SQL Database, Managed Instances & SQL Server on VMs
✅ Provisioning Azure Database for MySQL, PostgreSQL & MariaDB
✅ Understanding Deployment Models – Single vs. Hyperscale vs. Flexible Server
✅ Configuring Security, Backup & Performance Optimization
✅ Cost & Scalability Considerations for Azure Relational Databases
🛠️ Who Should Watch This?
Beginners & IT professionals learning Azure database provisioning
Students & aspiring data engineers preparing for DP-900 certification
Developers & database administrators deploying SQL databases in Azure
Cloud architects & business analysts exploring Azure relational database solutions
📌 Key Highlights:
✅ Step-by-step database deployment in Azure
✅ Live demos of provisioning Azure SQL, MySQL & PostgreSQL
✅ Best practices for security, backup & cost management
✅ DP-900 exam-focused insights
💡 Learn how to provision relational databases in Azure & enhance your cloud data skills!
Explore Our Other Courses and Additional Resources on: https://skilltech.club/
Category
🤖
TechTranscript
00:00In this video lesson, we are going to explore provisioning and deploying relational database
00:13services in Azure. Obviously, we are going to focus on Azure SQL database in this case
00:19and we will see that how we can provision and deploy it. We will focus on provisioning
00:24relational data services, then we will focus on configuring relational data services, in
00:29which we will see that what kind of IP configuration, user and security configurations are required
00:35in that. While connecting to this data service which is hosted on Azure and while connecting
00:42to this Azure hosted data service from your on-premise computer or from any other outside
00:48computer, what kind of connectivity issues can be there, what kind of client IP configuration
00:53or firewall configuration are required in case of data security, we will focus on all
00:59this thing in this video. Configuring relational data on Azure is a step-by-step process and
01:06when you are going to use a tool like Azure portal and then if you are going to deploy or provision
01:12your Azure SQL server or any other data service, you have to follow certain steps. Initially,
01:19every provisioning is going to start with the basic tab, in which you are going to focus
01:23on your subscription and resource group, in which subscription and resource group you want
01:27to create it. Then you can choose whether you want to go with the managed instance and then you
01:32have to provide your SQL server name, database name, you have to provide your SQL server admin
01:38credentials with the login name and password and you also have to decide which kind of region
01:44you are going to select because there are more than 65 plus regions available in Azure cloud, in which
01:50geographical region you want to create your data service that you have to select in that. You can also
01:57choose what kind of compute you want to associate with your database, you can opt in for the elastic
02:02pull or maybe you can just create a single database with the dedicated compute and storage associated
02:07with that. Once you are done with the basic, you can have a configuration of networking connectivity,
02:14where you can go with the public or private network access. You can choose your firewall rules for the
02:21you know, the incoming request coming from any outside computer to the Azure cloud based database. And you can also
02:29choose your own private virtual network configuration in that with your own range of IP addresses, which will be
02:34also private IPs. Then you can go for an additional database configurations where you can choose whether what kind of
02:41collation you are looking for or what kind of data source you want to associate with that. There are chances you
02:46have existing database backup and then you want to directly load the database backup into this newly provisioned
02:53database. We can surely go with that. You can also focus on your database and server collation. You can also focus on
03:02your time zone which is associated with that. And optionally you can just opt in into advanced data security which can be
03:10automatically taken care by Azure. After this three basically configuration, you can go for the tags. Now we will not focus
03:22on the tags much right now, but tags are useful for the naming convention. So when you want to find out any resources
03:28on Azure with the proper tags like client name or some kind of a regional name kind of thing, then this tags will be
03:35helping you to organize that. It is also going to help you at the end of the month when you want a consolidated
03:42billing with that. So that is something which is tags but will not use it much in this course. And last but most important
03:49one which is review plus create and this is going to be that page which is going to be the final stage of your
03:55provisioning where before submitting the deployment to the server, you can check whether the configuration which you have done
04:01in the previous steps are correct or not. You will also get some estimated cost on most of the services so that
04:07before deploying that you can get to know what exactly you will be charged at the end of the month if you
04:13continuously run it for 30 days. After that basic configuration, you also need to focus on connectivity from within
04:20Azure. Now when you have application and other databases deployed on Azure, how those applications can connect to your database?
04:30Maybe they can directly connect and they can do send and receive request kind of operations with that or
04:37maybe they can connect via some kind of a traffic manager or application gateway. All the optionals and possibilities are
04:44available in Azure. So there are chances that you can do policy of redirect where an application is going to establish
04:50a connection to the Azure SQL database through the gateway. All requests after the first will go directly to the database.
04:57So it's like first time it's going to go to the gateway. It will maybe do some additional configuration with that and then
05:04second time onwards all the subsequent requests will directly go to the database. If connectivity to the database fails,
05:10the application will have to reconnect through the gateway. So suppose if it is not connected or some failures are
05:16happening consecutively, then you can go through the gateway once again for the authentication and then after that you can again,
05:22subsequent request will be redirect directly. The application may be directed to a different copy of the database running on the server in the cluster.
05:31So there are chances that you have enabled local or geographical applications on your database. And if one of the database is not available, it can go to the copy of the database which is running on this another server in the cluster.
05:45So it's like going to be, you're going to have multiple servers inside one cluster environment where your database copies are going to be replicated.
05:55How this is going to work? We will see this thing when we actually deploy a SQL database today exactly after this in the demo of this particular video.
06:05Obviously with this we also have to take care of connectivity from outside to Azure.
06:10There are chances that you have applications running on your on-premise server or maybe you have SQL Server Management Studio or some other development machines which are going to connect with your databases.
06:23When this kind of scenario is there, let's say you have an application which is establishing a connection to an Azure SQL database via gateway first time.
06:31All the requests will go through the gateway in this case. Whether you are making a first request or whether you are making some other request after that, everything will go via gateway.
06:42Why this? Well, because of the security of the Azure. Every time when the request is coming outside the Azure, you have to go through the gateway so that it can make sure that only the valid requests are going to be allowed for the database connection.
06:57The application may be redirected to a different copy of the database running on another server.
07:02Now, this is again done here because of the high availability scenario because we want to make sure that multiple copies of the database are going to be available.
07:11Also, there are chances sometimes we do this thing for resiliency because there are people who are trying to access my database and application from different geographical locations.
07:22If I have geographical replications, then accordingly the data will be provided from different locations altogether in that.
07:29Next, we have to focus on authentication and access control. As I said, we have a gateway via which we can just focus on inside Azure or outside Azure kind of connections.
07:40But then we also have something called mixed mode authentication, which is allowing you to do SQL server authentication plus some network level integration with the database,
07:50some server level principle and configurations can be done with that.
07:53You can also configure a Windows authentication kind of thing, but for that you need to associate with your Azure Active Directory authentication.
08:02So, you can have an Azure Active Directory administrations, you can have your SQL server or Azure users who can directly log in and connect to your SQL server databases.
08:14And you can also control something which is known as role-based access control where you can actually control that which user is going to have a role assigned which can manage the database,
08:27which can just read the database properties and execute some queries on that.
08:32You can also have a configuration of Azure SQL database admin where you can just use a SQL admin, you can use your login manager, database manager,
08:42you can provide your username and password and just log in into the SQL server within the Azure SQL database itself.
08:48And you can manage multiple users and security like you do with the traditional SQL server.
08:54You can do all this authentication and access control inside the Azure.
08:59When you have integrated with Azure Active Directory, when you have multiple roles and the users who are going to use and associate with your database,
09:08then you can use this utility called RBAC, formerly known as role-based access control.
09:14It helps you to manage who has access to your Azure resources.
09:18Remember, this is not only for SQL database.
09:21Role-based access control is actually available for almost all the resources available in Azure.
09:27And you can also control what they can do with those resources based on the different roles customization which you can do.
09:34If you have to create a customized role, that provisioning is also available in Azure.
09:39You can control the access to resources using role assignment.
09:43And role assignment contains three elements actually.
09:46You can have your user with the proper role and the scope associated with that.
09:51Or you can have a service principle, which is something like a security principle, which is nothing but an object that represents a user or a service that is requesting to access the resource.
10:03Because sometimes there are chances that you have a user who's going to connect to your database and then he can maybe execute some queries or create some table structure with the queries.
10:14Or maybe it's not a user, you just have an application which is willing to access the data from that database.
10:21And that's where the security principles are going to come.
10:24Because it can be either user or service to whom we need to identify and then we need to provide an access of the database.
10:32Last but not the least, you also need to understand the replicas which can be configured with the Azure data services.
10:39You can have multiple read replicas which can help you to improve performance of your database.
10:46It can also help you to scale and when you have a read intensive workload like you want to do millions of data read access actually.
10:55And you want to display it somewhere in the Power BI or some other analytical platforms.
11:01Then this kind of multiple replicas are going to be useful.
11:05It can be locally replicated, it can be also geographically replicated like you can see in this diagram.
11:11We have one primary copy of the database and then if we want we can create multiple secondary copies of the databases which will be just read only.
11:20So you can use these copies for read only kind of data where you can display the different analytics on different kind of query operations for read operations can be happen into this secondary databases.
11:37You can also create a replica in a different Azure region from the primary which is going to give you an additional advantage of disaster recovery.
11:45where one replica is going to replace the other one.
11:50So if suppose your primary replica is actually down then automatically one of the read replica which is in the nearest region will become the primary and then you can get rid of your disaster actually.
12:04So it's kind of a disaster recovery plan or feel over management plan kind of thing which can be also associated with this read replica.
12:12This will be that additional advantage which you are getting because you are using not a normal traditional database but you are using a cloud based Azure database.
12:22And that's why all these additional advantages you are getting in this.
12:27Now obviously after all this discussion we have to see that what kind of provisioning we can do inside Azure and now it's the time to let's have a quick demo where we are going to provision our Azure SQL Server database as a platform as a service.
12:43And we'll focus on all these points which we have discussed in this particular lesson.
12:48Ok so I have logged into this website which is portal.azure.com which is actually Azure portal.
12:55This is nothing but that particular website which allows you to create all the resources on Azure cloud.
13:01Obviously if you have a valid subscription then only you'll be able to access this website and then only you'll be able to create any resources inside this.
13:10I am on the homepage of this website and I clicked on this button called create a resource which shows me that I can create different kind of resources.
13:19I can create a virtual machine with windows or linux kind of operating systems.
13:24I can create an application or database or any other services which are available on Azure.
13:30In this left side categories I'm going to click on databases and then whatever database options which we have discussed so far
13:39we are able to see that thing like we have Azure SQL manage instance, we have Azure SQL database, we have Azure database for PostgreSQL or even for MySQL.
13:50Any of this I can provision right now on the cloud if I have a valid subscription and obviously in that subscription if I have enough Azure credits available.
14:00I hope before proceeding further you guys have already activated your free subscription with Azure $200 credit available in that.
14:08And then those credits will be useful when you deploy any services in Azure like Azure databases.
14:15I am going to select Azure SQL database right now and then it will take me to a page where I have to provide a configuration for basic, networking tab, security tab, tags and additional settings.
14:29So this is the same which we have discussed in this particular lesson.
14:32Now inside the basic they're asking me which subscription you want to use for that.
14:36I'm using my visual studio enterprise subscription which I got with my visual studio.
14:41Which resource group I want to create.
14:43Now resource group is just like a logical grouping.
14:46It's like a logical folder name inside which you can keep your database and SQL server.
14:51I am providing a name of this particular resource group like this is going to be my DP900RG.
15:00This is a resource group which I'm going to use for this particular course.
15:04And then what will be my database name.
15:06Let's say I'm giving a name of the database is going to be my name DB.
15:11I'm giving something like Maruti DB.
15:13It can be anything.
15:14And then I have to provide a SQL server.
15:17As you can see in this drop down I already have some existing SQL server which I have deployed earlier in the East US region of Azure.
15:25But let's say I want to create a new SQL server now.
15:28So I'm going to click on create new.
15:30Which takes me to another page where I have to provide my server name and the credentials for the SQL authentication.
15:37I am going to provide a server name like this is my DP900SVR and I just want to make sure that this server name should be available.
15:49Yes it is available there.
15:51While creating this for your demo purpose I request you to change this name to something else if this particular name is not available.
15:59Because this has to be associated with a unique name.
16:02Even in my case when I have to create a server just make sure that this is going to be unique.
16:07I am going to put my name before that.
16:09This is going to be Maruti DP900SVR.
16:12The location for this I can choose from whatever available regions are there.
16:17I'm going to keep it in each US just for no reason right now.
16:21Maybe my customer base is located in this region.
16:24So I'm choosing each US region here.
16:26What kind of authentication I want.
16:28Now as we discussed we can use SQL authentication and we can just go on with SQL server admin password and all.
16:37And then if I do not want that I can go for only Azure Active Directory based authentication.
16:43Where I have to associate my Azure Active Directory admin here.
16:47Or maybe I can go with both.
16:49I can select Azure Active Directory admin and I want SQL server admin also.
16:53So later on I can use any one of the option to login into my SQL server and validate the user based on that.
17:01As of now I'm going with the first option which is use a SQL authentication only.
17:06So let me just take that.
17:08In the server details I'm going to provide some username and password.
17:12Which I can use later on when I want to connect to this SQL server.
17:16And then I can execute my queries after that.
17:19Providing some username and password.
17:21Going to click on OK.
17:22Which will take me to the previous page.
17:25In the basic tab.
17:26Where you can see right now.
17:28I'm still in the basic tab.
17:29My new server configuration is just configured here.
17:32But it's still not deployed.
17:34Because I have to complete the configuration process.
17:37And then I have to deploy it.
17:39What kind of a compute and storage size I want.
17:42That I can choose here.
17:44Or maybe I can go with the elastic pull.
17:46If I set yes.
17:47I can have one elastic pull inside which multiple databases can be there.
17:51Which will have a shared resources.
17:53As we have discussed.
17:54I'm going to click on this configure database link.
17:58And I do not want to go with the general purpose database.
18:01Because cost wise is going to be a little bit more expensive to me.
18:05I am going to select a very simple basic database.
18:09Which is going to give me a 2 GB database.
18:12With the limited data transactional unit.
18:15Which is like 5 DTU.
18:16Means like per second we can do 5 transactions on this database right now.
18:21And we are okay with this.
18:23Because this is something which is a very cheaper database.
18:26I'm going to click on apply.
18:28And then they are asking me that.
18:30What kind of backup storage redundancy you want.
18:33Remember this is not a data replication.
18:36This is something which is just a backup replication.
18:39They are asking me.
18:40So where exactly I want to keep my database backup.
18:43Well I want to keep it in the local redundant backup storage.
18:46So within the same data center region.
18:49Of this particular East US.
18:51They are going to create multiple backup copies.
18:54So that if something goes wrong with one of the copy.
18:57Like maybe disk failure is happening or something like that.
19:01I can get the data from the backup.
19:03I'm going to click on next.
19:06And the second tab is asking me.
19:07What kind of networking I want.
19:09I can choose my kind of network connectivity.
19:12Which can be public or private.
19:14If I select private.
19:16I'm going to have my own private endpoints configured here.
19:19I can also configure my connection policies.
19:22I can also configure my redirect policies.
19:25And then I can decide.
19:26How applications within Azure.
19:29Or outside Azure.
19:30Can connect with this.
19:31Or alternatively.
19:32I can go with the public endpoint.
19:35With the firewall rules configuration.
19:37And I can decide that.
19:39Who can access this server.
19:41And from where.
19:42Like the moment I select public endpoint.
19:44We have two options.
19:45Which we need to select here.
19:47They are asking me that.
19:48Do you want that other Azure services.
19:51Which are deployed on Azure obviously.
19:53Can access this server.
19:55I'm saying yes.
19:56And then they're asking me that.
19:57Do you want to add the current client's IP address.
20:00Now.
20:01I'm using right now from my computer.
20:03And I'm accessing this portal from that computer.
20:06So the IP address of that computer.
20:08Will be added into this particular firewall.
20:11Of this SQL database.
20:12Yes.
20:13This firewall is also going to be automatically deployed.
20:16And configured with this database.
20:18And it will have the IP address of my computer.
20:21So that I can assure.
20:22That my computer is a valid computer.
20:24To access this database server.
20:26I'm going to say yes for this also.
20:28And then I think.
20:29I do not want to change any.
20:31Encrypted connections or connection policies for this.
20:34We are going with the default policy right now.
20:36And then we'll click on next.
20:38If I want some additional security.
20:41Which can be.
20:42Maybe I want to associate some.
20:44Cryptographic integrity with this.
20:47Using the ledger.
20:48Or maybe I want to associate some additional.
20:50You know.
20:51User defined identity.
20:53Which will be managed with the Azure.
20:55Then I can do that thing.
20:57Or I can also additionally specify.
20:59Transparent data encryption.
21:02With my own service manage key.
21:04So I can configure all this additional configuration.
21:07For security.
21:08But as of now.
21:09I'm not doing it.
21:10In the additional setting.
21:12They're asking me.
21:13Whether I want an empty database.
21:15Or I want some database.
21:17Which will be.
21:18Having some kind of existing.
21:19Backup associated with that.
21:21Or I want to use a sample database.
21:23Provided by.
21:24Adventure works.
21:25I can choose any of these options.
21:27I'm keeping it none right now.
21:29With the default collection.
21:30Given here.
21:31In the database collection.
21:32So I'm going to keep it none.
21:33So it is going to be an empty database.
21:36Later on.
21:37If I want to.
21:38Create some tables.
21:39I want to execute some queries.
21:41We're going to see how we can do this thing in this.
21:43In the next lesson actually.
21:44So I'm keeping it none.
21:46I do not want to do any changes in tags.
21:49And quickly we'll just go to the last tab.
21:51Which is review plus create.
21:53This review plus create.
21:54Is going to show you all.
21:55What you have configured there.
21:57With on the top.
21:58Is showing you.
21:59The estimated cost for this database.
22:01And SQL server.
22:02Is going to be.
22:03Almost 360 Indian rupees.
22:05Now.
22:06Maybe you will get the cost.
22:07In your own currency.
22:08Based on your country's location.
22:10And.
22:11According to that.
22:12You can get to know.
22:13That.
22:14How much you have to pay.
22:15At the end of the month.
22:16If you run the service.
22:17For continuously 30 days.
22:19Now.
22:20Obviously.
22:21If I delete this database.
22:22And SQL server.
22:23Before 30 days.
22:24Maybe after a few hours.
22:25Also.
22:26I can delete it.
22:27And then.
22:28It won't charge me.
22:29For one month.
22:30So.
22:31Remember.
22:32All the Azure services.
22:33Are going to charge you.
22:34On pay as you go basis.
22:35So.
22:36It's like.
22:37Whatever resources.
22:38You are using.
22:39And.
22:40Running it.
22:41For a couple of hours.
22:42You have to pay.
22:43Only for that amount.
22:44So.
22:45It's not going to charge me.
22:46For one month.
22:47It's just an estimation.
22:48Of the cost.
22:49Which they are showing me here.
22:50If you are okay with this.
22:51You can just click on.
22:52Create.
22:53Which will start.
22:54Provisioning this thing.
22:55One final time.
22:56And then.
22:57This will initialize.
22:58The deployment.
22:59First.
23:00And then.
23:01Is going to submit.
23:02The deployment.
23:03To Azure cloud.
23:04This is a point.
23:05Where Azure.
23:06Is going to take.
23:07All your configuration.
23:08And then.
23:09Is going to start.
23:10Deployment.
23:11Of this particular.
23:12SQL server.
23:13With one database.
23:14With all the security.
23:15And.
23:16Compute configuration.
23:17Which you have defined.
23:18This process.
23:19Will take around.
23:20Two to five minutes.
23:21And then.
23:22At the end.
23:23Of the process.
23:24You will get a message here.
23:25That deployment.
23:26Is completed.
23:27And then.
23:28If that is completed.
23:29Then.
23:30You can just.
23:31Use the database.
23:32You can just.
23:33Configure it.
23:34You can.
23:35Execute.
23:36Some queries.
23:37Inside that.
23:38Or you can.
23:39Configure.
23:40The firewall.
23:41All the resources.
23:42Which you deploy.
23:43In Azure.
23:44Will have the same.
23:45Kind of.
23:46Process.
23:47Need to follow.
23:48So.
23:49It is going to.
23:50You can use.
23:51That resource.
23:52It will be.
23:53Up and running.
23:54In this.
23:55Minimum time.
23:56So.
23:57In this lesson.
23:58We have.
23:59Seen.
24:00How we can.
24:01Provision.
24:02And deploy.
24:03A relational database.
24:04Service.
24:05In Azure.
24:06We have.
24:07Focused on.
24:08The different.
24:09Aspects.
24:10Of provisioning.
24:11As well.
24:12As well.
24:13As well.
24:14As well.
24:15As well.
24:16As well.
24:17As well.
24:18As well.
24:19As well.
24:20As it is ready.
24:21To use right now.
24:22If i click on go to resource.
24:23It will take me to that particular database.
24:25Which is.
24:26Located in.
24:27East us region.
24:28The.
24:29Status of the database.
24:30Is online.
24:31And then.
24:32Somewhere.
24:33I have a proper server name.
24:34And the configuration.
24:35Selected for the database.
24:36I can.
24:38I can.
24:39Click on.
24:40Set Nemo.
24:41Firewall kinda.
24:42Of option.
24:43And i can see that.
24:44That the security configuration.
24:45Of the firewall.
24:46Is done or not.
24:47see my allow Azure services properties are true. I can also see that my current client
24:53IP address is also added and configured inside this database. If I want to add on some more
24:59computers and if I want to configure some more networks and the private IP range into
25:06this, I can add those range here and those computers can also access my database afterwards.
25:12Obviously it's using a double layer authentication so that IP address has to be added and then
25:17if I want to cross check if I'm able to connect to the database or not, then all I have to
25:22do is I have to either connect the server name with my existing servers like SQL Server Management
25:29Studio or Visual Studio or any other utility which allows me to connect with SQL Server
25:35and then I can use it.