> For the complete documentation index, see [llms.txt](https://docs.arkannis.net/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.arkannis.net/cloud/azure/courses/az900-course/core-resources-available/database-services.md).

# Database Services

## Database Services Covered:

* Cosmos DB
* Azure SQL Database
* Azure Database for MySQL
* Azure Database for PostgreSQL
* SQL Managed Instance

**Most sophisticated applications have some type of database**

## Cosmos DB

* Extremely fast storage
* Designed for modern application such as mobile video games, social networks and things requiring thousands of global replication
* NoSQL Storage
* Multi-modal
* Supports many open-source APIs and protocols

## Azure SQL Database

* Runs on the SQL Server engine underneath
* Relational DB
* Database as a Service
* Easy to replicate
* Easy to scale
* Easy to migrate from SQL Server on-prem

## Azure Database for MySQL

* Managed MySQL database
* Common open-source DB
* Makes migration to the cloud easier if you rely on this one
* Wordpress uses it

## Azure Database for PostgreSQL

* Managed PostgreSQL database
* Open-source DB
* Has better support for clusters and more complex server setups
* Makes migration to the cloud easier if you rely on this one

## SQL Managed Instance

* Most compatible with existing SQL Server
* Minimal code changes
* Fully managed by Azure
* Always up-to-date