实用数据库技术PDF电子书下载

君子务本，本立而道生——《临沂大学优秀校本教材》总序 韩延明 1

Introduction to SQL Server 2005 1

Unit 1 What Makes Up a SQL Server Database？ 1

1.1 An Overview of Database Objects 1

1.2 The Database Object 2

1.3 SQL Server Identifiers for Objects 10

Summary 11

Exercises 11

Unit 2 How to Use Tools of SQL Server 12

2.1 Creating a Database in Microsoft SQL Server 2005 13

2.2 The Query Editor 17

2.3 Entering a SQL Query or Statement 24

2.4 The Scripts of SQL Server2005_load.sql 27

Review Questions 43

Exercises 43

Uint 3 The Foundation Statements of T-SQL 44

3.1 Getting Started with a Basic SELECT Statement 45

3.2 Adding Data with the INSERT Statement 52

3.3 Changing What You've Got with the UPDATE Statement 53

3.4 The DELETE Statement 54

Summary 54

Review Questions 55

Exercise 56

Unit 4 Joins 58

4.1 INNER JOIN 58

4.2 The OUTER JOIN 62

4.3 CROSS JOINs 63

Summary 63

Review Questions 63

Exercises 64

Unit 5 Subquery 67

5.1 What Is a Subquery？ 67

5.2 Introducing Set Operations 71

Summary 73

Review Questions 73

Exercises 74

Unit 6 Creating and Altering Tables 81

6.1 Object Names in SQL Server 81

6.2 CREATE DATABASE 82

6.3 Data Types in SQL Server 2005 86

6.4 Creating a Table 88

6.5 The ALTER TABLE Command 89

Summary 90

Review Questions 90

Exercises 91

Unit 7 Functions 93

7.1 Aggregate Functions 94

7.2 Row-Level Functions 95

7.3 Other Functions 96

Summary 104

Review Questions 105

Exercises 106

Unit 8 Indexes and Constraints on Tables 110

8.1 Indexes 110

8.2 How Data Is Accessed in SQL Server 110

8.3 CREATE INDEX 111

8.4 Constraints 112

Summary 118

Review Questions 118

Exercises 119

Unit 9 Views 122

9.1 Creating views 123

9.2 Using views 123

Summary 124

Review Questions 125

Exercises 125

Unit 10 Programming Basics and Stored Procedures 127

10.1 Declaring Variables 128

10.2 Control-of-Flow Statements 128

10.3 Stored Procedures 132

Summary 137

Exercises 137

Unit 11 Triggers 139

11.1 What Is a Trigger？ 139

11.2 Using Triggers 140

11.3 Dropping Triggers 150

Summary 150

Exercises 150

Unit 12 User Defined Functions 151

12.1 What a UDF Is 151

12.2 Using UDF 152

Summary 154

Unit 13 Transactions 156

13.1 What is a Transaction？ 156

13.2 Transactions 156

Summary 158

Exercises 159

References 160