SQL Server 2005 Database Management and Application Master Guide

Author: Zhu Deli
Publisher:
Publish Date: 2007-01-01
Features: Based on the general principles of technical learning, this book guides readers through the entire path of mastering SQL Server 2005 from zero to a database management expert through carefully designed learning curves. The book is richly illustrated and introduces the basic theories and technical systems of SQL Server 2005 in a step-by-step manner. Almost every knowledge point is explained in detail from an application perspective with practical examples. The book is divided into three parts: Basic, Advanced, and Application, with a total of 18 chapters. It explains the foundational knowledge, advanced usage techniques, and project application methods of SQL Server 2005 in a focused and hierarchical manner. Chapters 1 to 10 build a solid foundation for learning SQL Server 2005 by covering system deployment techniques, basic operation methods, the theoretical foundations of databases and their implementation in SQL Server 2005, T-SQL usage techniques, in-depth SQL Server 2005 database management, the utility of command-line tools, techniques for creating secure database systems, database backup and recovery, the use of SQL Server Profiler for database tracking, and the use of the Database Engine Tuning Advisor. Chapters 11 to 16 detail the use of advanced technologies such as the integration of XML with SQL Server 2005, full-text search, SQL Server replication, asynchronous message processing with Service Broker, the use of Notification Services, and CLR usage techniques based on VS2005. Chapters 17 and 18 explain the small HR development process based on SQL Server 2005 and the collaborative implementation of business intelligence using SSIS, SSAS, and SSRS from an application perspective.
The source files for this book can be downloaded from the "Download Zone" at http://www.fecit.com.cn. The well-structured design of this book ensures that it can serve as a textbook for various database training courses and universities, as well as a reference for database developers of all kinds.
The book is richly illustrated and introduces the basic theories and technical systems of SQL Server 2005 in a step-by-step manner, while explaining almost every knowledge point in detail from an application perspective with practical examples.