Acknowledgments
by Solid Quality Learning
Microsoft® SQL Server™ 2005: Database Essentials Step by Step
- Microsoft® SQL Server™ 2005: Database Essentials Step by Step
- A Note Regarding Supplemental Files
- Introduction
- Acknowledgments
- 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
- Introducing Database Systems
- 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 Database 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
- 3. Reviewing Microsoft SQL Server 2005 Management Tools
- Introduction
- Using SQL Server Books Online
- Using SQL Server Configuration Manager
- Using SQL Server Surface Area Configuration
- Using SQL Server Management Studio
- Using SQL Server Profiler
- Using Database Engine Tuning Advisor
- Using SQLCmd
- Conclusion
- 1. Introducing Database Development with Microsoft SQL Server 2005
- 4. Gathering and Understanding Business Requirements before Creating Database Objects
- Understanding Business Processes and User Interaction Requirements
- Understanding Business Data and Its Lifetime
- Predicting the Volume of Information to Store and Manage and Predicting Database Utilization
- Conclusion
- 5. Designing a Database to Solve Business Needs
- Designing a Database Conceptually
- Designing a Database Logically to Leverage the Relational Engine
- Physically Creating a Database
- Conclusion
- 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
- Selecting Data from a Single Table
- Selecting Data from Multiple Tables
- Reading Single Values
- Reading Relational and XML Data
- Querying XML and Relational Data Using XQuery
- Sorting Data
- Conclusion
- 8. Creating Views to Encapsulate Queries
- 9. Retrieving Data Using Programmable Objects
- IV. How to Modify Data in Microsoft SQL Server 2005
- 10. Inserting Data in Microsoft SQL Server 2005
- Using the INSERT Statement
- Inserting Data through Views
- Importing Data into SQL Server 2005
- Using Integration Services to Insert Data
- Encapsulating Insert Operations in Stored Procedures
- Triggering Actions Automatically when Inserting Data
- Dealing with Errors when Inserting Data
- Inserting Data from ADO.NET
- Conclusion
- 11. Deleting Data from Microsoft SQL Server 2005
- Using the DELETE Statement
- Deleting Data through Views
- Encapsulating Delete Operations in Stored Procedures
- Dealing with Errors
- Deleting Data from ADO.NET
- Conclusion
- 12. Updating Data from Microsoft SQL Server 2005
- 10. Inserting Data in Microsoft SQL Server 2005
- Index
- About the Author
- Copyright
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.