| | Copyright |
| | CramSession Approved Study Material |
| | | About CramSession.com |
|
| | About the Author |
| | | Contributing Authors |
| | | About the Technical Reviewers |
|
| | Acknowledgments |
| | | We Want to Hear from You! |
|
| | How to Use This Book |
| | | Chapter Opener |
| | | Instructional Features Within the Chapter |
| | | Case Studies |
| | | Extensive Review and Self-test Options |
|
| | Introduction |
| | | How This Book Helps You |
| | | What Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition Covers |
| | | Hardware and Software You'll Need |
| | | Advice on Taking the Exam |
| | | Que Certification |
|
| | Part I. Exam Preparation |
| | | Chapter 1. Introducing SQL Server 2000 |
| | | Introduction |
| | | Getting to Know SQL Server 2000 |
| | | Structured Query Language (SQL) |
| | | The Complete SQL Server 2000 Software |
| | | Books Online |
| | | SQL Server 2000 Limitations |
| | | SQL Server 2000 Versions |
| | | Case Study: ACME Generators |
| | | Chapter Summary |
| | | Apply Your Knowledge |
|
| | | Chapter 2. Database Design for SQL Server 2000 |
| | | Introduction |
| | | A Case Scenario Approach |
| | | Entity Relationship Modeling |
| | | Designing Entity Keys |
| | | Understanding Database Normalization |
| | | Maintaining Data Integrity |
| | | The Client/Server Model |
| | | Case Study: Jones & Sons |
| | | Chapter Summary |
| | | Apply Your Knowledge |
|
| | | Chapter 3. Physical Database Design and Implementation |
| | | Introduction |
| | | Creating and Altering Databases |
| | | Creating and Altering Database Objects |
| | | Multiple Server Implementations |
| | | Troubleshooting SQL Server Objects |
| | | Case Study: ACME Distributors |
| | | Chapter Summary |
| | | Apply Your Knowledge |
|
| | | Chapter 4. Querying and Modifying Data |
| | | Introduction |
| | | Data Retrieval |
| | | Filtering and Formatting Data |
| | | Data Summary |
| | | Making Data Modifications |
| | | Case Study: Address Book Application |
| | | Chapter Summary |
| | | Apply Your Knowledge |
|
| | | Chapter 5. Advanced Data Retrieval and Modification |
| | | Retrieve and Filter Data Using Transact-SQL |
| | | Grouping Data with Transact-SQL |
| | | Summarizing Data with Transact-SQL |
| | | Manipulating Heterogeneous Data with OPENQUERY , OPENROWSET , and Linked Servers |
| | | Extracting Data into XML |
| | | Using OPENXML to Read XML Data |
| | | Importing and Exporting Data |
| | | Case Study: Porter Steak Company |
| | | Chapter Summary |
| | | Apply Your Knowledge |
|
| | | Chapter 6. Programming SQL Server 2000 |
| | | Introduction |
| | | Scripts, Batches, and Transactions |
| | | Working with Variables |
| | | Comments |
| | | Statement Blocks with BEGIN...END |
| | | Conditional Statements and Branching with IF...THEN...ELSE |
| | | WHILE loops |
| | | Managing Result Sets by Using Cursors and Transact-SQL |
| | | Concurrency and Locking |
| | | Enforcing Procedural Business Logic Using Transactions |
| | | Managing Data Manipulation Using Transactions |
| | | Implementing Security |
| | | Case Study: Doug's Car Wash and Donuts |
| | | Chapter Summary |
| | | Apply Your Knowledge |
|
| | | Chapter 7. Working with Views |
| | | Introduction |
| | | Understanding Views |
| | | Create and Alter Views |
| | | Modifying Data Through Views |
| | | Alter Database Objects to Support Partitioned Views |
| | | Control Data Access by Using Views |
| | | Case Study: Boss Needs to Screen Data |
| | | Chapter Summary |
| | | Apply Your Knowledge |
|
| | | Chapter 8. Triggers |
| | | Introduction |
| | | Constraining Data Modifications |
| | | Triggers |
| | | Trigger Actions and Order |
| | | Security Implications with Triggers |
| | | Troubleshooting Triggers |
| | | Case Study: Emerald Sharp |
| | | Chapter Summary |
| | | Apply Your Knowledge |
|
| | | Chapter 9. Stored Procedures and User-Defined Functions |
| | | Introduction |
| | | Managing Data Manipulation Using Stored Procedures |
| | | Calling Stored Procedures; Passing and Returning Parameters To and From Stored Procedures |
| | | Enforcing Procedural Business Logic with Stored Procedures |
| | | Filtering Data Using Stored Procedures |
| | | Implementing Error Handling in Stored Procedures |
| | | Managing Data Manipulation with User-Defined Functions |
| | | Passing and Returning Parameters To and From User-Defined Functions |
| | | Enforcing Procedural Business Logic Using User-Defined Functions |
| | | Filtering Data with User-Defined Functions |
| | | Implementing Error Handling in User-Defined Functions |
| | | Case Study: Joe's Burger and Malt Shop |
| | | Chapter Summary |
| | | Apply Your Knowledge |
|
| | | Chapter 10. Boosting Performance with Indexes |
| | | Introduction |
| | | Overview of Indexing |
| | | Creating and Altering Indexes |
| | | Index Maintenance |
| | | Indexed Views |
| | | Full-Text Searches |
| | | Case Study: Western Furniture Ltd. |
| | | Chapter Summary |
| | | Apply Your Knowledge |
|
| | | Chapter 11. Implementing and Understanding Replication Methodologies |
| | | Introduction |
| | | Replication |
| | | Benefits of Replication |
| | | Understanding Replication Components: The Publisher/Subscriber Metaphor |
| | | Replication Configurations |
| | | Types of Replication |
| | | Replication Agents |
| | | Replication Internals |
| | | Updating Subscribers |
| | | Heterogeneous Interoperability |
| | | Enabling Replication in Your Application |
| | | Configuring the Distribution Server |
| | | Case Study: Dave's Video Rental Chain |
| | | Chapter Summary |
| | | Apply Your Knowledge |
|
| | | Chapter 12. Monitoring and Tuning SQL Server Databases |
| | | Introduction |
| | | Tools Available for Monitoring and Tuning |
| | | Optimizing the OS Configuration |
| | | Optimizing SQL Server Configuration |
| | | Monitor Activity with the Profiler |
| | | Trace Playback and Diagnosis |
| | | SQL Server Optimizer |
| | | Securing Objects |
| | | Case Study: Menaubi Foods |
| | | Chapter Summary |
| | | Apply Your Knowledge |
|
|
| | Part II. Final Review |
| | | Fast Facts |
| | | Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition |
| | | SQL Server 2000 Requirements |
| | | Database Design for SQL Server 2000 |
| | | Physical Database Design and Implementation |
| | | Querying and Modifying Data |
| | | Advanced Data Retrieval and Modification |
| | | Programming SQL Server 2000 |
| | | Working with Views |
| | | Use of Triggers |
| | | Stored Procedures and User-Defined Functions |
| | | Boosting Performance with Indexes |
| | | Implementing and Understanding Replication Methodologies |
| | | Monitoring and Tuning SQL Server Databases |
|
| | | Study and Exam Prep Tips |
| | | Learning Styles |
| | | Study Tips |
| | | Exam Prep Tips |
| | | Final Considerations |
|
| | | Practice Exam |
| | | Exam Questions |
|
|
| | Part 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 |
| | | PrepLogic Practice Tests, Preview Edition |
|
| | | Appendix D. Using the PrepLogic Practice Tests, Preview Edition Software |
| | | Exam Simulation |
| | | Question Quality |
| | | Interface Design |
| | | Effective Learning Environment |
| | | Software Requirements |
| | | Installing PrepLogic Practice Tests, Preview Edition |
| | | Using PrepLogic Practice Tests, Preview Edition |
| | | Get More Exams |
| | | Customer Service |
|
|
| | Index |