本书能让读者轻松自学SQL Server 2005的基础技术,从数据库的设计、构建、测试到配置,每一个步骤都为读者提供了实际性的指导和帮助。通过本书,读者可以充分体验边做边学的乐趣,成功组建真正属于个人的首个SQL Server 2005数据库。
Part Ⅰ Introduction to Database Development with Microsoft SQL Server 2005
1 Introducing Database Development with Microsoft SQL Server 2005
2 Installing and Setting Up Your Microsoft SQL Server 2005 Development Environment
3 Reviewing Microsoft SQL Server 2005 Management Tools
Part Ⅱ 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 Ⅲ 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 Ⅳ 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