实用数据库技术

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