snowyvalley.bokee.com
5.2 等值联接..................................................................................................................30
5.3 不等值联接..............................................................................................................32
5.4 inner join 内联接 ......................................................................................................32
5.5 left join 左连接 .........................................................................................................33
5.6 right join 右连接......................................................................................................34
5.7 使用集合 union ,union all........................................................................................34
第六讲 子查询.......................................................................................................................36
6.1 建立子查询...............................................................................................................36
6.2 在子查询中使用汇总函数.......................................................................................37
6.3 子查询的嵌套...........................................................................................................38
6.4Exists any(some) all 的使用 ......................................................................................38
第七讲 插入,更新,和删除数据.............................................................................................39
7.1 insert 语句................................................................................................................39
7.2 update 语句...............................................................................................................41
7.3 delete 语句 ................................................................................................................42
7.4 课后练习:(第五-七讲)..............................................................................................42
第八讲 表的建立,修改,和删除操作.....................................................................................43
8.1 建立表 create table .................................................................................................43
8.2 拷贝表结构和数据建立新表 create table as .........................................................44
8.3 修改表的结构 alter table........................................................................................44
第九讲 视图和索引的管理...................................................................................................46
9.1 视图概述..................................................................................................................46
9.2 创建视图..................................................................................................................46
9.3 修改视图中的数据..................................................................................................48
9.4 删除视图..................................................................................................................49
9.5 使用 Toad 管理视图................................................................................................50
9.6 索引概述..................................................................................................................51
9.7 索引的分类..............................................................................................................51
9.8 建立索引 create index ............................................................................................52
9.9 删除索引 drop index...............................................................................................52
9.10 利用 Toad 管理索引..............................................................................................52
第十讲 临时表,游标和序列介绍..........................................................................................54
10.1 临时表概述............................................................................................................54
10.2 建立临时表 create table #表名.............................................................................54
10.3 删除临时表 drop table 表名................................................................................55
10.4 游标概述和简单操作.............................................................................................55
10.5 序列概述和简单操作............................................................................................55
10.6 事务简介................................................................................................................58
10.7 锁简介....................................................................................................................58
10.8 锁的分类................................................................................................................58
10.9 死锁........................................................................................................................59
第十一讲 数据的完整性.......................................................................................................60
11.1 数据的完整性概述................................................................................................60
11.2 规则介绍................................................................................................................60
既然选择了远方,便只顾风雨兼程!
4
