Oracle從入門到精通

定　價：￥65.00

作　者：	創(chuàng)客誠品，鄭彬彬，鄭秋生
出版社：	北京希望電子出版社
叢編項：
標　簽：	暫缺

購買這本書可以去

ISBN：	9787830024932	出版時間：	2017-10-01	包裝：
開本：		頁數(shù)：		字數(shù)：

內(nèi)容簡介

　　本書內(nèi)容充實條理，結(jié)構(gòu)嚴謹，循序漸進有層次的進行講解，對Oracle進行了全方位的介紹。書中所列舉案例的選擇均突出知識點的實際應用性，并配合有“TIPS”技巧講解，讓讀者真正掌握Oracle。本書共17章，主要介紹了數(shù)據(jù)庫技術(shù)學習準備、數(shù)據(jù)庫技術(shù)學習準備、SQL語言基礎(chǔ) 、數(shù)據(jù)庫啟動和關(guān)閉等常規(guī)管理、數(shù)據(jù)庫啟動和關(guān)閉等常規(guī)管理、SQL*PLUS工具、PLSQL編程基礎(chǔ) 、游標和異常處理、存儲過程、函數(shù)、觸發(fā)器和包、Oracle 系統(tǒng)優(yōu)化、Oracle數(shù)據(jù)庫備份與恢復、數(shù)據(jù)的導入導出、數(shù)據(jù)庫安全管理、RMAN工具的應用、閃回技術(shù)、Oracle數(shù)據(jù)庫的連接、學生選課管理系統(tǒng)開發(fā)案例等，并有相關(guān)知識匯總等兩個附錄。

作者簡介

　　創(chuàng)客誠品團隊是由多位程序開發(fā)工程師、DBA、高校計算機專業(yè)導師組成。團隊核心成員有多年的教學經(jīng)驗，后加入知名科技有限公司擔任高端工程師?，F(xiàn)為程序設(shè)計類暢銷圖書作者，曾在“全國計算機圖書排行榜”同品類排行中身居前列，受到廣大工程設(shè)計人員的好評。

圖書目錄

目錄

Chapter01 數(shù)據(jù)庫技術(shù)學習準備
1.1 數(shù)據(jù)庫的基本概念............................................................. 2
1.2 數(shù)據(jù)庫系統(tǒng)結(jié)構(gòu)................................................................10
1.3 數(shù)據(jù)庫的規(guī)范化...............................................................14
1.4 數(shù)據(jù)庫設(shè)計...................................................................18
1.5 主流數(shù)據(jù)庫簡介................................................................21

Chapter02 初識Oracle數(shù)據(jù)庫
2.1 Oracle數(shù)據(jù)庫概述.............................................................. 26
2.2 Oracle的安裝準備.............................................................. 29
2.3 Oracle數(shù)據(jù)庫的安裝............................................................ 30
2.4 Oracle數(shù)據(jù)庫的卸載............................................................ 37

Chapter03 SQL語言基礎(chǔ)
3.1 SQL語言概述.................................................................... 42
3.2 表管理......................................................................... 44
3.3 視圖管理....................................................................... 60
3.4 索引管理...................................................................... 63
3.5 同義詞......................................................................... 66
3.6 序列........................................................................... 67
3.7 數(shù)據(jù)定義....................................................................... 69
3.8 數(shù)據(jù)操縱....................................................................... 70
3.9 數(shù)據(jù)控制...................................................................... 70
3.10 基本數(shù)據(jù)查詢...................................................................71
3.11 多表連接查詢................................................................... 78

Chapter04 數(shù)據(jù)庫管理
4.1 用戶模式...................................................................... 88
4.2 數(shù)據(jù)庫管理.................................................................... 89

Chapter05 Oracle數(shù)據(jù)庫體系結(jié)構(gòu)
5.1 Oracle體系結(jié)構(gòu)概述........................................................... 110
5.2 Oracle數(shù)據(jù)庫邏輯結(jié)構(gòu).......................................................... 110
5.3 Oracle數(shù)據(jù)庫物理結(jié)構(gòu)......................................................... 118
5.4 Oracle數(shù)據(jù)庫內(nèi)存結(jié)構(gòu)......................................................... 125
5.5 Oracle數(shù)據(jù)庫進程............................................................. 129

Chapter06 SQL*Plus工具
6.1 SQL*Plus概述................................................................. 134
6.2 SQL*Plus常用命令............................................................. 137
6.3 SQL*Plus格式化查詢結(jié)果命令.................................................. 149
6.4 其他緩存區(qū)編輯命令.......................................................... 157

Chapter07 PL/SQL編程基礎(chǔ)
7.1 PL/SQL概述.................................................................. 161
7.2 PL/SQL常量和變量定義......................................................... 163
7.3 條件語句.................................................................... 172
7.4 循環(huán)語句..................................................................... 175

Chapter08 游標和異常處理
8.1 游標......................................................................... 181
8.2 游標屬性..................................................................... 187
8.3 PL/SQL異常處理............................................................... 191

Chapter09 存儲過程、函數(shù)、觸發(fā)器和包
9.1 存儲過程..................................................................... 197
9.2 函數(shù)......................................................................... 206
9.3 觸發(fā)器....................................................................... 211
9.4 包........................................................................... 218

Chapter10 Oracle系統(tǒng)優(yōu)化
10.1 SQL語句調(diào)優(yōu)................................................................. 224
10.2 表連接的優(yōu)化................................................................. 233
10.3 合理使用索引................................................................. 234

Chapter11 Oracle數(shù)據(jù)庫備份與恢復
11.1 備份與恢復概述............................................................... 239
11.2 備份與恢復的分類............................................................. 240
11.3 備份和恢復的方法.............................................................. 242

Chapter12 數(shù)據(jù)的導入/導出
12.1 Data Pump概述................................................................ 253
12.2 創(chuàng)建目錄..................................................................... 254
12.3 Data Pump導出數(shù)據(jù)............................................................ 255
12.4 Data Pump導入數(shù)據(jù)............................................................ 261
12.5 EXP/IMP導出/導入數(shù)據(jù)......................................................... 265

Chapter13 數(shù)據(jù)庫安全管理
13.1 Oracle數(shù)據(jù)庫的安全性......................................................... 273
13.2 用戶......................................................................... 274
13.3 用戶權(quán)限..................................................................... 281
13.4 角色......................................................................... 285

Chapter14 RMAN工具的應用
14.1 初識RMAN..................................................................... 290
14.2 RMAN備份..................................................................... 296
14.3 RMAN恢復數(shù)據(jù)庫............................................................... 301

Chapter15 閃回技術(shù)
15.1 認識閃回技術(shù)................................................................ 309
15.2 閃回查詢技術(shù)................................................................ 311
15.3 閃回錯誤操作技術(shù)............................................................ 312

Chapter16 Oracle數(shù)據(jù)庫的連接
16.1 JDBC簡介.................................................................... 318
16.2 JDBC的工作原理.............................................................. 319
16.3 JDBC的操作.................................................................. 320
16.4 ADO.NET簡介................................................................. 323
16.5 ADO.NET中的對象............................................................. 324

Chapter17 學生選課管理系統(tǒng)開發(fā)案例
17.1 需求分析.................................................................... 338
17.2 系統(tǒng)要求.................................................................... 338
17.3 系統(tǒng)數(shù)據(jù)庫設(shè)計.............................................................. 339
17.4 系統(tǒng)設(shè)計與實................................................................ 342

附錄
附錄 A........................................................................... 353
附錄 B........................................................................... 360