Microsoft SQL Server 2005: A Beginner's Guide (Paperback)

Description 

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.

Table Of Contents

Part I: Basic Concepts
Chapter 1: Database Systems and SQL Server
Chapter 2: SQL Server Workbench

Part II: Transact-SQL Language
Chapter 3: SQL Components
Chapter 4: Data Definition Language
Chapter 5: Simple Queries
Chapter 6: Complex Queries
Chapter 7: Modification of a Table's Contents
Chapter 8: SQL Extensions and Stored Procedures
Chapter 9: Indices and Query Optimization
Chapter 10: Views
Chapter 11: Systems Catalog
Chapter 12: SQL Server Security
Chapter 13: Triggers
Chapter 14: Transactions
Chapter 15: SQL Server System Environment

Part III: System Administration
Chapter 16: Overview of System Administration
Chapter 17: Planning and Installing SQL Server
Chapter 18: Managing Database and Database Files
Chapter 19: Managing Security
Chapter 20: Backup and Recovery
Chapter 21: Data Transfer
Chapter 22: Automating System Administration Tasks
Chapter 23: Troubleshooting SQL Server
Chapter 24: Performance and Tuning
Chapter 25: Data Partitioning
Chapter 26: Data Replication

Part IV: Analysis Services
Chapter 27: Data Warehousing--An Introduction
Chapter 28: Microsoft Analysis Services
Chapter 29: Reporting Services
Chapter 30: Client Components for Analysis Services

Part V: Building Solutions with SQL Server 2005
Chapter 31: XML Support
Chapter 32: SQL Server Full-Text Search
APPENDIX A: SOLUTIONS