Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
Database 教學簡報
Search
Denix
September 14, 2017
Programming
0
50
Database 教學簡報
CMRDB Workshop - Database
Denix
September 14, 2017
Tweet
Share
More Decks by Denix
See All by Denix
Android_Scalable_Modularized_Testable_Architecture.pdf
denishsieh
0
190
Learning Android
denishsieh
0
33
你所不知道所得分配的事
denishsieh
0
44
Git 教學簡報
denishsieh
0
170
Other Decks in Programming
See All in Programming
Implementing Design Systems in Swift
seyfoyun
2
520
Productivity is Messing Around and Having Fun
hollycummins
1
160
2 週間で Twitter Bot を作ってみた
contour_gara
0
830
TypeScriptとGraphQLで実現する 型安全なAPI実装 / TSKaigi 2024
hokaccha
5
2.3k
デフォルトにして至高、RubyMineの大好きな所
ruzia
0
1.3k
ServerAction で Progressive Enhancement はどこまで頑張れるか? / progressive-enhancement-with-server-action
takefumiyoshii
6
500
Revisiting the Hotwire Landscape after Turbo 8 @ RailsConf 2024, Detroit
marcoroth
3
580
RaaP
ksss
0
140
Fragment Composition of GraphQL
quramy
14
1.6k
Deep Dive into React Stream/Serialize
mugi_uno
4
840
Inner Source@DB: Eine Geschichte über Open-Source-Praktiken im DB Konzern
morl99
1
110
From Spring Boot 2 to Spring Boot 3 with Java 21 and Jakarta EE
ivargrimstad
0
1.1k
Featured
See All Featured
The Language of Interfaces
destraynor
151
23k
Stop Working from a Prison Cell
hatefulcrawdad
266
19k
The Cult of Friendly URLs
andyhume
74
5.7k
The World Runs on Bad Software
bkeepers
PRO
61
6.7k
From Idea to $5000 a Month in 5 Months
shpigford
377
45k
Dealing with People You Can't Stand - Big Design 2015
cassininazir
358
22k
Learning to Love Humans: Emotional Interface Design
aarron
267
39k
Statistics for Hackers
jakevdp
790
220k
Visualization
eitanlees
137
14k
How to name files
jennybc
65
93k
Building Your Own Lightsaber
phodgson
100
5.7k
Rebuilding a faster, lazier Slack
samanthasiow
74
8.3k
Transcript
CMRDB 靜宜大學行雲者研發基地 DATABASE基礎教學 謝宗翰
2 Agenda ◎資料庫概論 ◎SQL簡介 Ø CRUD ◎動手做更有感覺!
3 資料庫概論
4 儲存與管理資料
5 將卡片排序
6 用電腦管理資料
7 一大堆資料,查詢困難@@
8 資料庫管理系統&資料庫伺服器
9 依照需求使用DB
10 DATABASE
11 表格TABLE
12 查詢表格資料
13 建立其他表格資料
14 要怎麼新增、查詢、修改、 刪除DATA? 使用SQL指令!
15 SQL簡介
16 SQL ◎Structured Query Language Ø 結構化查詢語言 ◎念作「sequel」 ◎與資料庫做溝通 對資料庫做CRUD
Create : 新增 Read : 讀取 Update : 更新 Delete : 刪除
17 CRUD前基本概念
18 資料庫 -> 表格tables
19 表格 -> 欄位(column)
20 表格 -> 列(row) or 紀錄(record)
21 指定一個欄位為primary key 主索引鍵(PK) 絕對不會重複
22 DATA TYPE
23 小憩一下~等等要動手做囉!
24 查詢select(Read) SELECT column FROM table WHERE condition
25 新增insert(Create) INSERT INTO column,… VALUES (val,…)
26 更新update(U) UPDATE table SET column=…[,…] WHERE condition
27 刪除delete(D) DELETE FROM table WHERE condition
28 Q&A