SQL Server 2000 Database Management and Development Practical Tutorial

Author: Li Dan
Publisher:
Publish Date: 2005-08-01
Features: This book is designed based on the characteristics and requirements of vocational and technical education, adhering to the principle of sufficient theory while emphasizing the cultivation of practical skills. It introduces abstract concepts and command formats from the perspective of practical examples, progressing from simple to complex and systematically covering the relevant knowledge of SQL Server 2000. The content is organized from both fundamental theories and practical applications, with concise text and a well-structured layout. The main contents include: basic principles of databases, an overview of SQL Server, creation and management of databases and tables, querying data in tables, Transact-SQL statements, indexes, views, cursors, transactions, stored procedures, triggers, SQL Server security management, backup and recovery, application programming interfaces provided by SQL Server, and application development examples. The features of this book are as follows:
● A comprehensive example is used throughout the book, guiding students step by step to complete the design of a full-fledged database system, truly achieving the goal of learning by doing.
● The examples selected emphasize practicality and novelty, focusing on the connection between theory and practice, with strong operability and practicality.
● Each chapter is accompanied by exercises and experiments to deepen students' understanding of the fundamental knowledge.
● Electronic lecture materials and program source codes are provided for the convenience of instructors and students for self-study.
This book systematically explains the theoretical knowledge and basic operations of SQL Server 2000, covering the following main contents: basic principles of databases, an overview of SQL Server, creation and management of databases and tables, querying data in tables, Transact-SQL statements, indexes, views, cursors, transactions, stored procedures, triggers, SQL Server security management, backup and recovery, application programming interfaces provided by SQL Server, and application development examples.
The book emphasizes the cultivation of practical skills, with exercises and experiments at the end of each chapter to enhance understanding of the fundamental knowledge. It also features a comprehensive example throughout, gradually guiding students to design a complete database system. The application examples at the end of the book enable students to develop their own database systems, truly achieving the goal of learning by doing.
This book can serve as a teaching material for vocational and technical colleges, polytechnic universities, and related majors, as well as for and database technicians.