---
# System prepended metadata

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

---

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