SQL Server Database Application Technology

Author: Zhang Shuiping Wang Rong
Publisher:
Publish Date: 2005-04-01
Features: This book is a bilingual textbook designed for computer and related majors in colleges and universities. The SQL Server introduced in the book is a very popular database product in the market. Based on the fundamental concepts of database systems, the design methods of database application systems, and the structure of SQL Server, the book focuses on discussing how to apply the languages and tools provided by SQL Server to design a teaching management database system. Appropriately included in the book are some English narratives, with the aim of helping readers improve their professional English reading skills while learning professional knowledge. The content of the book includes eleven chapters: Fundamentals of Database Systems, Overview of SQL Server, Database Design, Database Operations, Data Query and Statistics, Views, Stored Procedures, Triggers, Transact-SQL Programming Methods, Data Backup and Recovery, Web Publishing for SQL Server, Server Management, and SQL Server and Application Program Interfaces. Important concepts covered in each chapter are accompanied by relevant examples to help readers understand and master them. Each chapter concludes with practical exercises, summaries, and review questions. The appendices at the end of the book provide supplementary materials for using this textbook. This book can serve as a teaching text for computer majors, a self-study guide for those taking relevant computer professional exams, and a reference for related technical personnel.