(NOTE:
Each chapter begins with an Introduction.)
I. EXAM PREPARATION.
1. Data Modeling. A College Enrollment Database. Introducing Data Modeling Concepts: Entities, Attributes, and Relationships. Implementing Entities and Attributes. Implementing Relationships. Normalizing Your Database Design.
2. Creating Physical Storage. Units of Storage in SQL Server. Database Files and File Groups. Creating a Database. Database Options.
3. Implementing a Physical Design. Understanding Data Types. Managing Tables. Using Constraints.
4. Indexing. Introduction to Indexes. Types of Indexes. Guidelines for Indexing. Managing Indexes with Transact-SQL. Managing Indexes with Enterprise Manager. Implementing Full-Text Search.
5. Populating a Database. Using Bulk Copy to Import and Export Data. Using the BCP Command-Line Utility. Using the BULK INSERT Statement. Using Data Transformation Services to Import and Export Data.
6. Retrieving Data. Writing SELECT Statements: An Overview. Choosing Columns. Using DISTINCT and ALL Keywords. Choosing Rows. Sorting Result Rows. Generating Summary Data. Using Joins. Using Sub-Queries.
7. Modifying Data. The INSERT Statement. The UPDATE Statement. The DELETE Statement.
8. Programmability. Control-of-Flow Statements. Managing Errors. Using Transactions. Implementing Cursors.
9. Miscellaneous Programming Techniques. Stored Procedures. Views. Triggers. Distributed Queries.
10. Client Accessibility. Dynamic Model versus Stored Procedure Model. Configuring Session-Level Options.
11. Maintaining a Database. Creating, Examining, and Optimizing Execution Plans. Diagnosing and Resolving Locking Problems. Using SQL Server Profiler.
II. FINAL REVIEW.
12. Fast Facts: SQL_Server 7 Database Design. Developing a Logical Data Model. Deriving the Physical Design. Creating Data Services. Creating a Physical Database. Maintaining a Database.
13. Study and Exam Prep Tips. Study Tips. Exam Prep Tips. Final Considerations. Chapter-Practice Exam. Answers and Explanations.
III. APPENDIXES.
Appendix A: Glossary. Appendix B: Overview of the Certification Process. Types of Certification. Certification Requirements.
Appendix C: What's on the CD-ROM. Top Score. Exclusive Electronic Version of Text. Copyright Information and Disclaimer.
Appendix D: Using the Top Score Software. Getting Started. Instructions on Using the Top Score Software. Summary.
Index.