Database application technology

Author: Yuan Xuesong, Editor-in-Chief
Publisher:
Publish Date: 2006-12-01
Features: This book is divided into 13 chapters, starting from basic concepts and practical applications, and explains database fundamentals, an overview of SQL Server 2000, T-SQL language, database creation and management, table creation and management, database queries and views, stored procedures and triggers, transactions and concurrency control, indexes and data integrity, backup and recovery and data conversion, system security management, database system design, and developing SQL Server applications. In line with the requirements of vocational and technical skill training, combined with case studies, multiple examples and exercises are provided to help learners better understand and master the basic knowledge and skills of databases. Through this course, learners will be able to accurately and comprehensively understand database fundamentals, 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. It highlights "advanced, concise, and practical" while adhering to the principles of being easy to teach and learn. The book is rich in examples and exercises, 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,", appropriately organizing the chapters to reduce the learning difficulty for students. This book can serve as a textbook for vocational and technical college students in computer-related majors, e-commerce, and other fields, as well as a reference for database application system developers, engineering technicians, and other relevant personnel.