SQL Server 2000 Practical Tutorial

Author: Liu Weihong
Publisher:
Publish Date: 2003-09-01
Features: This is a practical textbook explaining MS-SQLSERVER2000 application skills. The book covers comprehensive knowledge, from the installation and debugging of SQLSERVER2000, creating devices, establishing databases, creating tables, to optimizing and adjusting databases, operating databases, ensuring database integrity and consistency, database backup, and establishing various application examples. The entire book is divided into 18 chapters, covering topics such as database systems, SQLSERVER2000 database architecture, installation and configuration, SQL language, T-SQL programming, transaction management, database system management, database security and maintenance, database backup and restoration, performance tuning and optimization, C/S-mode database application development using ODBC, ADO, and DAO, distributed database application development based on SQLSERVER2000 in the DELPHI7 IDE, and web application system development based on the Internet using ASP. The content is comprehensive, ranging from simple to complex, with thorough explanations and practical examples. This book is primarily aimed at database system administrators, college students, and database application developers. It can also serve as an ideal textbook for business enthusiasts and social training classes.