Upgrade to Pro — share decks privately, control downloads, hide ads and more …
Sign up for free

Database 教學簡報

Avatar for Denix Denix
September 14, 2017
Programming
80
0

Database 教學簡報

CMRDB Workshop - Database

Avatar for Denix

Denix

September 14, 2017

More Decks by Denix

See All by Denix
Android_Scalable_Modularized_Testable_Architecture.pdf
Avatar for Denix denishsieh
0
330
Learning Android
Avatar for Denix denishsieh
0
59
你所不知道所得分配的事
Avatar for Denix denishsieh
0
90
Git 教學簡報
Avatar for Denix denishsieh
0
310

Other Decks in Programming

See All in Programming
R8 の設定見直しでアプリサイズ削減
Avatar for ANDPAD inc andpad
0
220
外から家のPCの電源入れたい！をＰＨＰで解決する
Avatar for かわしも（Shimokawa Shion） kawashimo0
1
130
Starting & Sustaining Code-Based E2E Testing for Non-Coding QA Teams( #jasstniigata )
Avatar for teyamagu teyamagu
PRO
1
1k
iOS 27でニュースアプリはどう変わる！？ 〜日経電子版の新機能対応と、開発事例から〜
Avatar for Kazuki Nakashima lynnswap
7
13k
C#の現在地 進化の歴史と、AI時代の.NET Everywhere
Avatar for Yoshifumi Kawai neuecc
5
5.2k
dotNET_vulnclicker_intro.pdf
Avatar for Tomohiko Morita deka_morita
0
140
IBM Bob でAI駆動開発『QC-Playbook』
Avatar for 1kano ichirokano2
0
110
SREの越境 / SRE Collaboration
Avatar for y-ohgi y0hgi
2
310
Domain-Driven Transformation
Avatar for Henning Schwentner hschwentner
2
2.3k
Vue Fes Japan の “作る側”に関わってみて
Avatar for Naoki Haba naokihaba
0
160
残高管理から台帳サービスへの進化
Avatar for kobaryo artoy
1
200
When benchmarks go bad - what I learned from measuring performance wrong
Avatar for Holly Cummins hollycummins
0
220

Featured

See All Featured
Why You Should Never Use an ORM
Avatar for John Nunemaker jnunemaker
PRO
61
10k
Paper Plane
Avatar for Katie Cordina Lindsey katiecoart
PRO
5
54k
Practical Tips for Bootstrapping Information Extraction Pipelines
Avatar for Matthew Honnibal honnibal
25
2.1k
Max Prin - Stacking Signals: How International SEO Comes Together (And Falls Apart)
Avatar for Tech SEO Connect techseoconnect
PRO
0
490
Design and Strategy: How to Deal with People Who Don’t "Get" Design
Avatar for Morgane Peng morganepeng
133
20k
Building Flexible Design Systems
Avatar for Yesenia Perez-Cruz yeseniaperezcruz
330
41k
Building the Perfect Custom Keyboard
Avatar for Naoto Takai takai
2
910
Mind Mapping
Avatar for Hélio Medeiros helmedeiros
1
400
More Than Pixels: Becoming A User Experience Designer
Avatar for Michelle Schulp Hunt marktimemedia
3
560
CoffeeScript is Beautiful & I Never Want to Write Plain JavaScript Again
Avatar for Sam Stephenson sstephenson
162
16k
The browser strikes back
Avatar for Jono Alderson jonoalderson
0
1.8k
Building AI with AI
Avatar for Ines Montani inesmontani
PRO
1
1.3k

Transcript

  1. CMRDB 靜宜大學行雲者研發基地 DATABASE基礎教學 謝宗翰

  2. 2 Agenda ◎資料庫概論 ◎SQL簡介 Ø CRUD ◎動手做更有感覺!

  3. 3 資料庫概論

  4. 4 儲存與管理資料

  5. 5 將卡片排序

  6. 6 用電腦管理資料

  7. 7 一大堆資料，查詢困難@@

  8. 8 資料庫管理系統&資料庫伺服器

  9. 9 依照需求使用DB

  10. 10 DATABASE

  11. 11 表格TABLE

  12. 12 查詢表格資料

  13. 13 建立其他表格資料

  14. 14 要怎麼新增、查詢、修改、 刪除DATA? 使用SQL指令!

  15. 15 SQL簡介

  16. 16 SQL ◎Structured Query Language Ø 結構化查詢語言 ◎念作「sequel」 ◎與資料庫做溝通 對資料庫做CRUD

    Create : 新增 Read : 讀取 Update : 更新 Delete : 刪除

  17. 17 CRUD前基本概念

  18. 18 資料庫 -> 表格tables

  19. 19 表格 -> 欄位(column)

  20. 20 表格 -> 列(row) or 紀錄(record)

  21. 21 指定一個欄位為primary key 主索引鍵(PK) 絕對不會重複

  22. 22 DATA TYPE

  23. 23 小憩一下~等等要動手做囉!

  24. 24 查詢select(Read) SELECT column FROM table WHERE condition

  25. 25 新增insert(Create) INSERT INTO column,… VALUES (val,…)

  26. 26 更新update(U) UPDATE table SET column=…[,…] WHERE condition

  27. 27 刪除delete(D) DELETE FROM table WHERE condition

  28. 28 Q&A