Overview
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
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to [email protected].
Synopsis
SQL Server 2005 is Microsoft's next-generation data management and analysis solution that delivers enhanced scalability, availability, and security features to enterprise data and analytical applications while making them easier to create, deploy, and manage. Now you can teach yourself essential techniques for working with SQL Server 2005 and start designing, building, testing, and deploying SQL Server databases-one step at a time. With Step By Step, new-to-topic database developers work at their own pace through hands-on, learn-by-doing exercises. Each chapter puts you to work, building your knowledge of core capabilities and guiding you as you create your first SQL Server database and apply your knowledge to solve real business problems.
Editorials
From Barnes & Noble
The Barnes & Noble ReviewLearn by doing. It works. It's the idea behind Microsoft's Step-by-Step tutorials. And it's especially appropriate for rich, complex subjects -- like SQL Server 2005 database design and development.
This isn't just "point here, click there" (though the authors certainly help you set up and navigate your SQL Server development environment). Using realistic sample files, you'll walk through database development, hands-on -- and brains-on. (For instance, you don't just learn how to create database objects; you learn best practices for gathering and understanding the business requirements they're based on.)
Once you've designed your database, you'll master the essentials of querying and modifying data: selecting it; retrieving it via programmable objects; creating views; and performing inserts, updates, and deletes. By the time you're done, you'll know how to get real value out of SQL Server 2005 -- which is, after all, why you bought it. Bill Camarda, from the October 2006 Read Only