SQL Server 2000 Database Technology Practical Tutorial (21st Century Higher Vocational and Technical College Planning Textbooks)

Author: Yue Guoying
Publisher:
Publish Date: 2005-03-01
Features: This book is one of the planned teaching materials for vocational and technical colleges in the 21st century, belonging to the 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, including data queries, 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 practical implementation of SQL Server 2000, enabling readers to easily grasp the basic principles of databases and apply them in practice through the example database throughout the book. Through the case study of a savings account, the complete process of database application is presented, providing readers with 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 electronic teaching materials in PPT format, which are provided free of charge to instructors. This book can serve as a teaching material 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 professionals engaged in related work and computer enthusiasts learning database and SQL Server 2000 knowledge.