Skip to main content

Microsoft SQL Server 2005 For Dummies

Andrew Watt

ISBN: 978-0-470-00741-9

Jan 2006

432 pages

Select type: E-Book

Product not available for purchase


  • Now updated to reflect the much-anticipated "Yukon" release of SQL Server, this friendly guide shows database developers and administrators as well as those who use database application how to get up to speed fast
  • Offers a gentle introduction to relational database design and shows how to build databases, create database applications, and maintain and optimize database performance
  • Covers the major new features of the "Yukon" release-including analysis services, reporting services, and notification services

Part I: SQL Server 2005: An Overview.

Chapter 1: Introducing SQL Server 2005.

Chapter 2: New Features in SQL Server 2005.

Chapter 3: Introducing and Configuring Management Studio.

Part II: Basic Operations.

Chapter 4: Creating Databases, Tables, and Relationships with T-SQL.

Chapter 5: Asking Questions and Getting Answers.

Chapter 6: Building a Simple Application.

Part III: Working with SQL Server.

Chapter 7: Working with XML.

Chapter 8: Using the Common Language Runtime.

Chapter 9: Using Stored Procedures.

Chapter 10: Error Handling in T-SQL.

Part IV: Protecting Your Data.

Chapter 11: Securing Your Data.

Chapter 12: Availability and Preventing Data Loss.

Chapter 13: Maintaining Integrity with Transactions.

Chapter 14: Maintaining Data Integrity with Constraints and Triggers.

Part V: Administering a SQL Server System.

Chapter 15: Configuring a SQL Server System.

Chapter 16: Scheduling SQL Server Agent Jobs.

Chapter 17: Sending Information Using Notification Services.

Chapter 18: Maintaining a SQL Server System.

Chapter 19: Working with Multiple Servers.

Part VI: Using SQL Server Business Intelligence (BI) Services.

Chapter 20: SQL Server Integration Services.

Chapter 21: Analysis Services.

Chapter 22: Building Business Reports with Reporting Services.

Part VII: The Part of Tens.

Chapter 23: Ten Sources of Information on SQL Server 2005.

Chapter 24: Products that Work with SQL Server 2005.


Download the Source Code
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.