browse by category

select a category on the left

1st

EDITION

Hardback/ Paperback

Paperback / softback

Learn more about formats

$39.99

Microsoft SQL Server 2005: A Beginner''s Guide

1st Edition

By Dusan Petkovic

Publication Date: Nov 22, 2005

ISBN:0072260939 / 9780072260939

Language: English

This product will be shipped to you.

more info

Imprint: McGraw-Hill Osborne Media Publisher: McGraw-Hill Education Dimensions: 9.2 X 7.4 Inches (US)

Summary
Table of Contents

Main 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.

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

Microsoft SQL Server 2005: A Beginner''s Guide

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