Application of database technology

君子务本，本立而道生——《临沂大学优秀校本教材》总序 韩延明
Introduction to SQL Server 2005
Unit 1 What Makes Up a SQL Server Database?
1.1 An Overview of Database Obiects
1.2 The Database Object
1.3 SQL Server Identifiers for Objects
Summary
Exercises
Unit 2 How to Use Tools of SQL Server
2.1 Creating a Database in Microsoft SQL Server 2005
2.2 The Query Editor
2.3 Entering a SQL Query or Statement
2.4 The Scripts of SQL Server2005_load. sql
Review Questions
Exercises
Uint 3 The Foundation Statements of T-SQL
3.1 Getting Started with a Basic SELECT Statement
3.2 Adding Data with the INSERT Statement
3.3 Changing What You've Got with the UPDATE Statement
3.4 The DELETE Statement /54
Summary /54
Review Questions /55
Exercise /56
Unit 4 Joins
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
5.1 What Is a Subquery? /67
5.2 Introducing Set Operations
Summary /73
Review Questions /73
Exercises /74
Unit 6 Creating and Altering Tables
6.1 Object Names in SQL Server
6.2 CREATE DATABASE /82
6.3 Data Types in SQL Server 2005
6.4 Creating a Table /88
6.5 The ALTER TABLE Command
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 WhataUDFIs /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