Microsoft® SQL Server™ 2005: Database Essentials Step by Step

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

For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.