【資料名稱】：SQL21自學(xué)通

【資料作者】：王永宏

【資料日期】：2010-5

【資料語言】：中文

【資料格式】：PDF

【資料目錄和簡介】：

SQL學(xué)習(xí)資料
目錄......................................................................................................................................... 1
譯者的話............................................................................................................................. 14
第一周概貌............................................................................................................................. 16
從這里開始............................................................................................................. 16
第一天SQL 簡介.................................................................................................................. 17
SQL 簡史................................................................................................................ 17
數(shù)據(jù)庫簡史............................................................................................................. 17
設(shè)計數(shù)據(jù)庫的結(jié)構(gòu)................................................................................................... 21
SQL 總覽......................................................................................................... 23
流行的SQL 開發(fā)工具....................................................................................... 24
SQL 在編程中的應(yīng)用........................................................................................ 27
第二天查詢— — SELECT 語句的使用................................................................................... 30
目標.................................................................................................................... 30
背景................................................................................................................. 30
一般的語法規(guī)則............................................................................................... 30
你的第一個查詢............................................................................................... 33
總結(jié).................................................................................................................... 37
問與答................................................................................................................. 38
校練場.................................................................................................................... 38
練習(xí).................................................................................................................... 39
第三天表達式條件語句與運算.......................................................................................... 40
第四天函數(shù)對數(shù)據(jù)的進一步處理....................................................................................... 60
目標.................................................................................................................... 60
匯總函數(shù)................................................................................................................. 60
COUNT............................................................................................................ 61
SUM ................................................................................................................ 61
AVG................................................................................................................. 63
MAX................................................................................................................ 63
MIN................................................................................................................. 64
VARIANCE...................................................................................................... 65
STDDEV.......................................................................................................... 66
SQL 21 日自學(xué)通(V1.0) 翻譯人笨豬
EMAIL wyhsillypig@163.com 2
日期/時間函數(shù)......................................................................................................... 66
ADD_MONTHS................................................................................................ 67
LAST_DAY...................................................................................................... 68
MONTHS_BETWEEN....................................................................................... 69
NEW_TIME...................................................................................................... 70
NEXT_DAY...................................................................................................... 71
SYSDATE......................................................................................................... 72
數(shù)學(xué)函數(shù)................................................................................................................. 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
字符函數(shù)................................................................................................................. 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
轉(zhuǎn)換函數(shù)................................................................................................................. 89
TO_CHAR........................................................................................................ 90
TO_NUMBER................................................................................................... 91
其它函數(shù)................................................................................................................. 91
GREATEST 與LEAST...................................................................................... 91
USER............................................................................................................... 92
總結(jié)........................................................................................................................ 92
問與答.................................................................................................................... 93
校練場.................................................................................................................... 93
練習(xí)........................................................................................................................ 94
第五天SQL 中的子句........................................................................................................... 95