Title:
MCDBA SQL Server 2000 database design study guide (exam 70-229)
Personal Author:
Publication Information:
Berkeley, CA : Osborne/McGraw-Hill, c2001.
Physical Description:
1 CD-ROM ; 12 cm
ISBN:
9780072126945
General Note:
At head of title: MCDBA, Microsoft certified database administrator.
Accompanies text with the same title : QA76.3 B35 2001
Available:*
Library | Item Barcode | Call Number | Material Type | Item Category 1 | Status |
|---|---|---|---|---|---|
Searching... | 30000004820589 | CP 1989 | Open Access Computer File | Compact Disk (Open Shelves) | Searching... |
Searching... | 30000004896225 | CP 1989 | Open Access Computer File | Compact Disk (Open Shelves) | Searching... |
Searching... | 30000004896142 | CP 1989 | Open Access Computer File | Compact Disk (Open Shelves) | Searching... |
Searching... | 30000004896183 | CP 1989 | Computer File Accompanies Open Access Book | Compact Disc Accompanies Open Access Book | Searching... |
On Order
Summary
Summary
An integrated study system based on proven instructional methodology, this book includes special pedagogical elements such as step-by-step exercises, exam watch and on-the-job notes, and quick reference scenario and solution tables. More than 250 practice exam questions that match the actual exam questions in content and feel, while all answer options, correct and incorrect, receive detailed explanations as to why the answer is or is not the correct one. A self-test section includes knowledge- and scenario-based questions that match the actual exam questions. The CD-ROM features instructional graphical animations with audio explanations and an eBook, the electronic version of the study guide.
Table of Contents
| Foreword | p. v |
| About the Contributors | p. ix |
| Acknowledgments | p. xi |
| Preface | p. xxiii |
| Introduction | p. xxix |
| 1 An Overview of SQL Server 2000 | p. 1 |
| Understanding Relational Databases | p. 3 |
| SQL Server Architecture | p. 14 |
| Working with SQL Server 2000 | p. 35 |
| Developing SQL Server Applications | p. 42 |
| SQL Server 2000 Analysis Services | p. 45 |
| QandA | |
| 2 Developing a Logical Database Design | p. 55 |
| Defining Entities and Attributes | p. 57 |
| Entity Composition and Normalization | p. 66 |
| Designing for Referential Integrity | p. 82 |
| Managing Entity Relationships | p. 88 |
| Attribute and Domain Integrity | p. 100 |
| QandA | |
| 3 Implementing a Database | p. 129 |
| Planning for Storage Management | p. 130 |
| Implementing the Physical Database | p. 135 |
| Ensuring Data Integrity | p. 149 |
| QandA | p. 160 |
| 4 Programming Business Logic | p. 169 |
| Implementing Advanced Database Objects | p. 170 |
| Implementing Advanced Database Features | p. 188 |
| QandA | p. 207 |
| 5 Manipulating Data Using Transact-SQL | p. 217 |
| Overview of Coding SQL Queries | p. 218 |
| Retrieving Data Using Transact-SQL | p. 243 |
| QandA | p. 274 |
| 6 Tuning and Optimizing Database Performance | p. 285 |
| Monitoring and Optimizing Server Performance | p. 287 |
| Monitoring Database Activity with SQL Profiler | p. 298 |
| Designing and Implementing Indexing | p. 307 |
| Optimizing Queries with SQL Query Analyzer | p. 318 |
| QandA | p. 334 |
| 7 Transferring Data Between Systems | p. 345 |
| Importing and Exporting Data | p. 346 |
| Working with External Servers | p. 365 |
| XML Functionality | p. 372 |
| QandA | p. 399 |
| 8 Designing and Implementing Database Security | p. 409 |
| Understanding and Implementing SQL Server Security | p. 410 |
| Implementing Database-Level Security | p. 420 |
| Implementing Object-Level Security | p. 430 |
| Controlling Data Access | p. 437 |
| QandA | p. 450 |
| A About the CD | p. 459 |
| Installing CertTrainer | p. 460 |
| CertTrainer | p. 460 |
| ExamSim | p. 461 |
| E-Book | p. 461 |
| CertCam | p. 461 |
| Help | p. 462 |
| Upgrading | p. 462 |
| B About the Web Site | p. 463 |
| Get What You Want When You Want It | p. 464 |
| Glossary | p. 465 |
| Index | p. 493 |
