Databases in Azure
- Azure Supports the following in the world of databases (natively)
- Relational Database:
- SQL Server:
- SQL Server on Virtual Machines
- Azure SQL Datbase
- MySQL: Azure Database for MySQL
- PostgreSQL: Azure Database for Postgres
- SQL Server:
- NoSQL Databases:
- Azure Cosmos
- Relational Database:
Analytics Support on Azure
- Data ware house => Azure Synapse Analytics
- Apache-Spark => Azure Databricks
- Fully Managed Hadoop & Spark => HDInsight
- Predictive Analysis => Machine Learning
- Parallel Analytics No limits data lake
- Data Lake Store
- Data Lake Analytics
- Data Integration Service
- Data Factory
What we need to understand in Azure while Learning ?
- If you are a Data Engineer:
- you need to deal with the application
- What does Azure do for you?
- If you are a Cloud Administrator:
- How to Create and manage the data platform asked
- Understand the boundaries of what azure provides and what has to be done by your enterprise
Azure-Free Tier Account
- How to Create Refer Here
What is Managed and UnManaged
- Differnece between Managed and Un-Managed is who is responsible for Database
- Managed Database
- UnManaged Database