SQLServer2000 Practical Tutorial

Author: Li Weihong
Publisher:
Publish Date: 2004-07-01
Features: This book primarily introduces the functional features of SQL Server 2000, a large-scale database management system launched by Microsoft, as well as practical techniques for database development using SQL Server 2000. Based on the author's extensive teaching and development experience, the content of the book is structured according to teaching principles. The book is divided into 14 chapters, covering the main topics of:
Overview of SQL Server 2000,
Common Tools of SQL Server 2000,
Database Creation and Management,
Table Creation and Management,
Data Operations in Tables,
Transact-SQL Programming,
View Creation and Usage,
Index Creation and Usage,
Stored Procedure Creation and Usage,
Trigger Creation and Usage,
SQL Server Security Management,
SQL Server Agent Services,
Database Backup and Recovery,
SQL Server Data Conversion.
To align with the "sufficient and practical" teaching principle of vocational and technical education, the book highlights key and challenging points in the content descriptions and integrates theoretical knowledge into database development examples. This enables students to immediately apply what they have learned to develop their own database systems, truly achieving the goal of learning by doing. The book can serve as a textbook for computer science and technology majors and related disciplines in vocational and technical colleges, as well as for individuals aspiring to master database development techniques. Accompanying the book is an electronic teaching plan created in PowerPoint, which can be freely modified by instructors. The electronic teaching plan can be downloaded from the website of China Water Conservancy and Electric Power Press.