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 fundamental knowledge and application development techniques of databases. The main content includes an introduction to database systems, basic principles of relational databases, fundamentals of SQL Server databases, database management in SQL Server, table management in SQL Server, data queries, basic principles of relational databases, fundamentals 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 author strives to ensure clear concepts, reasonable material selection, easy-to-understand depth, and a focus on applications. This book can serve as a textbook for database application courses in higher education institutions and also be referenced by computer application professionals of various types. 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 slides are provided as a reference for instructors.