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 ... Show synopsis 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 2005Design database components with SQL Server Management Studio Apply a three-step modeling approach to design databases that meet business requirementsCreate, modify, and manage viewsWrite user-defined functions and stored procedures using T-SQLAdd, delete, and update information in your databasesWork with data from custom applications and legacy systemsTroubleshoot error messages and handle exceptions CD features: All practice exercisesCode samples For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.