图书信息

作者简介

内容简介

目录

图书信息

出版社: 世界图书出版公司; 第1版 (2007年6月1日)

平装: 306页

开本: 16开

ISBN: 9787506283212

条形码: 9787506283212

尺寸: 22.6 x 18.8 x 2 cm

重量: 499 g

作者简介

作者：(美)美国扎实学习质量研究所

内容简介

本书为英文版。

The book readers can easily self-SQL Server 2005 based technology, from database design, build, to test configuration, each one of the steps the reader with practical guidance and help. Through the book, readers can fully experience learning-by-doing the fun the successful creation of a truly personal first SQL Server 2005 database.

目录

Introduction

Acknowledgments

Part I Introduction to Database Development with Microsoft SQL Server 2005

1 Introducing Database Development with Microsoft SQL Server 2005

The Process of Storing and Managing Data

Intronducing Database Systems

Understanding the Requirements of a Database System

Defining the Architecture of a Database Application

Using a Monolithic Application with Data Embedded in the Application Code

Using a Monolithic Application with Data Stored in an External File

Using a Database Application with Data Managed by a Batabase Server

Using an Application with a Generic Data Access Layer

Using an Application with Separated Presentation,Business,and Data Access Layers

Using a Complex Application with Multiple Options for each Layer Conclusion

2 Installing and Setting Up Your Microsoft SQL Server 2005 Development Environment

Using a Virtual PC

Operating System Rquirements for Development of SQL Server Database Applications

Recommended Productivity Tools

Using Performance Monitor

Using Network Monitor

Using Upgrade Advisor

Recommended Development Tools

Microsoft SQL Server 2005 Editions

Microsoft SQL Server express Edition

Microsoft SQL Server Workgroup Edition

Microsoft SQL Server Standard Edition

Microsoft SQL Server Enterprise Edition

Installing SQL Server 2005

Using the Surface Area Configuration Tool

Conclusion

Chapter2 Quick Reference

3 Reviewing Microsoft SQL Server 2005 Management Tools

Part II How to Create a Microsoft SQL Server 2005 Database

4 Gathering and Understanding Business Requirements before Creating Database Objects

5 Designing a Database to Solve Business Needs

Part III How to Query Data from Microsoft SQL Server 2005

6 Reading Microsoft SQL Server 2005 Data from Client Applications

7 Selecting the Data You Need

8 Creating Views to Encapsulate Queries

9 Retrieving Data Using Programmable Objects

Part IV How to Modify Data in Microsoft SQL Server 2005

10 Inserting Data in Microsoft SQL Server 2005

11 Deleting Data from Microsoft SQL Server 2005

12 Updating Data from Microsoft SQL Server 2005

Index