SQL Server 2000 Practical Development Tutorial

Author: Wang Fengmao, Editor-in-Chief
Publisher:
Publish Date: 2006-02-01
Features: A collection of teaching experiences from several frontline teachers over the years; written in an example-based teaching mode; illustrated with graphics, clear organization, easy to teach and learn; free PPT format electronic teaching materials are provided. This book is part of the 21st Century Higher Vocational and Specialized College Planning Textbooks·Computer Series. The book is divided into 14 chapters, with the main content divided 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, and the creation and management of stored procedures and triggers, as well as database security management and database backup and conversion techniques.
Part 3 primarily discusses the general process and methods for developing database management information systems, using an example to illustrate the methods and steps for connecting and operating SQL Server databases with a development tool (ASP).
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 learning. Additionally, the book provides PowerPoint electronic teaching materials for teachers.
This book can be used as a textbook for computer and related majors in higher vocational and specialized colleges, as well as a self-study textbook and reference for database developers and computer enthusiasts learning SQL Server 2000.