SQL Server 2005: Database Essentials Step-by-Step

Description

Get the guidance you need to start designing databases - one step at a time. With this practical tutorial, you’ll teach yourself the core skills for building and managing databases with the next generation of SQL Server.

Discover how to:

* Install and configure SQL Server 2005
* Design database components with SQL Server Management Studio
* Apply a three-step modeling approach to design databases that meet business requirements
* Create, modify, and manage views
* Write user-defined functions and stored procedures using T-SQL
* Add, delete, and update information in your databases
* Work with data from custom applications and legacy systems
* Troubleshoot error messages and handle exceptions

CD features:

* All practice exercises
* Code samples

CONTENTS:

IntroductionAcknowledgmentsPart I: Introduction to Database Development with Microsoft SQL Server 2005
* Chapter 1: Introducing Database Development with Microsoft SQL Server 2005
* Chapter 2: Installing and Setting Up Your Microsoft SQL Server 2005 Development Environment
* Chapter 3: Reviewing Microsoft SQL Server 2005 Management ToolsPart II: How to Create a Microsoft SQL Server 2005 Database
* Chapter 4: Gathering and Understanding Business Requirements before Creating Database Objects
* Chapter 5: Designing a Database to Solve Business NeedsPart III: How to Query Data from Microsoft SQL Server 2005
* Chapter 6: Reading Microsoft SQL Server 2005 Data from Client Applications
* Chapter 7: Selecting the Data You Need
* Chapter 8: Creating Views to Encapsulate Queries
* Chapter 9: Retrieving Data Using Programmable ObjectsPart IV: How to Modify Data in Microsoft SQL Server 2005
* Chapter 10: Inserting Data in Microsoft SQL Server 2005
* Chapter 11: Deleting Data from Microsoft SQL Server 2005
* Chapter 12: Updating Data from Microsoft SQL Server 2005