Giới thiệu ngôn ngữ SQL
- Pages
- 46
- Format
- Size
- 388 KB
- Language
- VI · Tiếng Việt
- Views
- 1,204
- Comments
- 0
- Lượt tải
- 0
Generating preview...
- Document name
- Giới thiệu ngôn ngữ SQL
- Table of contents
- This document has no clear table of contents.
- Pages
- 46 pages
- Uploaded by
- ThiNganHang
A detailed summary is being generated. Please check back in a few minutes.
Description
Trích nội dung tài liệu
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£LQK2UDFOH 64/6HUYHU '% 0LFURVRIW$FFHVV 7KQJTXD64/ QJL V GX£QJFRWK G¡ GDQJ QK QJKD ¤F GOL£X WKDRWDF YL GOL£X 0£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£X NKXQJQKQYDFKPX£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 &KQJ F£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£F FKXQJWLJLLWKL£XF¢XWUXFYDGOL£XFXDFDFEDQJV GX£QJWURQJFDFYGX£FKQJ ED£QWL£QWUDFXYD¢LFKL¢XYLFDFYGX£DQX 1JRDLUDWURQJFKQJQD\FRQFRFDFKDPWKQJVGX£QJWURQJ64/6HUYHUFDF ED£QWKDPNKDRWURQJWK£FKDQK 0£FGXDU¢WF¢JQJQKQJJLDRWUQKNKQJWK WUDQKX¤FFDFVDLVRW 5¢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'/QKFDFEDQJ FDFNKXQJQKQ FKPX£F 7DREDQJGOL X 'OL£XEQWURQJP¤W&6'/¤FW FKFOXWUWURQJFDFEDQJ %QWURQJFDF EDQJ GOL£X¤FW FKFGLGD£QJFDFGRQJYDFDFF¤W 0¡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£X WDFQ SKDL \ ¢QFDFWKX¤FWQK NKDFWUQEDQJQK NL XGOL£X FDF UDQJEX¤F FDFNKRD FDFTXLWF &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¤FQKQJKDWWUF 0¡LP¤W NL X GOL£X TXL QK FDF JLDWU GOL£X ¤FFKRSKHS¢LYLF¤WR &DFK£TXDQWU&6'/WKQJFXQJF¢SFDFNL XGOL£X FKX Q QJRDLUDFRQFRWK 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£X FDFUDQJEX¤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£FYD KR£FEL XGL¡QP¢LTXDQK£JLDFDF ¢LW¤QJR j FRWK W FKFW¢WP¤WEDQJGOL£X ED£QWQK¢WFQSKDL[DFQK ¤FFDF\XFXVDX • %DQJ¤FVGX£QJQKPPX£FFKJYDFRYDLWURQKWK¢QDREQWURQJ&6'/" • %DQJVHEDRJPQKQJF¤WQDRYDNL XGOL£XFKRFDFF
Frequently asked questions
Is this document free?
Yes. “Giới thiệu ngôn ngữ SQL” is free — just sign in and click Download to get the original file.
How many pages is this document?
The document has 46 pages. You can preview it online before downloading.
Can I preview before downloading?
Yes. You can preview this document right on this page with the online reader, then decide whether to download.
Giới thiệu ngôn ngữ SQL
Generating preview...
Trích nội dung tài liệu
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£LQK2UDFOH 64/6HUYHU '% 0LFURVRIW$FFHVV 7KQJTXD64/ QJL V GX£QJFRWK G¡ GDQJ QK QJKD ¤F GOL£X WKDRWDF YL GOL£X 0£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£X NKXQJQKQYDFKPX£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 &KQJ F£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£F FKXQJWLJLLWKL£XF¢XWUXFYDGOL£XFXDFDFEDQJV GX£QJWURQJFDFYGX£FKQJ ED£QWL£QWUDFXYD¢LFKL¢XYLFDFYGX£DQX 1JRDLUDWURQJFKQJQD\FRQFRFDFKDPWKQJVGX£QJWURQJ64/6HUYHUFDF ED£QWKDPNKDRWURQJWK£FKDQK 0£FGXDU¢WF¢JQJQKQJJLDRWUQKNKQJWK WUDQKX¤FFDFVDLVRW 5¢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'/QKFDFEDQJ FDFNKXQJQKQ FKPX£F 7DREDQJGOL X 'OL£XEQWURQJP¤W&6'/¤FW FKFOXWUWURQJFDFEDQJ %QWURQJFDF EDQJ GOL£X¤FW FKFGLGD£QJFDFGRQJYDFDFF¤W 0¡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£X WDFQ SKDL \ ¢QFDFWKX¤FWQK NKDFWUQEDQJQK NL XGOL£X FDF UDQJEX¤F FDFNKRD FDFTXLWF &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¤FQKQJKDWWUF 0¡LP¤W NL X GOL£X TXL QK FDF JLDWU GOL£X ¤FFKRSKHS¢LYLF¤WR &DFK£TXDQWU&6'/WKQJFXQJF¢SFDFNL XGOL£X FKX Q QJRDLUDFRQFRWK 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£X FDFUDQJEX¤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£FYD KR£FEL XGL¡QP¢LTXDQK£JLDFDF ¢LW¤QJR j FRWK W FKFW¢WP¤WEDQJGOL£X ED£QWQK¢WFQSKDL[DFQK ¤FFDF\XFXVDX • %DQJ¤FVGX£QJQKPPX£FFKJYDFRYDLWURQKWK¢QDREQWURQJ&6'/" • %DQJVHEDRJPQKQJF¤WQDRYDNL XGOL£XFKRFDFF
- Document name
- Giới thiệu ngôn ngữ SQL
- Table of contents
- This document has no clear table of contents.
- Pages
- 46 pages
- Uploaded by
- ThiNganHang
A detailed summary is being generated. Please check back in a few minutes.
Comments (0)
No comments yet. Be the first!
Ngân hàng đề thi môn: Hệ thống thông tin quản lý
Đề thi môn Cơ sở dữ liệu (kèm Đáp án) - Đại học Sư phạm kỹ thuật
Đề thi và đáp án môn Hệ thống thông tin kế toán
Đề thi và đáp án môn Cấu trúc dữ liệu giải thuật
Đáp án đề thi môn Mạng máy tính - ĐH Công nghệ thông tin (CNTT)
Tiểu luận - Kinh tế phát triển - Phân tích nhận định "Việt Nam đã kiên định chọn hướng phát triển lấy con người làm trọng tâm ..."
Đề cương - Luật vận tải
600 Câu trắc nghiệm Tư tưởng Hồ Chí Minh
Tài liệu ôn tập Nguyên lý kế toán
Bài tập Xác suất thống kê đại học - có lời giải
Comments (0)
No comments yet. Be the first!