It's been five years since Microsoft released a new version of SQL Server-which holds 39% of the Windows database market-and the latest edition of this bestselling beginner's guide gets users up and running on SQL Server 2005. The book covers database concepts, and discusses key topics for new users including the SQL Server Workbench,T-SQL, automated administration tasks, security, and analysis.

• I: SQL Server: Basic Concepts
  • Database Systems and SQL Server
  • SQL Server Management Studio
• II: Transact-SQL Language
  • SQL Components
  • Data Definition Language
  • Simple Queries
  • Complex Queries
  • Modification of a Table's Contents
  • Stored Procedures and User-Defined Functions
  • Indices and Query Optimization
  • Views
  • Systems Catalog
  • SQL Server Security
  • Triggers
  • Transactions
  • SQL Server System Environment
• III: SQL Server: System Administration
  • Overview of System Administration
  • Planning the Installation and Installing SQL Server
  • Managing Database and Database Files
  • Managing Security
  • Backup and Recovery
  • Automating Systems Administration Tasks
  • Performance and Tuning
  • Data Partitioning
  • Data Replication
• IV: Microsoft Analysis Services
  • Data Warehousing: An Introduction
  • Microsoft Analysis Services
  • Business Intelligence and SQL
  • Microsoft Reporting Services
• V: XML Support
  • Overview of XML
  • SQL Server 2005 and XML