Your hands-on, step-by-step guide to learning the fundamentals of SQL Server 2005 programming.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