New Training: Identify Basic Management Tasks for Relational Data
In this 6-video skill, CBT Nuggets trainer Ben Finkel discusses the various ways Azure stores and manages relational database systems in the cloud for us. We’ll review deployment, connectivity, security, and querying. Watch this new Azure training.
Learn Azure with one of these courses:
This training includes:
- 6 videos
- 51 minutes of training
You’ll learn these topics in this skill:
- Provisioning and Deploying Relational Azure Services
- Deploying Azure SQL Database
- Deploying an Azure PostgreSQL Database
- Azure SQL Querying Tools
- Deploying with Resource Manager
- Cleaning up Azure Deployments
What are the Big Differences Between Azure, MySQL and PostgreSQL?
Three of the most popular relational database management systems (Relational DBMS) are Microsoft’s Azure, PostgreSQL and MySQL. These three compete for the attention of not only companies but also developers and administrators — constantly trying to expand their market share as well as the number of bright minds developing them.
The Microsoft Azure SQL Database is a Database as a Service offering that’s highly compatible with SQL Server databases. The inherent strength of Microsoft Azure SQL is obviously that it’s backed by Microsoft and therefore boasts interoperability with the rest of Microsoft’s many service offerings. From a technical perspective, its commercial license and support for fewer programming languages differentiates Azure SQL the most.
MySQL is an open source DBMS that has rediscovered the popularity it enjoyed before Sun acquired it in 2008. Ever Since MySQL 8.0’s release in 2018, its high speed and especially its support for NoSQL document stores and JSON has made MySQL a popular rival to Azure and PostgreSQL.
PostgreSQL is also open source and is popular mostly because of its stability and large feature set. DevOps professionals in particular like PostgreSQL because of the breadth of plug-ins and customizable features it supports. PostgreSQL is also a base technology for many other systems. PostgreSQL is often preferred by technically minded administrators doing extensive customization to their databases’ performance.