--- tags: 課程111ERP02 --- # 民國111.10.26 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) ## 課程影片 [2022102601 db offline backup](https://www.youtube.com/watch?v=ZjzhdOGRAQ0&list=PL0DN0XYJik9bV-a8n_5CJy9Tbag2m3-wX&index=6) [2022102602 db online backup manual](https://www.youtube.com/watch?v=rPtmy-bp0OY&list=PL0DN0XYJik9bV-a8n_5CJy9Tbag2m3-wX&index=7) [2022102603 db online backup job](https://www.youtube.com/watch?v=FNPPiTqrQDY&list=PL0DN0XYJik9bV-a8n_5CJy9Tbag2m3-wX&index=8) [2022102604 db online backup tsql](https://www.youtube.com/watch?v=UxnmKR3CpIw&list=PL0DN0XYJik9bV-a8n_5CJy9Tbag2m3-wX&index=9) [2022102605 db alert email](https://www.youtube.com/watch?v=kvw6KnMhuOI&list=PL0DN0XYJik9bV-a8n_5CJy9Tbag2m3-wX&index=10) [2022102606 db alert line notify](https://www.youtube.com/watch?v=ItGwcYipjrg&list=PL0DN0XYJik9bV-a8n_5CJy9Tbag2m3-wX&index=11) ## 第一節 ![](https://i.imgur.com/jOJ7i8p.png) ![](https://i.imgur.com/uEXlm65.png) ![](https://i.imgur.com/tFQexHb.png) ![](https://i.imgur.com/Gc80Uze.png) ![](https://i.imgur.com/fWwL9wS.png) ![](https://i.imgur.com/lg5yIXB.png) ![](https://i.imgur.com/KCZeZYJ.png) ![](https://i.imgur.com/5jCJ3E4.png) ![](https://i.imgur.com/A1DPzbe.png) ![](https://i.imgur.com/tmU6EIc.png) ![](https://i.imgur.com/eJb488s.png) ![](https://i.imgur.com/t2rmLPX.png) ![](https://i.imgur.com/0hSkl6z.png) ![](https://i.imgur.com/YHRLgTR.png) ![](https://i.imgur.com/8mrZjGl.png) ![](https://i.imgur.com/cMkNQ1b.png) ![](https://i.imgur.com/I7Z1sZ1.png) ![](https://i.imgur.com/E3dIaKB.png) ![](https://i.imgur.com/Gyl0JA6.png) ![](https://i.imgur.com/UpXfbV4.png) ![](https://i.imgur.com/lok6VxX.png) ![](https://i.imgur.com/RUpsiCh.png) ![](https://i.imgur.com/eH3aiCJ.png) ![](https://i.imgur.com/l811coV.png) ![](https://i.imgur.com/HHQbYdN.png) ![](https://i.imgur.com/Z5mCzpw.png) ![](https://i.imgur.com/cHoLYtz.png) ![](https://i.imgur.com/IilzMrY.png) ![](https://i.imgur.com/MvYdiqJ.png) ![](https://i.imgur.com/QuUDU5N.png) ![](https://i.imgur.com/D5KMXOM.png) ![](https://i.imgur.com/uQfbKHX.png) ![](https://i.imgur.com/hPyXlYd.png) ![](https://i.imgur.com/jX4XX4K.png) ![](https://i.imgur.com/NLuURZM.png) ![](https://i.imgur.com/aYE6Yc6.png) ![](https://i.imgur.com/daund1H.png) ![](https://i.imgur.com/oTaXTdj.png) ![](https://i.imgur.com/FaOWqUv.png) ![](https://i.imgur.com/3dpffU4.png) ![](https://i.imgur.com/t2hBSbD.png) ![](https://i.imgur.com/iBgmLOa.png) ![](https://i.imgur.com/wczeoPK.png) ![](https://i.imgur.com/rz7veTK.png) ![](https://i.imgur.com/zm3AkNY.png) ![](https://i.imgur.com/0xk8d7q.png) ![](https://i.imgur.com/tJNKT7c.png) ![](https://i.imgur.com/Uh6JP50.png) ![](https://i.imgur.com/Lfz2zUw.png) ![](https://i.imgur.com/0sjssc5.png) ![](https://i.imgur.com/ALGZmsw.png) ![](https://i.imgur.com/TiCBHvV.png) ![](https://i.imgur.com/lk10ePr.png) ![](https://i.imgur.com/Q9cPaeh.png) ![](https://i.imgur.com/mcmRuOI.png) ![](https://i.imgur.com/RjJ9h7G.png) ![](https://i.imgur.com/MZrY5jy.png) ![](https://i.imgur.com/zDqZ53R.png) ## 第二節 ![](https://i.imgur.com/VMkjw7G.png) ![](https://i.imgur.com/Gk4gDr5.png) ![](https://i.imgur.com/wKj2NEE.png) ![](https://i.imgur.com/HFrrgej.png) ![](https://i.imgur.com/IyizHRh.png) ![](https://i.imgur.com/zCZWlEq.png) ![](https://i.imgur.com/76KIuvo.png) ![](https://i.imgur.com/qRNb9jI.png) ![](https://i.imgur.com/3Qo2Kkp.png) ![](https://i.imgur.com/EKp6ax7.png) ![](https://i.imgur.com/JRoZTME.png) ![](https://i.imgur.com/EuNUfZ9.png) ![](https://i.imgur.com/1WrGuD3.png) ![](https://i.imgur.com/PjyPVpX.png) ![](https://i.imgur.com/5hv8uzs.png) ![](https://i.imgur.com/5UGwAOl.png) ![](https://i.imgur.com/Uza14Kt.png) ![](https://i.imgur.com/ln61nZQ.png) ![](https://i.imgur.com/GdpcivK.png) ![](https://i.imgur.com/LcMhzTU.png) ![](https://i.imgur.com/tgrk0qS.png) ![](https://i.imgur.com/0vmN4Rv.png) ![](https://i.imgur.com/Foom7PT.png) ![](https://i.imgur.com/6pl7XAT.png) ![](https://i.imgur.com/dOm3tH0.png) ![](https://i.imgur.com/0L48ySy.png) ![](https://i.imgur.com/69B2anI.png) ![](https://i.imgur.com/icDmau1.png) ![](https://i.imgur.com/dC0ZLbp.png) ![](https://i.imgur.com/DG7OJ7Q.png) ## 第三節 ![](https://i.imgur.com/e3Nyuur.png) ![](https://i.imgur.com/gaCr3bj.png) ![](https://i.imgur.com/ns2BU7d.png) ![](https://i.imgur.com/USJ6hWl.png) ![](https://i.imgur.com/FhltRHj.png) ![](https://i.imgur.com/mvgVO5W.png) ![](https://i.imgur.com/qbG2OuQ.png) ![](https://i.imgur.com/16LaGUK.png) ![](https://i.imgur.com/MJVseB4.png) ![](https://i.imgur.com/QIJU4ae.png) ![](https://i.imgur.com/9bfal4n.png) ![](https://i.imgur.com/eWAIs9s.png) ![](https://i.imgur.com/6HYIDuT.png) ![](https://i.imgur.com/aZpYkYP.png) ![](https://i.imgur.com/l4OPAH8.png) ![](https://i.imgur.com/exePVcB.png) ![](https://i.imgur.com/dPiDutP.png) ![](https://i.imgur.com/KMDFbUg.png) ![](https://i.imgur.com/pUL7j8C.png) ## 第四節 ![](https://i.imgur.com/3k7QNk9.png) ![](https://i.imgur.com/B3KWnJe.png) ![](https://i.imgur.com/7ZTzm7a.png) ![](https://i.imgur.com/u5moVpZ.png) ![](https://i.imgur.com/Kv2lrlz.png) ![](https://i.imgur.com/Fd61Fmd.png) ![](https://i.imgur.com/EeTSKPi.png) ![](https://i.imgur.com/4zM1VZ7.png) ![](https://i.imgur.com/u0FoQiT.png) ![](https://i.imgur.com/xjBypaJ.png) ![](https://i.imgur.com/aj7NzwS.png) ![](https://i.imgur.com/32p6Zqs.png) ![](https://i.imgur.com/0raz7im.png) ![](https://i.imgur.com/MNtrEGX.png) ![](https://i.imgur.com/NoUgaev.png) ![](https://i.imgur.com/aE9f57M.png) ![](https://i.imgur.com/c3dOUH5.png) ![](https://i.imgur.com/It0m1e1.png) ![](https://i.imgur.com/2T0Izmg.png) ![](https://i.imgur.com/gA66U7P.png) ![](https://i.imgur.com/QeBKi1W.png) ![](https://i.imgur.com/YGBf6FK.png) ![](https://i.imgur.com/6x8ya5x.png) ![](https://i.imgur.com/vfxotpn.png) ![](https://i.imgur.com/YGLihUu.png) ![](https://i.imgur.com/0Djk5sI.png) ## 第五節 ![](https://i.imgur.com/mFGnC0D.png) ![](https://i.imgur.com/x4rtOxg.png) ![](https://i.imgur.com/Bz0oFHo.png) ![](https://i.imgur.com/AJHPdC9.png) ![](https://i.imgur.com/zBdh28A.png) ![](https://i.imgur.com/zPticIn.png) ![](https://i.imgur.com/XVUUdfi.png) ![](https://i.imgur.com/Lk4lLCO.png) ![](https://i.imgur.com/jt73hk9.png) ![](https://i.imgur.com/hFH9L7K.png) ![](https://i.imgur.com/lrYDezO.png) ![](https://i.imgur.com/oTsYIW8.png) ![](https://i.imgur.com/zCc4F7c.png) ![](https://i.imgur.com/q6c8LKE.png) ![](https://i.imgur.com/EYHNlOf.png) ![](https://i.imgur.com/QfZ5e4V.png) ![](https://i.imgur.com/QCckptK.png) ![](https://i.imgur.com/c1fgzQS.png) ![](https://i.imgur.com/PuaCqWL.png) ![](https://i.imgur.com/BCHbFqZ.png) ![](https://i.imgur.com/rbQy5Ge.png) ![](https://i.imgur.com/RQPHwPv.png) ![](https://i.imgur.com/LvHp9x5.png) ![](https://i.imgur.com/JWH6niA.png) ![](https://i.imgur.com/iUhz9BT.png) ![](https://i.imgur.com/nxUStSb.png) ![](https://i.imgur.com/xCNOdWp.png) ![](https://i.imgur.com/jS68sbc.png) ![](https://i.imgur.com/uYjssL7.png) ![](https://i.imgur.com/qYfyUsW.png) ![](https://i.imgur.com/PhRs0iU.png) ![](https://i.imgur.com/Ull2L2L.png) ![](https://i.imgur.com/vuxYPPi.png) ![](https://i.imgur.com/Ah1aBja.png) ![](https://i.imgur.com/IS7RWEz.png) ![](https://i.imgur.com/SQjjRdT.png) ![](https://i.imgur.com/8JmgSGK.png) ![](https://i.imgur.com/eeL4tCS.png) ![](https://i.imgur.com/yZZal7N.png) ![](https://i.imgur.com/aJSShJb.png) ![](https://i.imgur.com/ogwYtGZ.png) ![](https://i.imgur.com/wSedF9p.png) ![](https://i.imgur.com/kbzmA7r.png) ![](https://i.imgur.com/5EczQse.png) ## 第六節 ![](https://i.imgur.com/5KGydGH.png) ![](https://i.imgur.com/poIOUlc.png) ![](https://i.imgur.com/F0YeC0O.png) ![](https://i.imgur.com/U0S94SM.png) ![](https://i.imgur.com/GAy8r1t.png) ![](https://i.imgur.com/50zpsOf.png) ![](https://i.imgur.com/cEIxERh.png) ![](https://i.imgur.com/9rHgP66.png) ![](https://i.imgur.com/hQJT3Hc.png) ![](https://i.imgur.com/jNUxvA8.png) ![](https://i.imgur.com/DUeIToy.png) ![](https://i.imgur.com/96C9My2.png) ![](https://i.imgur.com/2EWnqDi.png) ![](https://i.imgur.com/V9hA3Mi.png) ![](https://i.imgur.com/zhSe0iJ.png) ![](https://i.imgur.com/sj1wN3T.png) ![](https://i.imgur.com/VM0riJ0.png) ![](https://i.imgur.com/zGRIZ0d.png) ![](https://i.imgur.com/MqmFHEr.png) ![](https://i.imgur.com/omBbNsR.png) ![](https://i.imgur.com/osVa15u.png) ![](https://i.imgur.com/Ak5149P.png) ![](https://i.imgur.com/k1EY5U7.png) ![](https://i.imgur.com/h4iIFgM.png) ![](https://i.imgur.com/lUPyryH.png) ![](https://i.imgur.com/FV2fL1f.png) ![](https://i.imgur.com/g0W0QFP.png) ![](https://i.imgur.com/wuNwDXT.png) ![](https://i.imgur.com/l7RiEls.png) ![](https://i.imgur.com/fuh6OQL.png) ![](https://i.imgur.com/4c1IqST.png) ![](https://i.imgur.com/re4viHi.png) ![](https://i.imgur.com/qbOlzzk.png) ![](https://i.imgur.com/eozKudU.png) ![](https://i.imgur.com/atme9pY.png)