实用数据库技术
2012-8
山东人民出版社
王振海 编
160
220000
《临沂大学优秀校本教材：实用数据库技术》内容的组织以关系数据库理论知识为基础，注重操作技能的培养和实际问题的解决，旨在使学生掌握Microsoft SQL Server 2008的使用和管理。
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 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 Questio
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 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
