Database Technology and Applications: SQL Server

Author: Liu Weiguo, Yan Hui
Publisher:
Publish Date: 2007-01-01
Features: This book is based on the fundamental requirements for the "Database Technology and Application" course teaching proposed by the Teaching Guidance Subcommittees for Computer Basic Courses in Non-Computer Majors of the Ministry of Education in 2004. The entire book is set against the background of SQL Server 2000, introducing the basic knowledge and application development techniques of databases. The main content includes: Introduction to Database Systems, Basic Principles of Relational Databases, SQL Server Database Fundamentals, Management of SQL Server Databases, Management of SQL Server Tables, Data Query, Basic Principles of Relational Databases, SQL Server Database Fundamentals, Management of SQL Server Databases, Management of SQL Server Tables, Data Query, Indexes and Views, Data Integrity, Transact-SQL Programming, Stored Procedures and Triggers, Security Management of Databases, Backup and Recovery of Databases, Import, Export, and Replication of Databases, and Database Application System Development. This book explains the basic concepts and methods of database systems from the perspective of database application system development. During the writing process, the authors strive to ensure clear concepts, reasonable material selection, in-depth and easy-to-understand explanations, and a focus on applications. This book can be used as a textbook for database application courses in higher education institutions and also serves as a reference for various computer application professionals. To facilitate teaching and hands-on practice for readers, the authors have organized the writing of "Database Technology and Application Practice Tutorial – SQL Server" as a companion experimental textbook to this book. Additionally, there are teaching presentations that accompany this book for reference by instructors.