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