SQL Server Database Principles and Applications: 21st Century Planning Textbooks for Higher Vocational and Technical Colleges

Author: Zeng Changjun
Publisher:
Publish Date: 2005-02-01
Features: SQL Server 2000 is a new version of SQL Server released by Microsoft. It is an excellent, large-scale relational database management software known for its ease of use and stable performance, making it one of the best database products in fields such as e-commerce. This book starts with the basic theories and knowledge of databases and introduces the processes of database analysis, design, and development through numerous examples. It primarily covers the fundamental principles and basic knowledge of databases, explaining the installation, usage, management, and maintenance of SQL Server 2000 in various aspects, including creating databases, SQL query statements, T-SQL, indexes and data integrity, stored procedures and triggers, database security management, backups, and recovery. The last two chapters explain Visual Basic/SQL Server development and programming from the perspective of software engineering, providing a comprehensive example of a SQL Server 2000 application. Each chapter also includes a certain number of exercises to help readers deepen their understanding. The book is concise and well-illustrated, making it easy for readers to quickly grasp the basic operations and usage of SQL Server 2000. It can serve as a textbook for computer majors in higher vocational and technical colleges on "Network Databases," as well as for other majors on "Database Applications," "E-commerce Databases," or similar courses. It can also be used as a reference book for web developers and maintainers.