| | | 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 |