SQL Server Database Management Design and Implementation Tutorial

Author: Zhao Jie, Li Tao, Zhu Hui
Publisher:
Publish Date: 2004-03-01
Features: This book is written based on the practical teaching and application development experience of experts such as teachers from the Microsoft Certified Training Center of the Institute of Software, Chinese Academy of Sciences, and senior Microsoft development engineers. It addresses the strong societal demand for knowledge in this field. The book primarily focuses on the principles and features of SQL Server databases, combining the requirements of the Microsoft MCSE certification exam and practical application development. It introduces advanced installation of SQL Server databases, logical programming, Transact-SQL for complex applications, flexible use of views, triggers and stored procedures, user-defined data types and custom functions, maintaining data integrity, database planning and maintaining indexes, basic application design, advanced application design, advanced server management, advanced server security management, database architecture analysis, database backup and recovery as well as automated management, transaction processing mechanisms, concurrency control mechanisms, performance and activity monitoring, advanced data transfer applications, and comprehensive database development applications. As an advanced and intermediate database tutorial, this book offers significant practical guidance value. It can serve as a learning and reference resource for computer software developers, a supplementary textbook for undergraduate and college-level database principles and applications courses, or a self-study guide for computer enthusiasts.