SQL Server 2000 Chinese Version Database Management and Application Standard Course

Author: Shi Chuangming
Publisher:
Publish Date: 2006-07-01
Features: This book primarily introduces the application knowledge of the SQL Server 2000/2005 relational database system. It comprehensively covers the fundamental theories of the relational data model, the installation and configuration of the SQL Server database system, the system architecture of SQL Server, the management and configuration of the SQL Server 2000 server, creating SQL Server databases and tables, managing data tables, querying databases, creating and using indexes and views, SQL programming knowledge, implementing stored procedures and triggers, SQL Server security and performance monitoring, database backup, transaction processing mechanisms and concurrency control mechanisms, SQL Server data transfer and distributed management. At the end of the book, it introduces SQL Server application programming knowledge. When introducing specific content in each chapter, the book closely integrates the two sample databases "Student Management Database" and "Dealer Management Database," achieving a combination of theory and practice. The book highlights the practical application knowledge of relational databases and SQL Server 2000/2005, with a well-structured layout and rich examples. It is suitable as a training textbook for SQL Server databases and can also serve as a reference for SQL Server database application professionals.