SQL Server 2000 Database and Applications

Author: Jiang Xiuying
Publisher:
Publish Date: 2006-03-01
Features: This book is a research outcome of the implementation of the "Project Plan for Reform and Construction of Talent Cultivation Models and Teaching Content Systems in New Century Higher Vocational and Technical Education" by the Ministry of Education. The entire book takes the Student Score Management System as the core example, employing a project-driven approach to teach the application of SQL Server 2000 database. It is supplemented with abundant application examples, organically integrating and connecting the knowledge points of each chapter, thereby enhancing the operability and readability of the textbook. The material closely aligns with students' learning realities, reducing the difficulty of learning and thus increasing students' interest and initiative in learning. The book is divided into 12 chapters, covering main topics such as an overview of SQL Server 2000, the basics of Transact-SQL language, database creation and management, table creation and management, data querying, views and indexes, data integrity, stored procedures and triggers, cursors, transactions and locks, SQL Server security management, daily maintenance and management of databases, and application project development examples. Each chapter provides the database used in the examples. This book can serve as a textbook for students in applied undergraduate, adult education, and higher vocational and technical computer-related programs. It can also be used as a training textbook for cultivating database system engineers and is suitable as a reference book for software developers using SQL Server.