|
SQL Server 2005: A Beginner's Guide
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.
CONTENTS:
Part I: SQL Server: Basic Concepts
Chapter 1: Database Systems and SQL Server
Chapter 2: SQL Server Management Studio
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: Stored Procedures and User-Defined Functions
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: SQL Server: System Administration
Chapter 16: Overview of System Administration
Chapter 17: Planning the Installation and Installing SQL Server
Chapter 18: Managing Database and Database Files
Chapter 19: Managing Security
Chapter 20: Backup and Recovery
Chapter 21: Automating Systems Administration Tasks
Chapter 22: Performance and Tuning
Chapter 23: Data Partitioning
Chapter 24: Data Replication
Part IV: Microsoft Analysis Services
Chapter 25: Data Warehousing: An Introduction
Chapter 26: Microsoft Analysis Services
Chapter 27: Business Intelligence and SQL
Chapter 28: Microsoft Reporting Services
Part V: XML Support
Chapter 29: Overview of XML
Chapter 30: SQL Server 2005 and XML
INDEX
|
