---
# System prepended metadata

title: 民國111.10.21 SQL分析、設計、開發
tags: [課程111ERP02]

---

---
tags: 課程111ERP02
---
# 民國111.10.21 SQL分析、設計、開發

[00_ERP班課程介紹](https://hackmd.io/@johnsonnote/course_erp)

[01_SQL Server 管理篇](https://hackmd.io/@johnsonnote/sqlmanage/https%3A%2F%2Fhackmd.io%2F%40johnsonnote%2FSQLMG01)

[02_SQL Server 設計篇](https://hackmd.io/@johnsonnote/sqldesign/https%3A%2F%2Fhackmd.io%2F%40johnsonnote%2FSQLDS01)

[03_跨平台網頁設計教學](https://hackmd.io/@johnsonnote/webdesign/https%3A%2F%2Fhackmd.io%2F%40johnsonnote%2FCSP00)

[99_ERP企業資源規劃](https://hackmd.io/@johnsonnote/erp/https%3A%2F%2Fhackmd.io%2F%40johnsonnote%2FERPBS01)

## 課程影像
[2022102102 install potplayer](https://www.youtube.com/watch?v=Zh-8n8lDlls&list=PL0DN0XYJik9bV-a8n_5CJy9Tbag2m3-wX&index=1)
[2022102103 drawio](https://www.youtube.com/watch?v=L4S_uZoVjHQ&list=PL0DN0XYJik9bV-a8n_5CJy9Tbag2m3-wX&index=2)
[2022102104 hackmd](https://www.youtube.com/watch?v=FqZE78J9wTM&list=PL0DN0XYJik9bV-a8n_5CJy9Tbag2m3-wX&index=3)
[2022102105 install sql server 2019](https://www.youtube.com/watch?v=yWvqbSXCVes&list=PL0DN0XYJik9bV-a8n_5CJy9Tbag2m3-wX&index=4)
[2022102106 setup sql server firewall](https://www.youtube.com/watch?v=LAEAlZ8L5VI&list=PL0DN0XYJik9bV-a8n_5CJy9Tbag2m3-wX&index=5)

## 第一節
![](https://i.imgur.com/2pEGnzU.png)
![](https://i.imgur.com/EpfPuDY.png)
![](https://i.imgur.com/EDitPyl.png)
![](https://i.imgur.com/qn3TQfN.png)
![](https://i.imgur.com/D7sH7Vs.png)
![](https://i.imgur.com/XWwNN7u.png)
![](https://i.imgur.com/WAxxqsw.png)
![](https://i.imgur.com/0Jg5Yj1.png)
![](https://i.imgur.com/m6QHVz0.png)
![](https://i.imgur.com/mBih9us.png)
![](https://i.imgur.com/G1KTL58.png)
![](https://i.imgur.com/OyY43Bz.png)
![](https://i.imgur.com/59mq78H.png)
![](https://i.imgur.com/uldPFSs.png)
![](https://i.imgur.com/mFO71lx.png)
![](https://i.imgur.com/55TzJnh.png)
![](https://i.imgur.com/plpyNXG.png)
![](https://i.imgur.com/GuWQGjf.png)
![](https://i.imgur.com/ektMV8j.png)
![](https://i.imgur.com/RpDzJCy.png)
![](https://i.imgur.com/ZQ8J9U5.png)
![](https://i.imgur.com/SYO8mUG.png)
![](https://i.imgur.com/7CxOKiG.png)
![](https://i.imgur.com/dlMjWbf.png)
![](https://i.imgur.com/3OcD588.png)
![](https://i.imgur.com/5N5lpVv.png)
![](https://i.imgur.com/Dg3a6cC.png)
![](https://i.imgur.com/2vMr93u.png)
![](https://i.imgur.com/fOxEBti.png)
![](https://i.imgur.com/SGZX6Fy.png)
![](https://i.imgur.com/qSLmsuL.png)
![](https://i.imgur.com/7AfYBht.png)
![](https://i.imgur.com/MwNmK4k.png)
![](https://i.imgur.com/mVWexhf.png)
![](https://i.imgur.com/7RM6Ohp.png)
![](https://i.imgur.com/UVCmgVs.png)
![](https://i.imgur.com/m541BaV.png)
![](https://i.imgur.com/rjady8J.png)
![](https://i.imgur.com/pY5pPe8.png)
![](https://i.imgur.com/mNXhEh1.png)
![](https://i.imgur.com/tHL20L6.png)
![](https://i.imgur.com/U1WsOwd.png)
![](https://i.imgur.com/mimphyg.png)
![](https://i.imgur.com/mPcNsmA.png)
![](https://i.imgur.com/dWxWD48.png)
![](https://i.imgur.com/hfenhZM.png)

## 第二節
![](https://i.imgur.com/ygFRoEm.png)
![](https://i.imgur.com/tZUSkJH.png)
![](https://i.imgur.com/diLFBzi.png)
![](https://i.imgur.com/8wDFlIc.png)
![](https://i.imgur.com/SHeGw7e.png)
![](https://i.imgur.com/n6kcWJh.png)
![](https://i.imgur.com/LsZufDu.png)
![](https://i.imgur.com/EYApsMp.png)
![](https://i.imgur.com/C2Gq3y2.png)
![](https://i.imgur.com/EOsfgcM.png)

## 第三節
![](https://i.imgur.com/iZtpt5x.png)
![](https://i.imgur.com/ToqHY57.png)
![](https://i.imgur.com/N8EXtAM.png)
![](https://i.imgur.com/b7gMvlx.png)
![](https://i.imgur.com/eNk2mfX.png)
![](https://i.imgur.com/nPUzlYg.png)
![](https://i.imgur.com/1AZA6Br.png)
![](https://i.imgur.com/LnvNqn7.png)
![](https://i.imgur.com/5qWOhY4.png)
![](https://i.imgur.com/WWzv2i9.png)
![](https://i.imgur.com/HqD6PRQ.png)
![](https://i.imgur.com/N2MBLHV.png)
![](https://i.imgur.com/v6U9z8r.png)
![](https://i.imgur.com/kMZWeV0.png)
![](https://i.imgur.com/4smdvOe.png)
![](https://i.imgur.com/Z3318Rt.png)
![](https://i.imgur.com/lTXMG2t.png)
![](https://i.imgur.com/dPFCOED.png)
![](https://i.imgur.com/CFotBpX.png)
![](https://i.imgur.com/FFGCn1h.png)
![](https://i.imgur.com/XRu7b0Q.png)
![](https://i.imgur.com/9DZrVL3.png)
![](https://i.imgur.com/NU0j2hp.png)
![](https://i.imgur.com/ew5NRNO.png)
![](https://i.imgur.com/iJraYot.png)
![](https://i.imgur.com/WqET6K5.png)
![](https://i.imgur.com/b0TCQsS.png)
![](https://i.imgur.com/t9fnFzd.png)
![](https://i.imgur.com/1isgqtW.png)
![](https://i.imgur.com/CaeyPVM.png)
![](https://i.imgur.com/hxTAKuj.png)
![](https://i.imgur.com/mfaYVDp.png)
![](https://i.imgur.com/qBQzEgH.png)
![](https://i.imgur.com/RaK9cja.png)
![](https://i.imgur.com/RRA2XAY.png)
![](https://i.imgur.com/TiEBdKk.png)
![](https://i.imgur.com/pZYrD9B.png)

## 第四節
![](https://i.imgur.com/CveGk8e.png)
![](https://i.imgur.com/fxsASDD.png)
![](https://i.imgur.com/g1Vecvq.png)
![](https://i.imgur.com/l5Y4qMD.png)
![](https://i.imgur.com/VedSWsL.png)
![](https://i.imgur.com/DhGMPPi.png)
![](https://i.imgur.com/uQsdpe4.png)
![](https://i.imgur.com/pPKD0bs.png)
![](https://i.imgur.com/LkdCiN7.png)
![](https://i.imgur.com/d9YMwUm.png)
![](https://i.imgur.com/0RBDDsH.png)
![](https://i.imgur.com/L3Qa4Nm.png)
![](https://i.imgur.com/1K5wApX.png)
![](https://i.imgur.com/O4xNBQe.png)
![](https://i.imgur.com/EchQbBg.png)
![](https://i.imgur.com/pTlbeL0.png)
![](https://i.imgur.com/yotYNSM.png)
![](https://i.imgur.com/Fvq4OkP.png)
![](https://i.imgur.com/WO5VCL1.png)
![](https://i.imgur.com/s04pUAN.png)
![](https://i.imgur.com/siUkLIL.png)
![](https://i.imgur.com/uKoTfbp.png)
![](https://i.imgur.com/afQy2kY.png)
![](https://i.imgur.com/01drx6A.png)
![](https://i.imgur.com/f2C4LtB.png)
![](https://i.imgur.com/3YidreN.png)
![](https://i.imgur.com/mpk95b5.png)
![](https://i.imgur.com/xG0txcz.png)
![](https://i.imgur.com/bfdQPXI.png)
![](https://i.imgur.com/vFPTQIv.png)
![](https://i.imgur.com/k4V6ENv.png)
![](https://i.imgur.com/WF7rIpF.png)
![](https://i.imgur.com/u8Ght9H.png)
![](https://i.imgur.com/CeWfSMn.png)
![](https://i.imgur.com/qiMFKEQ.png)
![](https://i.imgur.com/04s4bXI.png)
![](https://i.imgur.com/ZL46Lf0.png)
![](https://i.imgur.com/nYKCs4L.png)
![](https://i.imgur.com/iTCZ8GG.png)
![](https://i.imgur.com/K5RQPr1.png)
![](https://i.imgur.com/iLeLXUD.png)
![](https://i.imgur.com/S2Ikynn.png)
![](https://i.imgur.com/G41D0lm.png)
![](https://i.imgur.com/feYY0EK.png)
![](https://i.imgur.com/6zvP6W6.png)

## 第五節
![](https://i.imgur.com/diYMwBF.png)
![](https://i.imgur.com/8s4ebkJ.png)
![](https://i.imgur.com/jNrsbzF.png)
![](https://i.imgur.com/n8NL0bR.png)
![](https://i.imgur.com/BasnGct.png)
![](https://i.imgur.com/oj16IqH.png)
![](https://i.imgur.com/zKrLCE3.png)
![](https://i.imgur.com/6lqTxoR.png)
![](https://i.imgur.com/ZzCDqMt.png)
![](https://i.imgur.com/TTAyak8.png)
![](https://i.imgur.com/BW5BBsq.png)
![](https://i.imgur.com/EeQ6RQQ.png)
![](https://i.imgur.com/ws53gbN.png)
![](https://i.imgur.com/pPo74M9.png)
![](https://i.imgur.com/psM7umm.png)
![](https://i.imgur.com/v4i3qGm.png)
![](https://i.imgur.com/axDZ2EV.png)
![](https://i.imgur.com/5GxpejM.png)
![](https://i.imgur.com/mA3TU0A.png)
![](https://i.imgur.com/Hl0yzaM.png)
![](https://i.imgur.com/WwFUi44.png)
![](https://i.imgur.com/Eka20di.png)
![](https://i.imgur.com/pp39QL3.png)
![](https://i.imgur.com/htGqcaF.png)
![](https://i.imgur.com/ymhT4yo.png)
![](https://i.imgur.com/HRBOMXD.png)
![](https://i.imgur.com/cYaRqPE.png)
![](https://i.imgur.com/Ce8pi1t.png)
![](https://i.imgur.com/wx05BjH.png)
![](https://i.imgur.com/XQ4d9OG.png)
![](https://i.imgur.com/i9QQSmL.png)
![](https://i.imgur.com/dOjEc1B.png)
![](https://i.imgur.com/zr9XBEl.png)
![](https://i.imgur.com/80N6qXC.png)
![](https://i.imgur.com/o6MUKCD.png)
![](https://i.imgur.com/N7j9SKW.png)
![](https://i.imgur.com/5JpFIPp.png)
![](https://i.imgur.com/gGyd9dg.png)
![](https://i.imgur.com/P3XJ12h.png)
![](https://i.imgur.com/9yZ9tii.png)
![](https://i.imgur.com/m5am4S2.png)
![](https://i.imgur.com/1g4debP.png)
![](https://i.imgur.com/bWAC0Vy.png)
![](https://i.imgur.com/aSLpFyr.png)
![](https://i.imgur.com/p1Y5W5y.png)
![](https://i.imgur.com/Vcoad61.png)
![](https://i.imgur.com/bUZfH6Q.png)
![](https://i.imgur.com/quwrijQ.png)
![](https://i.imgur.com/0JxEYGj.png)
![](https://i.imgur.com/XTAIPwy.png)
![](https://i.imgur.com/CE2BJzw.png)
![](https://i.imgur.com/TKzSwGt.png)
![](https://i.imgur.com/wIdDAmx.png)
![](https://i.imgur.com/Mh154XG.png)
![](https://i.imgur.com/4zh4XYF.png)
![](https://i.imgur.com/0K3f1oP.png)
![](https://i.imgur.com/8makIpV.png)
![](https://i.imgur.com/PQgSTzf.png)

## 第六節
![](https://i.imgur.com/82H9I6V.png)
![](https://i.imgur.com/FS5tNqc.png)
![](https://i.imgur.com/HftjeSV.png)
![](https://i.imgur.com/zuaaWk7.png)
![](https://i.imgur.com/qie15Rl.png)
![](https://i.imgur.com/ifznujs.png)
![](https://i.imgur.com/S4KbV1M.png)
![](https://i.imgur.com/m4mFSBk.png)
![](https://i.imgur.com/BEELgk0.png)
![](https://i.imgur.com/oG3SBgg.png)
![](https://i.imgur.com/u2yw7Qa.png)
![](https://i.imgur.com/8wubpnO.png)
![](https://i.imgur.com/HJhQ1w4.png)
![](https://i.imgur.com/dFxnnKe.png)
![](https://i.imgur.com/S2zzOHU.png)
![](https://i.imgur.com/QerT9zZ.png)
![](https://i.imgur.com/086hTyJ.png)
![](https://i.imgur.com/npXMtUJ.png)
![](https://i.imgur.com/WIT4iL7.png)
![](https://i.imgur.com/oei7OgW.png)
![](https://i.imgur.com/ShJcWPn.png)
![](https://i.imgur.com/wZkCCys.png)
![](https://i.imgur.com/48GgdSz.png)
![](https://i.imgur.com/bdfjTwx.png)
![](https://i.imgur.com/gDloXqm.png)
![](https://i.imgur.com/A7rBwux.png)
![](https://i.imgur.com/0ONHC8e.png)
![](https://i.imgur.com/FupkDpM.png)
![](https://i.imgur.com/OsXtWEE.png)
![](https://i.imgur.com/e3GqtDK.png)
![](https://i.imgur.com/iyopCAF.png)
![](https://i.imgur.com/rdV38Kz.png)
![](https://i.imgur.com/O4Zfmat.png)
![](https://i.imgur.com/DaTjBp3.png)
![](https://i.imgur.com/5XCo9Km.png)
![](https://i.imgur.com/Wfqk1jL.png)
![](https://i.imgur.com/JruTriU.png)
![](https://i.imgur.com/MxdGPGD.png)
![](https://i.imgur.com/03Q5z5K.png)
![](https://i.imgur.com/AO6EIE2.png)
![](https://i.imgur.com/W3ZLS3I.png)
![](https://i.imgur.com/0TV71oQ.png)
![](https://i.imgur.com/TtUQnRO.png)
![](https://i.imgur.com/ueYWhjY.png)
![](https://i.imgur.com/BgHB5ON.png)
![](https://i.imgur.com/4g1v7ys.png)
![](https://i.imgur.com/rOjydQM.png)
![](https://i.imgur.com/FnJxgxn.png)
![](https://i.imgur.com/L6Cpdrk.png)
![](https://i.imgur.com/OwYIHkI.png)
![](https://i.imgur.com/BacrQxo.png)
![](https://i.imgur.com/wvCHKDt.png)
![](https://i.imgur.com/SgKcA2T.png)
![](https://i.imgur.com/nkLscrd.png)