Microsoft SQL Server 2005

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

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.