Microsoft SQL Server 2005: A Beginner''s Guide

by Dusan Petkovic

Overview

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.

Product Details

ISBN-13:	9780071782135
Publisher:	McGraw Hill LLC
Publication date:	12/13/2005
Sold by:	Barnes & Noble
Format:	eBook
Pages:	704
File size:	15 MB
Note:	This product may take a few minutes to download.

About the Author

Dusan Petkovic is a professor in the Department of Computer Science at the Polytechnic in Rosenheim, Germany. He is the bestselling author of two editions of SQL Server: A Beginner’s Guide and is a frequent contributor to SQL Server magazine.

Table of 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