SQL Server Database Management and Development

Author: Xiao Shenyong
Publisher:
Publish Date: 2006-10-01
Features: This book uses SQL Server 2000 as a tool, closely following the development and changes in database technology, providing a comprehensive and detailed introduction to the use and database management of SQL Server 2000, as well as access technologies and Web application development based on SQL Server databases. The book is divided into 14 chapters. The content includes fundamental concepts of database systems, the meaning and steps of database design, entity-relationship models, relational models, and basic relational theory; it also provides a detailed introduction to the installation and operation methods of SQL Server 2000, data types, functions, and expressions, the creation and management of databases and database objects, the database language T-SQL and its application, views, indexes, triggers, stored procedures, cursors, and SQL Server programming. Additionally, it covers the security management of SQL Server 2000, database backup and recovery, data conversion and transfer, replication, and distribution. The introduction is centered around the SQL Server table database, focusing on major database access technologies and the application development of Web databases. This book incorporates the author's accumulated experience in long-term database teaching and practical applications, employing an example analysis method. Through numerous examples, it provides a comprehensive and in-depth explanation of database management and development applications. The examples are logically connected, concise, vivid, and easy to understand, with many of them carefully designed by the author. The content of the entire book is complete, and the language style is simple and engaging. The book is rich in examples and exercises, making it highly suitable for teaching and self-study in database technology for information and computer-related majors. It can also serve as a reference book for learning database management and development.