Microsoft SQL Server 2005: A Beginner"s Guide / Edition 1
by Dusan PetkovicView 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)
Table of Contents
Part I: SQL Server: Basic Concepts
Chapter 1: Database Systems and SQL ServerChapter 2: SQL Server Management StudioPart II: Transact-SQL Language Chapter 3: SQL ComponentsChapter 4: Data Definition LanguageChapter 5: Simple QueriesChapter 6: Complex QueriesChapter 7: Modification of a Table's Contents Chapter 8: Stored Procedures and User-Defined FunctionsChapter 9: Indices and Query OptimizationChapter 10: Views Chapter 11: Systems CatalogChapter 12: SQL Server Security Chapter 13: TriggersChapter 14: Transactions Chapter 15: SQL Server System Environment
Part III: SQL Server: System AdministrationChapter 16: Overview of System AdministrationChapter 17: Planning the Installation and Installing SQL ServerChapter 18: Managing Database and Database FilesChapter 19: Managing SecurityChapter 20: Backup and RecoveryChapter 21: Automating Systems Administration TasksChapter 22: Performance and TuningChapter 23: Data PartitioningChapter 24: Data Replication
Part IV: Microsoft Analysis ServicesChapter 25: Data Warehousing: An IntroductionChapter 26: Microsoft Analysis ServicesChapter 27: Business Intelligence and SQLChapter 28: Microsoft Reporting Services
Part V: XML SupportChapter 29: Overview of XMLChapter 30: SQL Server 2005 and XML
INDEX
Customer Reviews
Average Review:
Most Helpful Customer Reviews
 |
An okay book on SQL Server but not one I'd recommend. I had better luck with Stanek's SQL Server 2005 Administrator Consultant.
|