实用数据库技术

出版时间：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