# AZURE DP203: Day 1

## 課程內容:
註冊一個Azure的帳號, 使用SYSTEX給的Azure Pass 領取150 USD 的點數
登入到 Azure portal 更改語言設定為英文
在Azure Portal 中的 Subscription_Azure Pass 改名為 Azure Pass DP203

* 領取 Azure Pass 點數網站:https://www.microsoftazurepass.com/

* Azure Portal:https://portal.azure.com/?l=en.en-us#home

* Azure Synapse:https://web.azuresynapse.net

* Git Hub Labs (每天3篇):https://github.com/MicrosoftLearning/DP-203-Data-Engineer/blob/master/Instructions/Labs/LAB_00_lab_setup_instructions.md

* Data for GitHub Labs: https://drive.google.com/drive/folders/1ceNS1Q680OLctTC8ZFajtC-5HqUMTAYm?usp=sharing

* Movies Analytics using Azure Data Factory (extra): https://github.com/djpmsft/adf-ready-demo/blob/master/ADF_Lab_Instructions.md

第一堂課, 介紹了Azure常用的幾個Module. Etc. DataLake, DataBrick, DataFactory, Azure Synapse, SQL Pools...
也講解了一些資料的處理過程, 像是什麼是ETL? ...第一天講解的大綱如下:

## - [ ] Module 0: Data Engineer in Azure Course overview
* About this course
* Course agenda
* Audience
* Prerequisites
* Course Lab setup

## - [ ] Module 1: Explore compute and storage options for data engineer workloads
* Introduction to Azure Synapse Analytics
* Describe Azure Databricks
* Introduction to Azure Data Lake storage
* Describe Delta Lake Architecture
* Work with data streams by using Azure Stream Analytics

## - [ ] Module 2: Run interactive queries using Azure Synapse Analytics serverless SQL Pool
* Explore Azure Synapse serverless SQL pools capabilities
* Query data in the lake using Azure Synapse serverless SQL pools
* Create metadata objects in Azure Synapse serverless SQL pools
* Secure data and manage users in Azure Synapse serverless SQL pools

老師會大約每天給你3篇GitHub 上面他寫的 Labs 讓你做, 第一天就是搭環境, 設定SQL Database, Virtual Machine, 此部分使用powershell(管理人員權限開啟), 需在自已的 Windows 上確定有安裝 Windows PowerShell 5.1 (Windows 10/11 內建)，沒有裝的可以到以下網址裝:
https://docs.microsoft.com/en-us/powershell/scripting/windows-powershell/install/installing-windows-powershell?view=powershell-7.2#upgrading-existing-windows-powershell

在使用Powershell 執行Labs 和其他設定commend 之前需要在自已的 Windows 上安裝 Azure CLI, 可以在此連結下載: https://docs.microsoft.com/zh-tw/cli/azure/install-azure-cli

Lab 的主要內容為架 Azure Databrick 的叢集, Import Notebook (code), Run the code in notebook and terminate the Cluster from Databrick "Comput",如何關掉Clusters, using serverless SQL Pools to Queres等等

實作方面大概就copy >>> paste >>> run code >>> debug >>> run code >>> sucess

Azure 點數的使用情況 (Usage rate) 可查此連結: https://www.microsoftazuresponsorships.com/balance