Microsoft Certified

Azure Data Fundamentals , Learning paths

1.Explore core data concepts

1.1 Explore core data concepts

• Introduction to Azure SQL Database
• Introduction to Azure Blob storage
• Introduction to Azure Cosmos DB
• Description of the database normalization basics

1.2 Explore roles and responsibilities in the world of data

• Overview of Azure Databricks
• Overview of Azure HDInsight
• Introduction to Azure Cosmos DB
• Overview of Power BI
• SQL Server Technical Documentation
• Introduction to Azure Data Factory

1.3 Describe concepts of relational data

• Description of the database normalization basics
• Structured Query Language (SQL)
• Technical overview of SQL Database
• SQL Server Technical Documentation
• SQL Database PaaS vs IaaS Offerings

1.4 Explore concepts of non-relational data

• Welcome to Azure Cosmos DB
• Indexing in Azure Cosmos DB – Overview
• Introduction to Azure Cosmos DB: Table API
• Introduction to Azure Cosmos DB: Gremlin API
• Introduction to Azure Blob storage

1.5 Explore concepts of data analytics

• Create reports and dashboards in Power BI – documentation
• Azure Databricks
• Azure Cognitive Services
• Extract, transform, and load (ETL)

2.Explore relational data in Azure

2.1 Explore relational data services in Azure

• Choose the right deployment option
• What is a single database in Azure SQL Database
• What is Azure SQL Database managed instance?
• Data Migration Assistant (DMA)
• Azure Database Migration Service (DMS)
• Choose the right data store
• Transport Layer Security
• Transparent Data Encryption
• Always Encrypted

2.2 Explore provisioning and deploying relational database services in Azure

• Create an Azure Database for PostgreSQL
• Create an Azure Database for MySQL
• Create an Azure single Database
• Azure SQL Database documentation
• PostgreSQL Server parameters
• PostgreSQL extensions in Azure Database for PostgreSQL – Single Server
• How to configure server parameters in Azure Database for MySQL by using the Azure portal

2.3 Query relational data in Azure

• sqlcmd Utility
• Download and install Azure Data Studio
• Download SQL Server Management Studio (SSMS)
• Tutorial: Design a relational database in a single database within Azure SQL using SSMS
• MySQL Community Downloads
• Azure Database for MySQL: Use MySQL Workbench to connect and query data
• Quickstart: Use the Azure portal’s query editor to query a database
• DML Queries with SQL
• Joins (SQL Server)

3.Explore non-relational data in Azure

3.1 Explore non-relational data offerings in Azure

• Understanding the Table service data model
• Azure Table storage table design guide: Scalable and performant tables
• Introduction to Azure Blob storage
• Introduction to Azure Data Lake Storage Gen2
• Static website hosting in Azure Storage
• What is Azure Files?
• Planning for an Azure Files deployment
• Welcome to Azure Cosmos DB
• Indexing in Azure Cosmos DB – Overview
• Consistency levels in Azure Cosmos DB

3.2 Explore provisioning and deploying non-relational data services in Azure

• What is Azure CLI
• Azure PowerShell documentation
• What are Azure Resource Manager templates?
• Built-in Jupyter notebooks in Azure Cosmos DB
• What is Azure Private Endpoint?
• Manage Azure Cosmos DB Core (SQL) API resources with Azure Resource Manager templates
• Configure Azure Storage firewalls and virtual networks
• Create or update Azure custom roles using the Azure portal
• Add or remove Azure role assignments using the Azure portal
• What is Azure Active Directory?

3.3 Manage non-relational data stores in Azure

• Common Azure Cosmos DB use cases
• Migrate normalized database schema from Azure SQL Database to Azure CosmosDB denormalized container
• Copy and transform data in Azure Cosmos DB (SQL API) by using Azure Data Factory
• Quickstart: Build a console app using the .NET V4 SDK to manage Azure Cosmos DB SQL API account resources
• Getting started with SQL queries
• az storage container create
• New-AzStorageContainer
• az storage blob upload
• Set-AzStorageBlobContent
• az storage blob list
• Get-AzStorageBlob
• az storage blob download
• az storage blob download-batch Get-AzStorageBlobContent
• az storage blob delete
• Remove-AzStorageBlob
• az storage blob delete-batch
• az storage container delete
• Remove-AzStorageContainer
• Get started with AzCopy
• Azure Storage Explorer
• Transfer data with AzCopy and file storage

4.Explore modern data warehouse analytics in Azure

Learn more

สร้าง QnA Maker ตามนี้ Exercise – Create a bot – Learn | Microsoft Docs

เสร็จแล้วก็ Publish จะได้ตัวอย่างการเรียกด้วย Postman และ Curl

POST /knowledgebases/65c21545-xxxx-4cc9-982f-35649a25398a/generateAnswer
Host: https://2021-11-qna.azurewebsites.net/qnamaker
Authorization: EndpointKey 6a5fc60b-xxxx-4121-a921-159eac6eec90
Content-Type: application/json
{"question":"<Your question>"}

curl -X POST https://2021-11-qna.azurewebsites.net/qnamaker/knowledgebases/65c21545-xxxx-4cc9-982f-35649a25398a/generateAnswer -H "Authorization: EndpointKey 6a5fc60b-xxxx-4121-a921-159eac6eec90" -H "Content-type: application/json" -d "{'question':'<Your question>'}"

ลองเรียกด้วย Postman

Response แต่ละแบบ

{
    "error": {
        "code": "Unauthorized",
        "message": "Authorization Failed"
    }
}

{
    "answers": [
        {
            "questions": [],
            "answer": "No good match found in KB.",
            "score": 0.0,
            "id": -1,
            "isDocumentText": false,
            "metadata": []
        }
    ],
    "activeLearningEnabled": false
}

{
    "answers": [
        {
            "questions": [
                "Hello",
                "Hi"
            ],
            "answer": "Hi man!",
            "score": 100.0,
            "id": 9,
            "source": "Editorial",
            "isDocumentText": false,
            "metadata": [],
            "context": {
                "isContextOnly": false,
                "prompts": []
            }
        }
    ],
    "activeLearningEnabled": false
}

Link

• How to call QnA maker knowledgebase API through Postman

Microsoft Certified

Azure AI Fundamentals , Learning paths

1.Get started with artificial intelligence

2.Explore visual tools for machine learning

3.Explore computer vision

4.Explore natural language processing

5.Explore conversational AI

6.Explore decision support

7.Explore knowledge mining

Choose a bot-building tool

Prepare for AI engineering

Azure Services

Azure Machine Learning studio

Anomaly Detector – Documentation

QnA Maker – Documentation – เรียก QnA Maker ด้วย Postman

Pricing – Face API – Doc

Computer Vision – Docs

Custom Vision – Custom Vision – Doc

Azure Form Recognizer Doc

Language

Cognitive Speech Services – Doc

Translator documentation

LUIS – Doc

Azure Bot Service

Bot Framework – Documentation – botframework-sdk

Microsoft

Seeing AI App from Microsoft

1. ดาว์นโหลดและติดตั้ง Bot Framework SDK for .NET
2. สร้าง bot
3. รันทดสอบด้วย emulator 
4. BotBuilder Samples list