Microsoft SQL Server 2005: A Beginner

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

3.0 1
by Dusan Petkovic
     
 

View All Available Formats & Editions

ISBN-10: 0072260939

ISBN-13: 9780072260939

Pub. Date: 10/16/2005

Publisher: McGraw-Hill Professional Publishing

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

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:
9780072260939
Publisher:
McGraw-Hill Professional Publishing
Publication date:
10/16/2005
Series:
Essential Skills for Database Professionals Ser.
Pages:
704
Product dimensions:
7.40(w) x 9.20(h) x 1.35(d)

Related Subjects

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

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

Microsoft SQL Server 2005: A Beginner"s Guide 3 out of 5 based on 0 ratings. 1 reviews.
Guest More than 1 year ago
An okay book on SQL Server but not one I'd recommend. I had better luck with Stanek's SQL Server 2005 Administrator Consultant.