Database Principles and Applications: SQL Server 2000

Author: Tong Chunling
Publisher:
Publish Date: 2003-08-01
Features: This book is a teaching material that integrates the basic principles of databases with SQL Server 2000 applications. It covers knowledge at all levels, including installation, usage, management, and maintenance. The book strives to be both in-depth and easy to understand. The theory section concisely explains the data model of relational databases, the standard language of databases, the normalization of relations, database design, database protection, and database new technologies. The application section provides a detailed introduction to the installation of SQL Server 2000, the creation of databases and data tables, data queries, the creation and use of stored procedures and triggers, the management of SQL Server, the security and integrity design of databases, as well as database backup and recovery. The book adopts a task-driven approach, with one example throughout. From database and table creation to the security and integrity design of the database and database backup and recovery, everything is covered in one example. After reading this book, readers will gain a complete example of a scientific and technical archive management system, which can be used as a reference for developing other applications. This book can serve as a textbook for database courses in higher vocational schools, higher colleges, adult colleges, and secondary vocational colleges, as well as for introductory and advanced training programs in database-related fields. It can also be used as a reference book for database developers. The book comes with an electronic teaching plan, created in PowerPoint, which can be freely modified by instructors.