SQL Server 2000 Instance Tutorial

Author: Yang Xuequan
Publisher:
Publish Date: 2004-07-01
Features: The book is divided into 14 chapters, starting from basic concepts and practical applications, and explains database design fundamentals, database creation, table operations, view operations, index creation, stored procedures and trigger applications, function applications, SQL programming, data security and management, backup and recovery, etc., in a step-by-step and progressive manner. The case study of "Student Course Selection System Development" is integrated into each chapter, illustrating the principles and specific methods of database creation, management, development, and SQL programming. It briefly introduces hands-on lab operations for SQL Server. In line with the requirements of vocational skill cultivation, combined with case studies, it provides over 100 examples and exercises to help learners better understand and master the basic knowledge and skills of databases. Through this course, learners can accurately and comprehensively understand the fundamentals of databases, master the basic operations of SQL Server 2000, develop the mindset of programming with SQL, and improve their level of database management and development. The book strives for accuracy and conciseness in explanations, emphasizing the hierarchical nature of knowledge and the progressive development of skills. The design of examples and exercises is meticulous and rich, focusing on cultivating students' SQL Server database management and development skills. In terms of content arrangement, it follows the principles of "progressive learning" and "breaking down difficulties,", reducing the learning difficulty for students. This book can serve as a textbook for undergraduate and graduate students in computer science and related fields, as well as a reference book for database professionals, especially beginners in large relational databases.