【文件属性】:
文件名称:sql自学21日通 Oracle7
文件大小:2.53MB
文件格式:PDF
更新时间:2013-09-20 04:08:24
SQL 基础
目录
目录......................................................................................................................................... 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
网友评论
- 很不错的资源!好用!