SQL Server 2000 Database Technology Practical Tutorial

Author: Yue Guoying
Publisher:
Publish Date: 2005-02-01
Features: This book is part of the 21st Century Vocational and Technical College Planning Textbooks · Computer Series. The book is divided into 11 chapters, with the main content divided into two parts: one part introduces the overview of databases, relational databases, and their standard language SQL; the other part covers the basic knowledge and operations of SQL Server 2000, data queries in SQL Server 2000, SQL Server 2000 Transact-SQL programming and applications, data integrity and SQL Server's integrity control, database security and SQL Server 2000 security management, database concurrency control and SQL Server 2000 concurrency control mechanisms, database recovery techniques and SQL Server 2000 data recovery mechanisms, and database design and applications. The book closely combines database technology with the specific implementation of SQL Server 2000, enabling readers to easily grasp the basic principles of databases and apply them in practice through the example database. Through the case study of a savings account, the complete process of database application is presented, giving readers a comprehensive understanding and grasp of database technology and its applications. For ease of learning, each chapter is carefully designed with exercises, and experiments and course design content are arranged in corresponding chapters to achieve a balance between learning and application, allowing readers to quickly master the relevant knowledge. Additionally, to facilitate teaching, the book is accompanied by PPT format electronic teaching materials, which are provided free of charge to instructors. This book can serve as a textbook for students of relevant majors in vocational and technical colleges studying database and SQL Server 2000 courses, as well as a self-study textbook or reference book for those working in related fields and computer enthusiasts.