Thư viện tri thức trực tuyến
Kho tài liệu với 50,000+ tài liệu học thuật
© 2023 Siêu thị PDF - Kho tài liệu học thuật hàng đầu Việt Nam
Giáo trình ebook tổng hợp về SQL full
Nội dung xem thử
Mô tả chi tiết
Giaïo trçnh thæûc haình SQL
7UDQJ
*,lv,7+,j8
64/ 6WUXFWXUHG4XHU\/DQJXDJH ODQJQQJ¤FVGX£QJFKRFDFK£TXDQ
WU F V GOL£X TXDQ K£ 1JQ QJ 64/ FKX Q ¤F D UD EL $16, $PHULFDQ
1DWLRQDO 6WDQGDUGV ,QVWLWXGH YD ,62 ,QWHUQDWLRQDO 6WDQGDUGV 2UJDQL]DWLRQ YL
SKLQ EDQ PL QK¢W KL£Q QD\ OD SKLQ EDQ 64/ SKLQ EDQ ¤F D UD QP
0£FGXFRQKLXQJQQJNKDFQKDX¤FDUDFKRFDFK£TXDQWU&6'/
TXDQK£64/ODQJQQJ¤FVGX£QJU¤QJUDLKL£QQD\WURQJU¢WQKLXK£WK¢QJ
&6'/WKQJPD£LQK2UDFOH64/6HUYHU'%0LFURVRIW$FFHVV7KQJTXD64/
QJL V GX£QJFRWK G¡ GDQJ QK QJKD ¤F GOL£XWKDRWDF YL GOL£X0£W
NKDF\ODQJQQJFRWQKNKDLEDRQQQRG¡VGX£QJYDFXQJYY£\PDWUQQ
SK EL¢Q
*LDRWULQKQD\QKPFXQJF¢SFKRED£QWDLOL£XWKDPNKDRWQJ¢L\XY
FDF FX O£QK JLDR WDF 64/ V GX£QJ FKR K£ TXDQ WU &6'/ 0LFURVRIW 64/ 6HUYHU
*LDRWUQKEDRJPE¢QFKQJ
&KQJ JLLWKL£XP¤W V¢ FXO£QK V GX£QJWURQJ YL£F QK QJKD FDF ¢L
W¤QJGOL£XQKEDQJGOL£XNKXQJQKQYDFKPX£F
&KQJ WUQK ED\ E¢Q FX O£QK WKDR WDF G OL£X OD 6(/(&7 ,16(57
83'$7(YD'(/(7( WURQJRW£SWUXQJFKX\¢XFXO£QK6(/(&7
&KQJF£S¢QKDLFXO£QKLXNKL QOD*5$17YD5(92.(VGX£QJ
WURQJYL£FF¢SSKDWYDKX\ERTX\QFXDQJLVGX£QJ&6'/
&KQJ JLL WKL£X Y WKX WX£F OX WU YD WULJJHU j\ OD QKQJ ¢L W¤QJ
&6'/¤FVGX£QJQKPWQJKL£XQQJNKLVGX£QJ&6'/
7URQJFKQJSKX£OX£FFKXQJWLJLLWKL£XF¢XWUXFYDGOL£XFXDFDFEDQJV
GX£QJWURQJFDFYGX£FKQJ ED£QWL£QWUDFXYD¢LFKL¢XYLFDFYGX£DQX
1JRDLUDWURQJFKQJQD\FRQFRFDFKDPWKQJVGX£QJWURQJ64/6HUYHUFDF
ED£QWKDPNKDRWURQJWK£FKDQK
0£FGXDU¢WF¢JQJQKQJJLDRWUQKNKQJWK WUDQKX¤FFDFVDLVRW5¢W
PRQJQK£Q¤FV£JRS\FXDFDFED£Q JLDRWUQKQJD\FDQJKRDQWKL£QKQ
Tráön Nguyãn Phong
Chæång 1: NGÄN NGÆÎÂËNH NGHÉA DÆÎLIÃÛU
1JQQJQKQJKDGOL£XEDRJPFDFFXO£QKFKRSKHSQJLVGX£QJQK
QJKD&6'/YDFDF¢LW¤QJWURQJ&6'/QKFDFEDQJFDFNKXQJQKQFKPX£F
7DREDQJGOL X
'OL£XEQWURQJP¤W&6'/¤FW FKFOXWUWURQJFDFEDQJ%QWURQJFDF
EDQJGOL£X¤FW FKFGLGD£QJFDFGRQJYDFDFF¤W0¡LP¤WGRQJEL XGL¡Q
P¤WEDQJKLGX\QK¢WYDP¡LP¤WF¤WEL XGL¡QFKRP¤WWUQJ
&DFWKXFWQKOL QTXDQ QEDQJ
.KLWD£R YDODP YL£F YLFDF EDQJ GOL£XWDFQ SKDL \ ¢QFDFWKX¤FWQK
NKDFWUQEDQJQK NL XGOL£XFDF UDQJEX¤FFDFNKRDFDFTXLWF&DFWKX¤F
WQKQD\¤FVGX£QJQKPWD£RUDFDFUDQJEX¤FWRDQYH£QWUQFDFF¤W WUQJ WUQ
EDQJFXQJQKWD£RUDFDFWRDQYH£QWKDPFKL¢XJLDFDFEDQJGOL£XWURQJ&6'/
D.L XGOL X
0¡LP¤WF¤W WUQJ FXDP¤W EDQJ X SKDLWKX¤F YDRP¤W NL X GOL£X QK¢W
QKD¤FQKQJKDWWUF0¡LP¤W NL X GOL£X TXL QK FDF JLDWU GOL£X
¤FFKRSKHS¢LYLF¤WR&DFK£TXDQWU&6'/WKQJFXQJF¢SFDFNL XGOL£X
FKX QQJRDLUDFRQFRWK FKRSKHSQJLVGX£QJQKQJKDFDFNL XGOL£XNKDF
G£DWUQFDFNL XGOL£XDFR
'L\ODP¤WV¢NL XGOL£XWKQJ¤FVGX£QJWURQJJLDRWDF64/
Binary
Bit
Char
Datetime
Decimal
Float
Image
Int
Money
Nchar
Ntext
Nvarchar
Real
Smalldatetime
Smallint
Smallmoney
Text
Tinyint
Varbinary
Varchar
E&DFUDQJEXF &21675$,176
7UQFDFEDQJGOL£XFDFUDQJEX¤F¤FVGX£QJQKPFDFPX£FFKVDX
• 4XLQKFDFJLDWUGOL£XKD\NKXQGD£QJGOL£X¤FFKRSKHSFK¢SQK£QWUQ
FDFF¤WFXDEDQJ UDQJEX¤F&+(&.
• 4XLQKJLDWUP£FQKFKRFDFF¤W UDQJEX¤F'()$8/7
Giaïo trçnh thæûc haình SQL
7UDQJ
• 7D£RQQWQKWRDQYH£QWK£FWK WURQJP¤WEDQJGOL£XYDWRDQYH£QWKDPFKL¢XJLD
FDF EDQJ G OL£X WURQJ &6'/ UDQJ EX¤F 35,0$5< .(< 81,48( YD
)25(,*1.(<
&KXQJWDVHWPKL XFKLWL¢WKQYFDFUDQJEX¤FQD\SKQWUQKED\YFXO£QK
&5($7(7$%/(
7DREDQJEQJWUX\YQ64/
7D£RFDFEDQJODP¤WNKXTXDQWURQJWUR¤QJWURQJ TXDWUQKWKL¢W N¢ YDFDL G£W
FDF&6'/%QWURQJFDF&6'/P¡LP¤WEDQJWKQJ¤FVGX£QJQKPEL XGL¡Q
WKQJWKLYFDF¢LW¤QJWURQJWK¢JLLWK£FYDKR£FEL XGL¡QP¢LTXDQK£JLDFDF
¢LW¤QJRj FRWK W FKFW¢WP¤WEDQJGOL£XED£QWQK¢WFQSKDL[DFQK
¤FFDF\XFXVDX
• %DQJ¤FVGX£QJQKPPX£FFKJYDFRYDLWURQKWK¢QDREQWURQJ&6'/"
• %DQJVHEDRJPQKQJF¤WQDRYDNL XGOL£XFKRFDFF¤WRODJ"
• 1KQJF¤WQDRFKRSKHSFK¢SQK£QJLDWU18//
• &RVGX£QJFDFUDQJEX¤FFDFP£FQKKD\NKQJYDQ¢XFRWKVGX£QJXYD
QKXWK¢QDR"
• 1KQJF¤WQDRVHRQJYDLWURODNKRDFKQKNKRDQJRDLNKRDGX\QK¢W"1KQJ
GD£QJFKPX£FQDRODFQWKL¢WYDFQX
D7DREDQJGOL X
j WD£RP¤W EDQJWURQJ&6'/ ED£Q V GX£QJ FXO£QK&5($7(7$%/( FR FX
SKDSQKVDX
CREATE TABLE table_name
(
{colname_1 col_1_properties [constraints_1 ]
[,{colname_2 col_2_properties [constraints_2 ]]
...
[,{colname_N col_N_properties [constraints_N ]]
[table_constraints]
)
7URQJR
- table_name: 7Q EDQJ FQ WD£R 7Q FXD EDQJ SKDL GX\ QK¢W
WURQJP¡L&6'/YDSKDLWXQWKHRFDFTXLWFY
QKGDQK
- colname_i: 7QFXDF¤WWKLWURQJEDQJ&DFF¤WWURQJP¡L
Tráön Nguyãn Phong
EDQJSKDLFRWQNKDFQKDXYDSKDLWXQWKHRFDF
TXL WF Y QK GDQK 0¡L P¤W EDQJ SKDL FR W
QK¢WP¤WF¤W
- col_i_properties: &DFWKX¤FWQKFXDF¤WWKLTXLQKNL XGOL£X
FXD F¤W YD FK QK F¤W FR FKR SKHS FK¢S QK£Q
JLDWU18//KD\NKQJ
- constraints_i: &DF UDQJ EX¤F Q¢X FR WUQ F¤W WK L QK FDF
UDQJEX¤FYNKRDFDFP£FQKFDFTXLQKY
NKXQGD£QJGOL£X
- table_constraint: &DFUDQJEX¤FWUQEDQJGOL£X
9GX &XO£QKGL\WK£FKL£QKYL£FWD£REDQJ1+$19,(1EDRJPFDFF¤W
0$19+27(11*$<6,1+',$&+,',(17+2$,
CREATE TABLE nhanvien
(
manv char(10) not null,
hoten char(30) not null,
ngaysinh datetime null,
diachi char(50) null,
dienthoai char(6) null
)
E6GXQJFDFUDQJEXFWURQJEDQJGOL X
D5DQJEXF&+(&.
5DQJEX¤F&+(&.¤FVGX£QJ FKQKFDFJLDWUKD\NKXQGD£QJGOL£X
FR WK ¤F FK¢S QK£Q ¢L YL P¤W F¤W 7UQ P¤W F¤W FR WK FR QKLX UDQJ EX¤F
&+(&.j NKDLEDRP¤WUDQJEX¤F&+(&.¢LYLP¤WF¤WQDRRWDVGX£QJFX
SKDSQKVDX
[CONSTRAINT constraint_name]
CHECK (expression)
7URQJRH[SUHVVLRQODP¤WEL XWKFORJLF TXL QK JLDWU KD\ NKXQ GD£QJFXD G
OL£X¤FFKRSKHS.KLRFKQKQJJLDWUGOL£XQDRODPFKRH[SUHVVLRQQK£QJLD
WUXQJPL¤FFK¢SQK£Q
9GX j TXL QK L£QWKRD£LFXD QKQ YLQ SKDLFR GD£QJ
FKQJ KD£Q
FXO£QKYGX£¤FYL¢WQKVDX
CREATE TABLE nhanvien
(