Chapter tow, system architecture of SQL, give in depth knowledge of net-library, command parser, storage engine, lock manager, memory, cache and checkpoints, disk i/o, the default databases objects and system tables.
Chapter three, security, includes server logins, database users, server and database roles, database, statement and object permission, security using views and sp. The other 10 chapters are devides into the following capters;
Data structure, Distribution and transferring of data, Backup solutions, Restore, Monitoring and optimization, Automating SQL, Replication, Troubleshooting and understanding of TSQL.
I have used both Sybex and MS press book for my SQL certs. They provide a lot of lab simulations but they lack the in-depth knowledge needed to pass the exam.
There are some conflicting use of the two words SQL Server 7 and SQL 2000. I suppose the bad typo can bring some confusion while reading the book, but it is so obvious and are easy to spot. The typo mistakes forced me to give the book only 4 stars, but I will highly recommend this book to anyone who is dipping into the mcdba track and other SQL interested people out there.
This book along with Professional SQL Server 2000 Programming
by rob vieira, will make your life a lot easyer and provide you all the knowlege you can hadle for months to come.