SQL Server 2000 Programming Practice and Tutorial

Author: Jin Linqiao, Editor-in-Chief
Publisher:
Publish Date: 2010-06-17
Features: This book is a supplementary textbook for "SQL Server 2000 Programming Design." The entire book is divided into 14 chapters. Chapter 1 is an exercise on SQL Server 2000 installation and configuration, Chapter 2 is an exercise on database file management, Chapter 3 is an exercise on table and table data operations, Chapter 4 is an exercise on constraints, defaults, and rules, Chapter 5 is an exercise on relationships, indexes, and views, Chapters 6 and 7 are exercises on T-SQL programming design, Chapter 8 is an exercise on stored procedures, Chapter 9 is an exercise on triggers, Chapter 10 is an exercise on database backup and recovery, Chapter 11 is an exercise on security management, Chapter 12 is an exercise on server performance and activity monitoring, Chapter 13 is an exercise on SQL Server programming design tutorial exercises, and Chapter 14 is an exercise on ODBC database application development. Each chapter of the book provides exercises to help students review and consolidate the knowledge they have learned.