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