SQL Server 2005: A Beginners Guide

Customers who bought this, also bought: Beginning Transact-SQL with SQL Server 2000 and 2005 Beginning Visual Basic 2005 Microsoft Windows XP Professional Resource Kit (3rd Edition) Microsoft SQL Server 2005 Administrator's Pocket Consultant Performance Tuning for Linux Servers MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam SQL Cookbook Teach Yourself VISUALLY Macromedia Dreamweaver 8 A Developer's Guide to SQL Server 2005 Virtualization with VMware ESX Server

by: Petkovic

On-line Price: $56.00 (includes GST) package 736 20%Off Retail Price You save: $14.00 In Stock - Available for immediate delivery! _____________________ N.Sydney : In Stock	Retail Price: $70.00 Publisher: MCGRAW-HILL,2005-10-05 Category: Level: ISBN: 0072260939 ISBN13: 9780072260939
Add to Shopping Cart

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 Back to top

Part I: Basic Concepts
Chapter 1: Database Systems and SQL Server
Chapter 2: SQL Server Workbench
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: SQL Extensions and Stored Procedures
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: System Administration
Chapter 16: Overview of System Administration
Chapter 17: Planning and Installing SQL Server
Chapter 18: Managing Database and Database Files
Chapter 19: Managing Security
Chapter 20: Backup and Recovery
Chapter 21: Data Transfer
Chapter 22: Automating System Administration Tasks
Chapter 23: Troubleshooting SQL Server
Chapter 24: Performance and Tuning
Chapter 25: Data Partitioning
Chapter 26: Data Replication
Part IV: Analysis Services
Chapter 27: Data Warehousing--An Introduction
Chapter 28: Microsoft Analysis Services
Chapter 29: Reporting Services
Chapter 30: Client Components for Analysis Services
Part V: Building Solutions with SQL Server 2005
Chapter 31: XML Support
Chapter 32: SQL Server Full-Text Search
APPENDIX A: SOLUTIONS