---
# System prepended metadata

title: 'AZURE DP203: Day 1'

---

# 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