Microsoft SQL Server 2005: A Beginner"s Guide / Edition 1

by Dusan Petkovic

Overview

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

Deploy and manage SQL Server 2005 with ease

Learn to use all the powerful features available in SQL Server 2005 from this straightforward, hands-on guide. Set up SQL Server 2005, automate system administration tasks, execute simple and complex database queries, and use the robust analysis, business intelligence, and reporting tools. Troubleshooting, data partitioning, replication, and query optimization are also covered. With SQL Server 2005: A Beginner’s Guide, you’ll be able to set up a secure, reliable, and productive data management platform in no time.

Essential Skills for Database Professionals

• Install and customize SQL Server 2005
• Create, alter, and remove database objects with Transact-SQL statements
• Use SQL Server as a native XML database system
• Tune your database system for optimal performance
• Use the new SQL Server Management Studio tool for executing and analyzing ad hoc queries
• Retrieve data from more than one source using join operations and SELECT statements
• Secure your database using two different authentication modes—Windows and mixed
• Restore databases using transaction logs and backup and recovery methods
• Streamline system administration tasks using the SQL Server Agent service tool
• Analyze and manage information stored in a data warehouse with Microsoft Analysis Services

Product Details

ISBN-13:	9780072260939
Publisher:	Osborne
Publication date:	10/16/2005
Series:	Essential Skills for Database Professionals Ser.
Pages:	704
Product dimensions:	7.20(w) x 9.10(h) x 1.43(d)

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