SQLSERVER2000 Database and Applications

Author: Jiang Xiuying
Publisher:
Publish Date: 2006-04-06
Features: This book is a research outcome of the implementation of the "Project Plan for Reform and Construction of Talent Cultivation Models and Content System in New Century Higher Vocational and Technical Education" by the Ministry of Education. The entire book takes the Student Performance 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 practical examples, organically integrating and connecting the knowledge points of each chapter, thereby enhancing the operability and readability of the textbook. The material is closely aligned with students' learning realities, lowering the learning difficulty and thus increasing students' interest and initiative in learning. The book is divided into 12 chapters, covering main content 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 manual for cultivating database system engineers and is suitable as a reference book for software developers using SQL Server.