Books & Videos

Table of Contents

  1. Introduction to Database Development with Microsoft SQL Server 2005

    1. Chapter 1 Introducing Database Development with Microsoft SQL Server 2005

      1. The Process of Storing and Managing Data
      2. Introducing Database Systems
      3. Defining the Architecture of a Database Application
      4. Conclusion
    2. Chapter 2 Installing and Setting Up Your Microsoft SQL Server 2005 Development Environment

      1. Using a Virtual PC
      2. Recommended Productivity Tools
      3. Recommended Development Tools
      4. Microsoft SQL Server 2005 Editions
      5. Installing SQL Server 2005
      6. Conclusion
    3. Chapter 3 Reviewing Microsoft SQL Server 2005 Management Tools

      1. Introduction
      2. Using SQL Server Books Online
      3. Using SQL Server Configuration Manager
      4. Using SQL Server Surface Area Configuration
      5. Using SQL Server Management Studio
      6. Using SQL Server Profiler
      7. Using Database Engine Tuning Advisor
      8. Using SQLCmd
      9. Conclusion
  2. How to Create a Microsoft SQL Server 2005 Database

    1. Chapter 4 Gathering and Understanding Business Requirements before Creating Database Objects

      1. Understanding Business Processes and User Interaction Requirements
      2. Understanding Business Data and Its Lifetime
      3. Predicting the Volume of Information to Store and Manage and Predicting Database Utilization
      4. Conclusion
    2. Chapter 5 Designing a Database to Solve Business Needs

      1. Designing a Database Conceptually
      2. Designing a Database Logically to Leverage the Relational Engine
      3. Physically Creating a Database
      4. Conclusion
  3. How to Query Data from Microsoft SQL Server 2005

    1. Chapter 6 Reading Microsoft SQL Server 2005 Data from Client Applications

      1. Introducing Microsoft Data Access Components
      2. Introducing the .NET SQL Server Data Provider
      3. Introducing SQL Native Client
      4. Conclusion
    2. Chapter 7 Selecting the Data You Need

      1. Selecting Data from a Single Table
      2. Selecting Data from Multiple Tables
      3. Reading Single Values
      4. Reading Relational and XML Data
      5. Querying XML and Relational Data Using XQuery
      6. Sorting Data
      7. Conclusion
    3. Chapter 8 Creating Views to Encapsulate Queries

      1. Selecting Data from a Single View
      2. Mixing Data from Views and Tables
      3. Working with Views within Client Applications
      4. Conclusion
    4. Chapter 9 Retrieving Data Using Programmable Objects

      1. Introduction
      2. Working through a Simple Problem
      3. Common Language Runtime UDFs and Procedures
      4. Conclusion
  4. How to Modify Data in Microsoft SQL Server 2005

    1. Chapter 10 Inserting Data in Microsoft SQL Server 2005

      1. Using the INSERT Statement
      2. Inserting Data through Views
      3. Importing Data into SQL Server 2005
      4. Using Integration Services to Insert Data
      5. Encapsulating Insert Operations in Stored Procedures
      6. Triggering Actions Automatically when Inserting Data
      7. Dealing with Errors when Inserting Data
      8. Inserting Data from ADO.NET
      9. Conclusion
    2. Chapter 11 Deleting Data from Microsoft SQL Server 2005

      1. Using the DELETE Statement
      2. Deleting Data through Views
      3. Encapsulating Delete Operations in Stored Procedures
      4. Dealing with Errors
      5. Deleting Data from ADO.NET
      6. Conclusion
    3. Chapter 12 Updating Data from Microsoft SQL Server 2005

      1. Using the UPDATE Statement
      2. Updating Data through Views
      3. Encapsulating Update Operations in Stored Procedures
      4. Triggering Actions Automatically when Updating Data
      5. Dealing with Errors
      6. Updating Data from ADO.NET
      7. Conclusion