序
Chapter 1 Introduction to Database
第1章 數(shù)據(jù)庫導論
1-1 Examples of Database 數(shù)據(jù)庫實例
1-2 The Traditional File Processing Environment 傳統(tǒng)文件處理的環(huán)境
1-3 The Integrated Datable Environment 集成數(shù)據(jù)庫環(huán)境
1-3. 1 The Database 什么是數(shù)據(jù)庫
1-3. 2 The Database Management System DBMS
1-3. 3 Components of the Database Environment 數(shù)據(jù)庫環(huán)境的主要部分
1-4 Roles in the Database Environment 在數(shù)據(jù)庫環(huán)境中的角色
1-4. 1 Data and Database Administrators 數(shù)據(jù)和數(shù)據(jù)庫管理者
1-4. 2 Database Designers 數(shù)據(jù)庫設計者
1-4. 3 Application Programmers 應用程序設計師
1-5 Data Sharing&Database 數(shù)據(jù)共享與數(shù)據(jù)庫
1-6 Internet／Intranet. Web與Database
1-7 The History of Database Systems 數(shù)據(jù)庫管理系統(tǒng)的簡史
1-8 CaseStudy 實例研究
1-9 Summary 小結
1-10 習題
Chapter 2 Database Environment
第2章 數(shù)據(jù)庫的環(huán)境
2-1 TheThree-Level ANSI-SPARC Architecture 三層結構
2-1. 1 Extemal Views 外層觀點
2-1. 2 Logical or Conceptual Model
2-1. 3 Interna lor Physical Model
2-1. 4 Schemas, Mapping, and Instances
2-1. 5 Logical&Physical Data Independence 邏輯數(shù)據(jù)獨立與物理數(shù)據(jù)獨立
2-2 Database Languages
2-2. 1 The Data Defmition Language
2-2. 2 The Data Manipulation Language
2-2. 3 4GL
2-3 Data Characteristics 數(shù)據(jù)的特性
2-4 Conceptual Modeling and Logical Data Models
2-4. 1 Conceptual Modeling
2-4. 2 Record-Based Logical Models
2-4. 3 Object-Based Logical Models 以對象為基礎的邏輯模式
2-5 Functions of a DBMS
2-6 Components of a DBMS
2-7 Multi-User DBMS Architectures 多用戶數(shù)據(jù)庫管理系統(tǒng)的結構
2-7. 1 Teleprocessing
2-7. 2 File-Server
2-7. 3 Client-Server
2-7. 4 Traditional two-tier client-server architecture
2-7. 5 Three-tier architecture 三層式結構
2-8 System Catalogs
2-9 習題
Chapter 3 Database Planning, Design, and Administration
第3章 數(shù)據(jù)庫的規(guī)劃. 設計與管理
3-1 信息系統(tǒng)生命周期的概念
3-2 The Database Application Life cycle 數(shù)據(jù)庫應用程序的生命周期
3-2. 1 Database planning
3-2. 2 System Definition 系統(tǒng)定義
3-2. 3 Requirements Collection and Analysis
3-2. 4 Database Design 數(shù)據(jù)庫設計
3-2. 5 DBMS Selection 選擇數(shù)據(jù)庫管理系統(tǒng)
3-2. 6 Application Design 設計應用程序
3-2. 7 Prototyping
3-2. 8 Implementation
3-2. 9 數(shù)據(jù)轉換和加載
3-2. 10 測試與操作維護
3-3 數(shù)據(jù)庫設計的概念
3-3. 1 Conceptual Database Design 概念層數(shù)據(jù)庫設計
3-3. 2 Logicai Database Design 邏輯數(shù)據(jù)庫設計
3-3. 3 Physical Database Design 物理數(shù)據(jù)庫設計
3-4 CASETools 計算機輔助軟件工程的工具
3-5 Data Administrator and Darabase Administrator 數(shù)據(jù)管理員與數(shù)據(jù)庫管理員
3-6 DBMS Selection
3-7 習題
Chapter 4 The Relational Model
第4章 關系數(shù)據(jù)模型
4-1 Relational Model的簡史
4-2 Terminology 術語
4-2. 1 Relational Data Structare
4-2. 2 Mathematical Relations
4-2. 3 Database Relations
4-2. 4 Propenies of Relations
4-2. 5 Relation Keys
4-2. 6 Representing Relational Database Schemes 關系數(shù)據(jù)庫結構的表示
4-3 Relational Data Manipulation Languages 關系型數(shù)據(jù)維護語言
4-4 Relational Integrity Constraints 完整性限制
4-4. 1 Nulls
4-4. 2 Entity Integrity
4-4. 3 Referential Integrity
4-4. 4 Enterprise Constraints
4-5 Views
4-6 Relational DBMS with Object-Like Extensions 在RDBMS內支持Objects
4-7 Normalization
4-7. 1 What is normalization
4-7. 2 Data Redundancy and Update Anomalies
4-7. 3 Furictional Dependency
4-7. 4 Unnormalized Relations
4-7. 5 Normalized Relatioas:First Normal Form 1NF
4-7. 6 Secoad Nornlal Form 2NF
4-7. 7 Third Normal Form 3NF
4-7. 8 Boyce-Codd Normal Form BCNF
4-7. 9 Review of Normalization 1NF to BCNF
4-7. 10 Fourth Normal Form 4NF
4-7. 11 Other Normal Form 其他的正規(guī)格式
4-8 Summary 小結
4-9 習題
Chapter 5 Creating and Implementing Database
第5章 建立并操作數(shù)據(jù)庫
5-1 Introduction to SQL
5-2 Language Components
5-3 Database in SQL Server
5-4 Creating a Database
5-5 Gathering Database Information 取得數(shù)據(jù)庫的信息
5-6 Setting Database Options 數(shù)據(jù)庫選項設置
5-7 Resizing Your Database 復位數(shù)據(jù)庫的大小
5-8 Renaming a Database 數(shù)據(jù)庫重命名
5-9 Working with Database Filegroups
5-10 Removing a Database 刪除數(shù)據(jù)庫
5-11 Summary 小結
5-12 習題
Chapter6 SQL Server Login與安全性
第6章 SQL Server Login與安全性
6-1 SQL Server Security Access Model 安全性存取模式
6-1. 1 Windows NT Authentication
6-1. 2 SQL Server Login Authentication SQL Server登錄認證
6-1. 3 SQL Server Database Username
6-1. 4 Permissions 許可權
6-2 SQLServer的安全性模式
6-2. 1 Mixed Mode Security 混合型模式安全性
6-2. 2 Windows NT Integrated Mode
6-2. 3 Setting the Security Mode 設置安全模式
6-2. 4 圖形化管理的Logins
6-3 Database Users 數(shù)據(jù)庫用戶
6-3. 1 新增用戶到Database
6-3. 2 TheGuest Usemame
6-3. 3 變更Database Owner
6-4 Roles 角色
6-4. 1 The Public Role
6-4. 2 Server-Wide Roles
6-4. 3 Assigning a login to a Server Role
6-4. 4 Database Roles
6-5 Application Role 應用程序角色
6-6 Summary 小結
6-7 習題
Chapter7 Working with Permission
第7章 存取權限
7-1 為什么使用Permissions
7-2 Implementing Database Permissions
7-2. 1 Types of Permissions 存取權的類型
7-2. 2 Permissions Precedence 存取權的優(yōu)先級
7-3 SQL Server的特殊存取權
7-3. 1 Fixed Server Role Permissions 固定式服務器角色存取權
7-3. 2 Fixed Database Roles 固定式數(shù)據(jù)庫角色
7-3. 3 The Database Owner DBO, 數(shù)據(jù)庫用戶
7-3. 4 Database Object Owner DBOO Permissions 數(shù)據(jù)庫對象用戶存取權限
7-3. 5 User Permissions 用戶存取權限
7-3. 6 The Public Role
7-4 Statement Permissions 語句存取權限
7-5 Object Permissions 對象存取權限
7-6 Permissions on Views and Stored Procedures
7-6. 1 Permissions on Views
7-6. 2 Permissions on Stored Procedures
7-7 Ownership Chains
7-8 制定存取權限的策略
Chapter 8 Creating and Implementing Tables
第8章 建立并操作數(shù)據(jù)表格
8-1 Tables
8-2 Columns
8-3 SQL Server Idemifiers
8-4 Data Types
8-5 Compmed columns
8-6 Create Tables
8-6. 1 Create Table
8-6. 2 Select Into Statement
8-7 建立臨時性Table
8-8 Dropping Tables
8-9 Modifyiag Tables
Chapter 9 Data Manipulation I：Retrieval Operations
第9章 數(shù)據(jù)操作處理 一 ：讀取運算
9-1 Entering&using Interactive SQL ISQL 進入及使用交互式結構化查詢語言
9-2 Using the Sample Database 使用范例數(shù)據(jù)庫
9-3 The SELECT Statement
9-3. 1 SELECT Slause
9-3. 2 Specifying Tables：the FROM Clause 指定表格：FROM子句
9-3. 3 Selecting Rows：the WHERE Clause 選擇行：WHERE子句
9-4 Manipulating Data
9-5 System Functions
9-6 Data Conversion
9-7 Summarizing Query Resultsusing Aggregate Functions 使用總和函數(shù)來總結查詢結果
9-8 Organizing Query Resultsinto Groups：The Groupbyclause 將查詢結果組成組：groupby子句
9-8. 1 Groupby與Where Clause
9-8. 2 Selecting Groups of Data：the Having Clause 選擇數(shù)據(jù)組：Having子句
9-8. 3 Sorting Query Results：the Order Byclause 排序查詢結果：Order By子句
9-8. 4 Summarizing Groups of Data：the Compme By Clause 總結數(shù)據(jù)組：Compme By子句
9-8. 5 Grandvalue：Compme Without By 全部的總值：沒有By的compute
9-8. 6 Combining Queries：the Union Operator 組合查詢：Union運算符
9-8. 7 Super Aggregates ROLLUP and CUBE
9-9 Advanced Queries：retrieving data from multiple tables 高級查詢：從幾個tables中讀取數(shù)據(jù)
9-9. 1 Relational model&Joins
9-9. 2 Which Tables to be Joined 哪些tables要被連接
9-9. 3 Equijioins and Natural Joins 相等連接與自然連接
9-9. 4 Join Query with Additional Conditions 附帶條件的連接
9-9. 5 Joins not based on Equality 不基于相等條件的連接
9-9. 6 Self-Joins and Aliases 自身連接與別名
9-9. 7 Not-Equal Join 不相等連接
9-9. 8 Joining More than Two Tables 連接兩個以上的tableS
9-9. 9 Outer Joins
9-9. 10 Subqueries：Using Queries with in Other Queries 子查詢, 在其他查詢內使用查詢
9-9. 11 Subqueries used with [not]in
9-9. 12 Subqueries Used with Comparison Operator 使用比較運算符的子查詢語句
9-9. 13 Using Correlated Subqueries 使用相互關系子查詢
9-9. 14 Subqueries Used with exists 使用EXISTS的子查詢
9-10 習題
Chapter 10 Data Manipulation II：Data Modification
第10章 數(shù)據(jù)操作處理 二 ：數(shù)據(jù)的修改
10-1 The Choices of Modify Data 修改數(shù)據(jù)的選擇性
10-2 Transaction Logging
10-3 Inserting
10-3. 1 Using the INSERT VALUES Statement
10-3. 2 Default Values
10-3. 3 Inserting Data Using SELECT
10-3. 4 Inserting Data Using Stored Procedures
10-4 Deleting
10-4. 1 Delete Using a Lookup Table
10-4. 2 TRUNCATE TABLE：Deleting All Rows Froma Table 刪除table中所有的行：TRUNCATE語句
10-5 Updating 更新已存在的數(shù)據(jù)：UPDATE指令
10-6 Reading and Writing Text and Image：READTEXT&WRITETEXT 讀與寫Text和Image數(shù)據(jù)
10-7 習題
Chapter 11 Control Flow Statements
第11章 流程控制語句
11-1 Using Batches 使用批處理
11-2 Local and Global Variable 局部與整體變量
11-3 Control-of-flow statements 流程控制語句
11-4 Summary 小結
Chapter 12 Enhancing Performance with Indexing
第12章 使用索引來強化查詢效率
12-1 Why Use Indexes
12-1. 1 Index Structures 索引結構
12-1. 2 Index Options
12-2 SQL Server Indexes
12-3 Index Usage
12-4 Index Maintenance
12-5 SQL Server Enterprise Manager
12-6 Index Selection 索引的選擇
12-7 Full-Text Indexing 全文索引
12-8 習題
Chapter 13 Working with Views
第13章 視圖
13-1 Views
13-2 Creating Views in Transact-SQL
13-2. 1 TheCREATE VIEW Clause
13-2. 2 The SELECT Statement
13-2. 3 Types of Views
13-3 Altering View
13-4 Dropping View 刪除視圖
13-5 Creating Views Using the Entelprise Manager
13-6 Retrieving Datathrough Views 通過視圖存取數(shù)據(jù)
13-7 Data Modification through Views
13-8 Information on View 關于Views的信息
13-9 Benefits of Views
13-10 Q&A
13-11 習題
Chapter 14 Stored Procedures
第14章 預儲程序
14-1 What is Stored Procedure 什么是預儲程序
14-2 Creating Stored Procedures
14-3 Gathering Information on Stored Procedures 關于程序的信息
14-4 Stored Procedure的變更和刪除
14-5 Creatinga Group of Procedures
14-6 Using the WITH RECOMPILE Option
14-6. 1 WITH RECOMPILE Used in the CREATE PROCEDURE Statement
14-6. 2 WITH RECOMPILE Used in the EXEC PROCEDURE Statement
14-7 Using the WITH ENCRYPTION Option
14-8 Stored Procedures Talk Back：Return Status and Parameters
14-9 Using Remote Stored Procedures
14-10 Qualifying Names Inside Stored Procedures 預儲程序內的限定識別名
14-11 Renaming Procedures 重新命名程序
14-12 Dropping Procedure 刪除程序
14-13 自動重新編譯
14-14 Benefits of Stored Procedure 預儲程序的優(yōu)點
14-15 System procedlire
14-16 Summary 小結
14-17 習題
Chapter 15 Cursor
第15章 Cursor
15-1 What is Cursor
15-2 CUent Cursor與Server Cursor之間的不同
15-3 How SQL Server Processes Cursors SQL Server如何處理cursors
15-4 Some Examples of Using a Cursor 使用cursor的實例
Chapter 16 Integrity
第16章 完整性
16-1 How to Enforce Data Integrity 如何強化數(shù)據(jù)完整性
16-2 Types of Integrity
16-3 Primary Keys
16-4 Foreigl Keys
16-5 Kinds of integrity 完整性的種類
16-6 Application Versus DBMS-Enforced Integrity 應用程序或數(shù)據(jù)庫管理系統(tǒng)強化完整性
16-7 Traditional Methods of Integrity 傳統(tǒng)方法的完整性
16-7. 1 Nulls
16-7. 2 Uset-defined Data Types
16-7. 3 Defaults 默認值
16-7. 4 Rules 規(guī)則
16-8 ANSI Constraints和Declarative Integrity Mechanisms
16-9 SQL Server Enterprise Manager
16-10 Q&A
16-11 Quiz
Chapter 17 Trigger
第17章 觸發(fā)程序
17-1 Multiple Column Integrity 多重字段的完整性
17-2 What is Triggers
17-3 Create Triggers
17-4 Droptrigger 刪除觸發(fā)程序
17-5 Enforcing Data Integrity 強制數(shù)據(jù)完整性
17-6 Encapsulating Business Rules 封裝商業(yè)規(guī)則
17-7 Enforcing Referential Integrity
17-8 How Triggers Work 觸發(fā)程序如何運行
17-9 Examples of Triggers 觸發(fā)程序的范例
17-10 Nested Trigger
17-11 使用e-mail的triggers
17-12 Information on Triggers 關于triggers的信息
17-13 Q&A
17-14 Quiz
17-15 習題
附錄A The Tables of Sample Database Pubs
附錄B 習題參考答案