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

Learning, Solid Quality

Softcover

ISBN 10: 0735622078 ISBN 13: 9780735622074

Publisher: Microsoft Press, 2006

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 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.

About this title

From the Publisher

This book fills an important gap in learning for new database programmers and administrators working with SQL Server 2005. Instead of merely explaining new features, the popular STEP BY STEP approach provides practical, hands-on guidance on how to use key features within specific business scenarios. Readers will master the fundamentals of database design and creation, including how to integrate solutions with applications for Microsoft Windows® and the Web. The companion CD includes data sets and sample code for all exercises.

Key Book Benefits:

· Builds a solid understanding of how to use SQL Server 2005 to create database applications.

· Provides sequential, step by step guidance for new programmers.

· Features easy-to-understand, logically planned lessons, with necessary data sets and additional code samples on the CD.

About the Author

The mentors at Solid Quality Learning combine deep technical expertise and real-world implementation experience to provide advanced solutions and training for the Microsoft SQL Server database platform.

Edition details

• Publisher: Microsoft Press
• Publication date: 2006
• ISBN 10: 0735622078
• ISBN 13: 9780735622074
• Binding: Paperback
• Language: English
• Number of pages: 306