实用数据库技术

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

Introduction to SQL Server

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

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

Summary

Review Questions

Exercise

Unit 4 Joins

4.1 INNER JOIN

4.2 The OUTER JOIN

4.3 CROSS JOINs

Summary

Review Questions

Exercises

Unit 5 Subquery

5.1 What Is a Subquery？

5.2 Introducing Set Operations

Summary

Review Questions

Exercises

Unit 6 Creating and Altering Tables

6.1 Object Names in SQL Server

6.2 CREATE DATABASE

6.3 Data Types in SQL Server

6.4 Creating a Table

6.5 The ALTER TABLE Command

Summary

Review Questions

Exercises

Unit 7 Functions

Unit 8 Indexes and Constraints on Tables

Unit 9 Views

Unit 10 Programming Basics and Stored Procedures

Unit 11 Triggers

Unit 12 User Defined Functions

Unit 13 Transactions

Summary

Exercises

References

《临沂大学优秀校本教材：实用数据库技术》内容的组织以关系数据库理论知识为基础，注重操作技能的培养和实际问题的解决，旨在使学生掌握Microsoft SQL Server 2008的使用和管理。

王振海主编的《实用数据库技术(临沂大学优秀校本教材)》既重视对国内外该课程领域经典的基本理论问题进行透彻的解析，又对当前教育所面临的新现象、新理论、新方法给予必要的回应；既考虑如何有利于教师的课堂教学与辅导，又兼顾如何有助于学生的课后复习和思考；既能反映我校特色和课程体系改革的基本方向，又要展示我校教材建设及学术研究的**成果，适应我校创建精品课程、优质课程和品牌课程的实际需要。