Microsoft SQL Server 2005: A Beginner''s Guide

ISBN-13: 9780072260939 / Angielski / Miękka / 2005 / 704 str.

Dusan Petkovic

Opis

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.

Spis treści

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

O autorze

Dusan Petkovic (Germany) is a professor in the Department of Computer Science at the Polytechnic in Rosenheim, Germany. He frequently contributes to SQL Server Magazine and has published 8 other computer books in Germany for Addison Wesley and McGraw-Hill.