Microsoft SQL SERVER 2005数据库基础:由入门到精通(英文版)

Microsoft SQL SERVER 2005数据库基础:由入门到精通(英文版)
作 者: 美国扎实学习质量研究所
出版社: 世界图书出版公司
丛编项:
版权说明: 本书为公共版权或经版权方授权,请支持正版图书
标 签: SQL
ISBN 出版时间 包装 开本 页数 字数
未知 暂无 暂无 未知 0 暂无

作者简介

暂缺《Microsoft SQL SERVER 2005数据库基础:由入门到精通(英文版)》作者简介

内容简介

本书为英文版。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