Database Principles and Applications Tutorial

Author: Chen Zhibo Li Dongmei Wang Chunling
Publisher:
Publish Date: 2005-03-01
Features: This book systematically introduces the fundamental principles and applications of database technology. The book consists of seven chapters, covering main topics such as: Overview of Database Systems, Relational Model, SQL Language, Relational Database Theory, Database Security and Protection, Database Design, and SQL Server 2000 Database Management System. In addition to explaining the basic principles of database technology, the book also provides practical implementations of database technology using SQL Server 2000, including database and table maintenance, queries and statistics, view management, stored procedure and trigger management, user management, constraint and default management, database backup and restoration, and Transact-SQL programming. This enables readers to fully utilize the SQL Server 2000 platform to deeply understand the principles of database technology, achieving a strong integration of theory and practice. The content is presented in a step-by-step and easy-to-understand manner, with numerous examples provided for each chapter. Additionally, corresponding exercises are included at the end of each chapter to help readers reinforce their knowledge. This book can serve as a textbook for undergraduate and graduate students in computer science and related fields, as well as a reference for computer software professionals, engineering technicians, and other relevant personnel.