SQL Server Database Management Standard Tutorial - (Multimedia Teaching Disc)

Author: Hu Jianfeng
Publisher:
Publish Date: 2007-01-01
Features: This book is the designated textbook for the National Information Technology Application Technology Qualification Certification (CCAT) project, belonging to the operator-level certification system. The purpose of establishing the CCAT qualification certification project is not only to cultivate students' mastery of relevant professional theoretical knowledge, but also to emphasize the training of students' hands-on skills and innovative abilities. It also focuses on cultivating and improving students' enterprise management capabilities, aiming to train versatile talents who understand both technology and management for society and enterprises, thereby addressing the defects in talent cultivation that overemphasize theory while neglecting practice, and prioritize diplomas over abilities. The book is divided into 11 chapters, including an overview of Microsoft SQL Server 2000, database file management, T-SQL language programming, basic operations on data tables, database queries and view operations, indexes and relational integrity, stored procedures and triggers, transactions, batches, and locks, SQL Server security management, ODBC database application programs, and Java and SQL Server 2000 application examples. Accompanying the book is a multimedia teaching CD-ROM, which facilitates practical operations for readers, enabling them to master more knowledge and skills in a shorter time. As the designated textbook for the CCAT project, this book can also serve as a teaching material for database technology in information and computer-related majors at universities and higher vocational colleges, as well as a reference for database administrators.