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
  • NoSQL Databases:
    • Azure Cosmos

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

Navigate and Playaround Azure Database Support