欧美视频一区免费观看,天天摸天天做天天爽水多,成人天堂资源www在线

蜜臀98精品国产免费观看-欧美亚洲日本高清不卡-亚洲国产精品成人久久-无码精品人妻一区二区三区中-欧美巨大黑人精品videos

獲得積分

資料庫會員登錄

搜索: [高級搜索]

下載首頁 | 資源分類 | 下載排行

您的位置: 首頁 > 信息化技術 > MSSQL

分類導航

下載排行

最新資源

菜鳥級SQL21天自學通

資源大小：1.99 MB	資源類型：文檔
下載積分： 0

-->

下載統計：總下載：0，本月下載：0，本周下載：0，今日下載：0

發表評論

錯誤報告

加入收藏夾

資源介紹

目錄
目錄.......................................................................................................................................... 1
譯者的話............................................................................................................................. 14
第一周概貌............................................................................................................................. 16
從這里開始............................................................................................................. 16
第一天SQL 簡介.................................................................................................................. 17
SQL 簡史................................................................................................................ 17
數據庫簡史............................................................................................................. 17
設計數據庫的結構................................................................................................... 21
SQL 總覽......................................................................................................... 23
流行的SQL 開發工具....................................................................................... 24
SQL 在編程中的應用........................................................................................ 27
第二天查詢— — SELECT 語句的使用................................................................................... 30
目標.................................................................................................................... 30
背景................................................................................................................. 30
一般的語法規則............................................................................................... 30
你的第一個查詢............................................................................................... 33
總結.................................................................................................................... 37
問與答................................................................................................................. 38
校練場.................................................................................................................... 38
練習.................................................................................................................... 39
第三天表達式條件語句與運算.......................................................................................... 40
第四天函數對數據的進一步處理....................................................................................... 60
目標.................................................................................................................... 60
匯總函數................................................................................................................. 60
COUNT............................................................................................................ 61
SUM ................................................................................................................ 61
AVG................................................................................................................. 63
MAX................................................................................................................ 63
MIN................................................................................................................. 64
VARIANCE...................................................................................................... 65
STDDEV.......................................................................................................... 66
SQL 21 日自學通(V1.0) 翻譯人笨豬
EMAIL wyhsillypig@163.com 2
日期/時間函數......................................................................................................... 66
ADD_MONTHS................................................................................................ 67
LAST_DAY...................................................................................................... 68
MONTHS_BETWEEN....................................................................................... 69
NEW_TIME...................................................................................................... 70
NEXT_DAY...................................................................................................... 71
SYSDATE......................................................................................................... 72
數學函數................................................................................................................. 72
ABS ................................................................................................................. 73
CEIL 和FLOOR ............................................................................................... 73
COS COSH SIN SINH TAN TANH........................................................ 73
EXP................................................................................................................. 75
LN and LOG..................................................................................................... 75
MOD................................................................................................................ 76
POWER............................................................................................................ 77
SIGN ............................................................................................................... 77
SQRT ............................................................................................................... 78
字符函數................................................................................................................. 79
CHR................................................................................................................. 79
CONCAT .......................................................................................................... 79
INITCAP.......................................................................................................... 80
LOWER 和UPPER ........................................................................................... 81
LPAD 與RPAD................................................................................................. 82
LTRIM 與RTRIM............................................................................................. 83
REPLACE ........................................................................................................ 84
SUBSTR........................................................................................................... 85
TRANSLATE.................................................................................................... 88
INSTR ............................................................................................................. 88
LENGTH.......................................................................................................... 89
轉換函數................................................................................................................. 89
TO_CHAR........................................................................................................ 90
TO_NUMBER................................................................................................... 91
其它函數................................................................................................................. 91
GREATEST 與LEAST...................................................................................... 91
USER............................................................................................................... 92
總結........................................................................................................................ 92
問與答.................................................................................................................... 93
校練場.................................................................................................................... 93
練習........................................................................................................................ 94
第五天SQL 中的子句........................................................................................................... 95
SQL 21 日自學通(V1.0) 翻譯人笨豬
EMAIL wyhsillypig@163.com 3
目標.................................................................................................................... 95
WHERE 子句.......................................................................................................... 96
STARTING WITH子句............................................................................................ 98
ORDER BY 子句..................................................................................................... 99
GROUP BY 子句....................................................................................................104
HAVING 子句.........................................................................................................109
子句的綜合應用.....................................................................................................112
總結.......................................................................................................................117
問與答...................................................................................................................117
校練場...................................................................................................................117
練習.......................................................................................................................118
第六天表的聯合..................................................................................................................119
介紹.......................................................................................................................119
在一個SELECT 語句中使用多個表.........................................................................119
正確地找到列..................................................................................................123
等值聯合................................................................................................................124
不等值聯合............................................................................................................129
外部聯合與內部聯合..............................................................................................130
表的自我聯合.........................................................................................................132
總結.......................................................................................................................134
問與答...................................................................................................................134
校練場...................................................................................................................134
練習.......................................................................................................................135
第七天子查詢內嵌的SQL 子句........................................................................................136
目標...................................................................................................................136
建立一個子查詢.....................................................................................................136
在子查詢中使用匯總函數.......................................................................................140
子查詢的嵌套.........................................................................................................141
相關子查詢............................................................................................................144
EXISTS ANY ALL 的使用.................................................................................147
SQL 21 日自學通(V1.0) 翻譯人笨豬
EMAIL wyhsillypig@163.com 4
總結.......................................................................................................................151
問與答...................................................................................................................151
校練場...................................................................................................................152
練習...................................................................................................................153
第一周回顧............................................................................................................................154
預覽.......................................................................................................................154
第二周概貌............................................................................................................................155
這一周都講些什么..................................................................................................155
第八天操作數據..................................................................................................................156
目標.......................................................................................................................156
數據操作語句.........................................................................................................156
插入語句................................................................................................................157
INSERT VALUES 語句.....................................................................................157
INSERT SELECT 語句.....................................................................................161
UPDATE語句........................................................................................................163
DELETE 語句.........................................................................................................166
從外部數據源中導入和導出數據.............................................................................169
Microsoft Access ..............................................................................................170
Microsoft and Sybase SQL Server ......................................................................171
Personal Oracle7...............................................................................................171
總結.......................................................................................................................172
問與答...................................................................................................................172
校練場...................................................................................................................173
練習.......................................................................................................................173
第九天創建和操作表...........................................................................................................174
目標...................................................................................................................174
CREATE DATABASE 語句......................................................................................174
建立數據庫時的選項.......................................................................................175
設計數據庫.....................................................................................................176
建立數據字典..................................................................................................176
建立關鍵字段..................................................................................................177
CREATE TABLE 語句.............................................................................................178
表名................................................................................................................179
SQL 21 日自學通(V1.0) 翻譯人笨豬
EMAIL wyhsillypig@163.com 5
FIRST NAME..................................................................................................179
空值屬性.........................................................................................................180
唯一屬性.........................................................................................................181
表的存儲與尺寸的調整....................................................................................183
用一個已經存在的表來建表.............................................................................184
ALTER TABLE 語句...............................................................................................185
DROP TABLE 語句.................................................................................................186
DROP DATABASE語句..........................................................................................187
總結.......................................................................................................................188
問與答...................................................................................................................188
校練場...................................................................................................................189
練習.......................................................................................................................190
第10 天創建視圖和索引.......................................................................................................191
目標.......................................................................................................................191
使用視圖................................................................................................................192
列的重命名.....................................................................................................196
SQL 對視圖的處理過程...................................................................................197
在SELECT 語句使用約束................................................................................201
在視圖中修改數據...........................................................................................201
在視圖中修改數據的幾個問題.........................................................................203
通用應用程序的視圖.......................................................................................204
刪除視圖語句..................................................................................................207
使用索引................................................................................................................207
什么是索引..................................................................................................207
使用索引的技巧..............................................................................................212
對更多的字段進行索引....................................................................................212
在創建索引時使用UNIQUE 關鍵字.................................................................214
索引與歸并.....................................................................................................216
群集簇的使用...........................................................................................217
總結.......................................................................................................................218
問與答................................................................................................................219
校練場...................................................................................................................219
練習...................................................................................................................220
第11 天事務處理控制.........................................................................................................221
目標...................................................................................................................221
事務控制................................................................................................................221
SQL 21 日自學通(V1.0) 翻譯人笨豬
EMAIL wyhsillypig@163.com 6
銀行應用程序..................................................................................................222
開始事務處理..................................................................................................223
結束事務處理..................................................................................................225
取消事務處理..................................................................................................228
在事務中使用保存點.......................................................................................231
總結.......................................................................................................................234
問與答...................................................................................................................234
校練場...................................................................................................................235
練習.......................................................................................................................235
第12 天數據庫安全............................................................................................................236
前提數據庫管理員..............................................................................................236
流行的數據庫產品與安全.......................................................................................237
如何讓一個數據庫變得安全....................................................................................237
Personal Oracle7 與安全..........................................................................................238
創建用戶.........................................................................................................238
創建角色.........................................................................................................240
用戶權限.........................................................................................................242
為安全的目的而使用視圖................................................................................247
總結.......................................................................................................................251
問與答...................................................................................................................252
校練場...................................................................................................................252
練習.......................................................................................................................253
第13 天高級 SQL.................................................................................................................254
目標...................................................................................................................254
臨時表...................................................................................................................254
Title ................................................................................................................257
游標.......................................................................................................................259
創建游標.........................................................................................................260
打開游標.........................................................................................................260
使用游標來進行翻閱.......................................................................................261
測試游標的狀態..............................................................................................262
關閉游標.........................................................................................................263
游標的適用范圍..............................................................................................264
創建和使用存貯過程..............................................................................................265
在存貯過程中使用參數....................................................................................267
SQL 21 日自學通(V1.0) 翻譯人笨豬
EMAIL wyhsillypig@163.com 7
刪除一個存貯過程...........................................................................................269
存貯過程的嵌套..............................................................................................270
設計和使用觸發機制..............................................................................................272
觸發機制與事務處理.......................................................................................273
使用觸發機制時的限制....................................................................................275
觸發機制的嵌套..............................................................................................275
在選擇語句中使用更新和刪除................................................................................275
在執行前測試選擇語句....................................................................................276
嵌入型SQL............................................................................................................277
靜態SQL 與動態SQL.....................................................................................277
使用SQL 來編程....................................................................................................279
總結.......................................................................................................................280
問與答...................................................................................................................280
校練場...................................................................................................................280
練習.......................................................................................................................281
第14 天動態使用SQL ........................................................................................................282
目標.......................................................................................................................282
快速入門................................................................................................................282
ODBC .............................................................................................................282
Personal Oracle 7..............................................................................................283
InterBase SQL ISQL ...................................................................................283
Visual C++ ......................................................................................................284
Delphi.............................................................................................................284
設置.......................................................................................................................284
創建數據庫............................................................................................................285
使用MS QUERY 來完成鏈接..................................................................................290
將VISUAL C++與SQL 結合使用...........................................................................292
將DELPHI 與SQL 結合使用..................................................................................296
總結.......................................................................................................................302
問與答...................................................................................................................303
校練場...................................................................................................................303
練習.......................................................................................................................303
第二周回顧............................................................................................................................304
第三周概貌..................................................................................................................

下載地址

下載地址1

按字母檢索

下載須知:
大部份資源無需注冊即可下載
需要積分的資源要在會員中心注冊會員并用積分體系中提示的方法賺取積分才能下載。

免責聲明：
所有資源只能用于參考學習，不能用于任何商業用途，否則后果自負！