实用数据库技术

Introduction to SQL Server 2005

Unit What Makes Up a SQL Server Database?

1.1 An Overview of Database Obiects

1.2 The Database Object

1.3 SOL Server Identifie for Objects

Summary

Exercises

Unit 2 How to Use Tools of SQL Server

2.1 Creating a Database in Microsoft SQL Server2005

2.2 The Query Editor

2.3 Entering a SQL Query or Statement

2.4 The Scripts of SQL Server2005 load.sql

Review Questio

Exercises

Uint 3 The Foundation Statements of T-SQL

3.1 Getting Started with a Basic SELECTStatement

3.2 Adding Data with the INSERT Statement

3.3 Changing What You've Got with the UPDATEStatement

3.4 The DELETE Statement

Summary

Review Questio

Exercise

Unit 4 Joi

4.1 INNER JOIN

4.2 The OUTER JOIN

4.3 CROSS JOINs

Summary

Review Questio

Exercises

Unit 5 Subquery

5.1 What Is a Subquery?

5.2 Introducing Set Operatio

Summary

Review Questio

Exereises

Unit 6 Creating and Altering Tables

6.1 Object Names in SQL Server

6.2 CREATE DATABASE

6.3 Data Types in SQL Server 2005

6.4 Creating a Table

6.5 The ALTER TABLE Command

Summary

Review Questio

Exereises

Unit 7 Functio

7.1 Aggregate Functio

7.2 Row-Level Functio

7.3 Other Functio

Summary

Review Questio

Exercises

Unit 8 Indexes and Co traints on Tables

8.1 Indexes

8.2 How Data Is Accessed in SQL Server I

8.3 CREATE INDEX

8.4 Co traints

Summary

Review Questio

Exercises

Unit 9 Views

9.1 Creating views

9.2 Using views

Summary

Review Questio

Exercises

Unit 10 Programming Basics and Stored Procedures

10.1 Declaring Variables

10.2 Control-of Flow Statements

10.3 Stored Procedures

Summary

Exercises

Unit 11 Trigge

11.1 What Is a Trigger?

11.2 Using Trigge

11.3 Dropping Trigge

Summary

Exercises

Unit 12 User Defined Functio

12.1 What a UDF Is

12.2 Using UDF

Summary

Unit 13 Tra actio

13.1 What is a Tra action?

13.2 Tra actio

Summary

Exercises

References