The MCSE TestPrep series is a unique way to prepare for MCSE exams. Each of the chapters covers a different exam objective. Each objective is further broken down into manageable sections. The information will be presented in a brief, outline format and will include an abundance of tables, figures, screen shots, and lists. Following each section will be a series of review questions, exercises, and answer explanations. Two complete practice exams for each test and a glossary will be located at the end of the book.Table of Contents includes: (1) Introduction; (2) Data Modeling; (3) Systems Databases and Tables; (4) Data Definition; (5) Retrieving Data; (6) Retrieving Data (Advanced Topics); (7) Modifying Data; (8) Indexes; (9) Using Views, Defaults and Rules Programmability; (10) Triggers; (11) Replication; (12) Application Development and Open Data Systems (ODS); (13) Practice Exam 1; (14) Practice Exam 2; (15) Glossary; and (16) About the Exam. Appendix.