Database Technology and Applications (SQL Server)

Author: Liu Weiguo
Publisher:
Publish Date: 2007-01-01
Features: This book is based on the basic requirements for teaching the "Database Technology and Application" course proposed by the Teaching Guidance Committee of Computer Basic Courses for Non-Computer Majors in Higher Education Institutions under the Ministry of Education in 2004. The entire book is set against the background of SQL Server 2000, introducing the basic knowledge and application development techniques of databases. The main content includes an introduction to database systems, the basic principles of relational databases, the basics of SQL Server databases, database management in SQL Server, table management in SQL Server, data queries, the basic principles of relational databases, the basics of SQL Server databases, database management in SQL Server, table management in SQL Server, data queries, indexes and views, data integrity, Transact-SQL programming, stored procedures and triggers, database security management, database backup and recovery, database import/export and replication, and database application system development. This book explains the basic concepts and methods of database systems from the perspective of database application system development. During the writing process, the book strives to achieve clear concepts, reasonable material selection, in-depth yet accessible explanations, and a focus on applications. It can serve as a textbook for database application courses in higher education institutions and also as a reference for various computer application professionals. To facilitate teaching and hands-on practice for readers, the author has also organized the writing of the accompanying practical textbook, "Database Technology and Application Practice Tutorial—SQL Server." Additionally, teaching presentation materials are available as a reference for instructors.