Database Principles and Applications -- SQL Server 2000

Author: Tong Chunling, Shen Xiangjiu (editors)
Publisher:
Publish Date: 2003-08-01
Features: This book is a teaching material that integrates the basic principles of databases with the application of SQL Server 2000. 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 design of database security and integrity, as well as database backup and recovery. The book adopts a task-driven approach, with one example running through the entire book. From database and table creation to the design of database security and integrity, as well as backup and recovery, everything is illustrated with a single example. After reading this book, readers will gain a complete example of scientific and technical file management, which can be used as a reference to develop other applications. This book can be used as a textbook for database courses in higher vocational schools, higher colleges, adult colleges, secondary vocational colleges, and private colleges. It can also serve as an introductory and advanced textbook for database training programs or 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.