In this DP-900 lecture, we dive into Azure’s relational data services, a key area for managing structured data in the cloud. If you're preparing for the DP-900 certification or looking to understand Azure SQL Database, Managed Instances, and PostgreSQL/MySQL in Azure, this session provides a step-by-step overview of relational database services in Microsoft Azure.
🔍 What You’ll Learn in This Session:
✅ Introduction to Azure Relational Data Services
✅ Overview of Azure SQL Database, Azure SQL Managed Instance & SQL Server on VMs
✅ Azure Database for MySQL, PostgreSQL & MariaDB – Features & Use Cases
✅ Understanding High Availability, Backup & Security Features
✅ Scaling & Performance Optimization for Relational Databases in Azure
✅ Choosing the Right Relational Database Service for Your Needs
🛠️ Who Should Watch This?
Beginners & IT professionals learning Azure relational databases
Students & aspiring data engineers preparing for DP-900 certification
Developers & database administrators working with SQL in Azure
Business analysts & cloud architects exploring relational database solutions
📌 Key Highlights:
✅ Simple & clear explanations of relational database services
✅ Real-world examples & use cases
✅ Live demos of Azure SQL Database & other services
✅ DP-900 exam-focused insights
💡 Master Azure relational database services & enhance your cloud data skills!
Explore Our Other Courses and Additional Resources on: https://skilltech.club/
🔍 What You’ll Learn in This Session:
✅ Introduction to Azure Relational Data Services
✅ Overview of Azure SQL Database, Azure SQL Managed Instance & SQL Server on VMs
✅ Azure Database for MySQL, PostgreSQL & MariaDB – Features & Use Cases
✅ Understanding High Availability, Backup & Security Features
✅ Scaling & Performance Optimization for Relational Databases in Azure
✅ Choosing the Right Relational Database Service for Your Needs
🛠️ Who Should Watch This?
Beginners & IT professionals learning Azure relational databases
Students & aspiring data engineers preparing for DP-900 certification
Developers & database administrators working with SQL in Azure
Business analysts & cloud architects exploring relational database solutions
📌 Key Highlights:
✅ Simple & clear explanations of relational database services
✅ Real-world examples & use cases
✅ Live demos of Azure SQL Database & other services
✅ DP-900 exam-focused insights
💡 Master Azure relational database services & enhance your cloud data skills!
Explore Our Other Courses and Additional Resources on: https://skilltech.club/
Category
🤖
TechTranscript
00:00Okay, so now it's the time to start our module number 2 in which we are going to explore
00:13relational data in Microsoft Azure cloud. We are going to see this thing with demos
00:19in depth but yes, this is something which is a more important module because you are
00:24going to focus only on relational data and then we will see what kind of flavors are
00:29available in Azure. This module number 2 is actually going to focus on three lessons.
00:35In the first lesson, we are going to explore relational data services in Azure. So what
00:39kind of services are there? We need to know that thing in that. In lesson 2, we are going
00:44to explore how we can provision and deploy relational database management service on Azure. We will
00:50focus on MySQL, SQL Server kind of databases in this and we'll see that how we can provision
00:56this thing actually on the cloud. And this is going to be that lesson in which you need
01:00Azure subscription so that you can do this thing practically. And finally, once our database
01:05is provisioned, lesson 3 is going to focus on how we can write queries and we can retrieve
01:11data, we can store data in the relational format inside the Azure cloud in SQL Server database.
01:18In this video, we are going to explore relational data services available in Azure cloud. If I
01:23focus on in detail, then we need to focus on what kind of data services are provided by Azure
01:29cloud. And obviously, as we know, Azure cloud is actually going to have flavors of services
01:35in case of infrastructure as a service, platform as a service. And when you are asking for any
01:42particular relational database management system like SQL Server, then they are going to give
01:47you multiple flavors in that. We will focus on this that what kind of differences we will
01:53get if we go for infrastructure as a service or platform as a service kind of model. Obviously,
01:59that gives you different kind of control and that will give you different kind of costing
02:04associated with that. If I'm going with infrastructure as a service, then I need to have an Azure virtual
02:10machine which will be fully customized by ourselves. And then on top of that virtual machine, we will
02:16have SQL Server installed which can be also fully controlled by us. Then if I am not choosing
02:23infrastructure as a service and if I decide to go with platform as a service kind of model,
02:28then we can go with Azure SQL database which is directly available and hosted on Azure without
02:34any virtual machine infrastructure. And we are not going to manage any virtual machine in
02:39that case. And suppose if we are not looking for SQL Server database but we are looking for
02:44the other flavors like PostgreSQL, MySQL or MariaDB kind of databases, then those are also some
02:51other data services provided by Azure which are relational. Azure offers a range of options
02:58for running a database management systems in the cloud. And you can see on screen, these
03:03are the four most popular versions which are available. The first one is actually your Azure SQL Server
03:10database which is a single SQL Server allowing you to deal with the SQL database and the tables
03:16inside that. All these four services which are coming under the umbrella of Azure data services
03:23are falls into the platform as a service kind of category. So all four are actually platform
03:28as a services where you really don't need to manage a server side infrastructure, virtual machines,
03:34or any other storage associated with that. These four options are having their own varieties.
03:40These services are a series of database management services which are managed by Microsoft in the
03:46cloud. Each data service takes care of the configuration, day-to-day management, software updates
03:52and patching, and security of the databases that it hosts. All you have to do is you create your own database
03:59under the control of the data services of Azure and then you can manage the security, the data
04:06querying, and the data integrations with that. Azure data services are available for several
04:12common relational database management systems and as I said, these four are the most popular
04:17ones of that. The second one is MySQL database available on Azure. The third one is a MariaDB version.
04:25We'll see that thing that what is the difference between all four but third one is a MariaDB
04:30available on Azure and the last one is a PostgreSQL available on Azure as Azure data service.
04:38Now before we move forward, let's focus on the differences between physical infrastructure
04:43server which we can call it like an on-premise server. Like I'm sure if you're working for an
04:48organization, then your organization is surely having an on-premise server. That full physical
04:54server is managed by your organization, not by anyone else. And then on top of that server,
05:00you can install your SQL server, you can have multiple databases, and I think almost everything
05:05is managed by the people and the employees of organization. While when you go for the public
05:11cloud like Azure, compared to that physical server, you have to rely on infrastructure as
05:17a service or platform as a service kind of models. In infrastructure as a service, your
05:23SQL servers are going to be hosted and deployed or I can say a better word provision on virtual
05:30machines. So technically, your Azure cloud is providing you a virtual machine which is
05:36nothing but something similar to your on-premise server. You can take care of the virtual networking,
05:41virtual hard drive storage, you can take care of the IP address and even the network traffic
05:46in that. And then inside that virtual machine server, your SQL server is installed so that
05:52you can take care of the databases, user security, everything inside the SQL server. Obviously,
05:58infrastructure as a service is actually giving me more control and that's why when I choose
06:03infrastructure as a service, administrative efforts are going to increase as well as even the
06:09the capital expenditure on a day-to-day control is going to also increase with that. So somehow
06:14the cost-wise infrastructure as a service is a cost-day service then platform as a service as well as
06:21it gives me more administrative efforts which I need to do. Things are not going to be automatically
06:26configured, I have to take care of this thing. Obviously, compared to physical and on-premise
06:32server, infrastructure as a service on cloud is a better option but then we even have a better option
06:37which is platform as a service. Platform as a service is not giving you any virtual machine
06:43or virtual network kind of things in that. It is just giving you a pre-configured, pre-provision
06:50Azure SQL database which is actually a virtualized database version available on Microsoft Azure
06:56cloud. You won't be able to see any virtual machine but yes, if you want to take care of SQL server
07:02with some kind of SQL server firewall security or IP address configurations for client access then all
07:09those configurations are provided in this platform as a service. And that's why this is going to have
07:16a less administrative effort or I can say least administrative efforts and least day-to-day control is also
07:23going to be there. So cost-wise this is going to be cheaper than the other two options. Which one is better and best for you? Well, that is something which is going to be cheaper than the other two options.
07:29What is better and best for you? Well, that is something which we can get to know when we use it and when we actually see the requirement of the project.
07:38Now, if I specifically focus on SQL server flavors or options available on Microsoft Azure cloud, then we have three options in that also. As I said, the first one is a SQL server on Azure
07:50machine which is infrastructure as a service. And when I go with the platform as a service model, in that also we have two options. The first one is infrastructure as a service while the other two which I am showing you at the right side are actually Azure SQL server platform as a service options. Now, what is the difference between Azure SQL server managed
08:09instance and Azure SQL database that I will tell you in the coming slide. But right now you can see that there are two options in the platform as a service. Somehow the managed instance is the name itself is telling you that this is going to be having some management integrations or some kind of management control is also given to you if you want to manage it. And then you can also integrate that thing with your on premise database server. While Azure SQL database is purely a cloud based and cloud hosted database
08:38which is going to give you a least control on Azure which is going to give you a least control on that. Now, let's move forward and let's see each one of this one by one and we are going to compare it. First, if I focus on SQL server on virtual machine, then this is an infrastructure as a service solution that enables users to use a full version of SQL server in a cloud without having to manage any on premise hardware. When you are going with this option, then you are actually
09:07not willing to take care of your infrastructure and hardware kind of part. But yes, you want to take full control of your SQL server and that is a place where you can choose this one. This guarantees you a compatibility to SQL server on premise. So if you have any on premise SQL server with a specific version which is installed in that, then the same kind of compatibility you can get here and you can also integrate with that. You can take your customer managed keys. You can take care of your operating system upgrades.
09:36software upgrades, backups and replication as you like. You can just pay for the server and licensing cost not per database. So there are chances that you have created one SQL server on virtual machine.
09:49Virtual machine will be one and you have to pay for that. But then inside that virtual machine, if you create multiple databases, you don't need to pay for that. Yes, of course, you need to install a proper licensing with that. So maybe if you're using an enterprise version of SQL server or
10:05or just a developer edition of the SQL server, according to that your licensing will vary. Second option is Azure SQL database, which is the platform as a service offering and inside this also when you provision this database, you have plenty of flexible options available. Like I can go with the database server on the cloud with the only single database where I can create and run database server and it's going to have only one database inside which I can create multiple databases.
10:23multiple tables and I can write queries and I can write queries. Or maybe I can just go with a better scalable option which is elastic pool where multiple databases can share the same resource such as memory, CPU, storage likewise and then I did not need to pay for single database.
10:30I have to pay for one elastic pool which can have multiple databases which can have multiple databases created inside that.
11:00And those databases are going to have shared compute resources. Now if you're choosing Azure SQL database, this is going to be one of the best low cost option with minimal administration efforts in that.
11:12This is best for new cloud projects with flexible application design. And it also supports with variable loads. So you can scale it up, you can scale it down as per your requirement.
11:24And in the modern days, now a days, Azure SQL database is also available as a serverless database. What is serverless database is out of the scope of this context. But yes, you can search about that.
11:36That's also one of the advantage of Azure SQL databases. Now let's talk about the third platform as a service option which is Azure Mammage Instance.
11:46This allows you to pre-provision your compute resources and deploy several individual managed instances up to your pre-provision compute level.
11:55It's like you first define what kind of compute you're looking for and then after that on that compute you can deploy multiple databases.
12:03It also has a facilities of automatic backup, software patching, database monitoring and other administrative tasks.
12:11Almost 100% compatibility with your on-premise SQL Server. Now why we are saying almost or near 100%?
12:18Because there are chances that if you have a different version of SQL Server installed on on-premise then it won't allow you to integrate with that.
12:25This is actually supported by Azure Server and this also supports something called Instance Pull which is somehow very much similar to Elastic Pull.
12:34But in this case the instance are going to have multiple compute resources connected like a real server.
12:41Technically this is something like your one single SQL Server instance with multiple databases inside that.
12:47And with additional level of administrative task configuration compared to your Azure SQL database.
12:54If I compare this two then you can see that both are going to provide you pull.
13:00One is providing instance pull for the computers with the size of you know the smaller size like two virtual CPUs or virtual cores like that.
13:09And the other one which is Azure SQL database is providing you Elastic Pull which is fully managed service by Azure.
13:15And then you can just simplify your scaling, you can simplify your performance and management of multiple databases in that way.
13:23If I compare this two, almost everything is possible database wise or relational database wise in both.
13:30But yes, the left side one is going to be more control with on-premise integrations and facilities available with that.
13:40With obviously native virtual network support with that.
13:43And the right side one is going to be somehow it is available with hyperscale storage up to 100 terabytes.
13:51It is available as serverless compute.
13:53So more features are actually there in Azure SQL database because it is managed by Azure fully.
13:59And you really don't need to take pain of most of the administrative configurations.
14:04Now after Azure SQL server, there is a time to see the other three options which we have.
14:09We are not going to see these options practically in this particular training.
14:13But yes, I request you to read about these three things also.
14:16First one is PostgreSQL which is a relational database service in the Microsoft Cloud based on PostgreSQL Community Edition.
14:24And this is going to provide a fully configurable database engine which is available in Azure.
14:30The MySQL is something like it started with a very, very simple to use kind of open source database management system.
14:38And I'm sure you know about this because it's one of the leading open source relational database system.
14:45Which mostly works with the Linux, Apache, PHP kind of applications into that.
14:52The third one which is MariaDB is a newer database system compared to the other two.
14:57And it is created by the original developer of MySQL only.
15:02The database engine of MariaDB is rewritten and re-optimized to improve the performance.
15:08Compared to MySQL, MariaDB is going to provide a better performance.
15:13The Community Edition of this particular database is available on Azure which you can use for your projects.
15:19And this MariaDB is also compatible with the Oracle database.
15:23So if you want to do the integrations with Oracle database, that is going to be one of the options which is available on Azure.
15:30Now once we are familiar with all these flavors available in Azure Data Services,
15:35then obviously we need to understand that what kind of advantages we are getting when we choose one of them.
15:41Now obviously all these databases which we have seen here like Postgre, MySQL or MariaDB,
15:48these are fully managed community databases.
15:51These are built for high availability.
15:53So compared to on-premise servers, the service level agreement provided by Microsoft is providing you high availability.
16:00And obviously the lowest TCO which is total cost of ownership.
16:05Compared to on-premise there is no doubt whichever options you are going to choose here is going to be cost wise cheaper
16:11and availability wise highly available compared to on-premise because this is hosted on cloud.
16:18It can give you an intelligent performance and scaling configuration for that which can go up to a 16 TB of storage
16:25and more than 20,000 plus IOPS available in that.
16:29These are integrated with the industry leading security and compliance standard with that with advanced threat protection.
16:36So you can configure it, you can trust the Microsoft for that one.
16:40And then it is also integrated with the Azure ecosystem.
16:43It means there are a couple of inbuilt apps, inbuilt Azure services like services for geo-replication,
16:51services for Azure firewall security, services for client IP detection.
16:56All these are already integrated inside this particular databases so that you can easily configure them and take advantage of that.
17:05Now after knowing all these benefits, obviously it is must to see one of the database.
17:09We can provision the database on portal and then we can see that how we can utilize this thing.
17:15But that is something which I am going to cover in my next lesson.
17:19So in this particular video, we have seen the relational data services available in Azure.
17:26And we have not only seen the features of this, we have also compared one with the other one.
17:31And then we have discussed that which one is going to be useful at what time, which one is going to be available with the high availability,
17:39which is going to be cost-wise, cost-effective, as well as we have compared this thing with the on-premise SQL Server database.