--- 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)