SQL Server 2000 Practical Development Tutorial (Higher Vocational and Technical Colleges)

Author: Wang Fengxie
Publisher:
Publish Date: 2006-02-01
Features: This book is part of the 21st Century Vocational and Technical College Planning Textbooks · Computer Series. The entire book is divided into 14 chapters, with main content organized into 4 parts:
Part 1 primarily covers the basics of relational databases and relational operations.
Part 2 focuses on the creation and management of databases and data tables, the Transact-SQL database programming language, views and indexes, as well as the creation and management of stored procedures and triggers, database security management, and database backup and conversion techniques.
Part 3 mainly discusses the general processes and methods for developing database management information systems, illustrating the methods and steps for connecting and operating SQL Server databases using a development tool (ASP) through an example.
Part 4 includes system functions, a quick reference table for stored procedures, and key script code for the teaching sample databases Pubs and Northwind, serving as a reference for teaching and learning.
To strengthen the integration of theory and practice, each chapter provides a large number of exercises and practical training questions to help readers consolidate their knowledge.
Additionally, this book offers teachers PowerPoint electronic teaching plans.
This book can be used as a textbook for computer and related majors in vocational and technical colleges, as well as a self-study textbook and reference for database developers and computer enthusiasts learning SQL Server 2000.