SQL Server Database Management. Design and Implementation Tutorial

Author: Zhao Jie
Publisher:
Publish Date: 2004-03-01
Features: This book is written based on the years of 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 needs of the Microsoft MCSE certification exam and practical application development. It introduces advanced installation of SQL Server databases, program design logic, 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, and 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 material for computer software developers, a supplementary textbook for undergraduate and junior college database principles and applications courses, or a self-study guide for computer enthusiasts.