SQLServer7 Relational Database System Management and Development Guide

Author: Yang Zhenghong
Publisher:
Publish Date: 2000-04-01
Features: This book starts from the basic principles of relational databases and introduces the internal mechanisms of Microsoft SQL Server 7. Through examples, it covers the entire process of designing, implementing, and managing a relational database, including topics such as the installation and configuration of SQL Server 7, database design and management, fundamentals of SQL, creating indexes, designing data integrity, stored procedures, triggers, security, database backup and recovery, replication methods, database monitoring and optimization, etc. Based on the author's practical work experience, the book provides in-depth yet easy-to-understand discussions with strong practicality. Each chapter is accompanied by exercises and answers, which can guide readers to prepare for the Microsoft Certified Systems Engineer (MCSE) exam.