| |
| |
| Welcome to Microsoft SQL Server 2000 Database Design and Implementation | |
| |
| |
| Before You Begin | |
| |
| |
| Using the MCSE Readiness Review | |
| |
| |
| Exam Objectives Summary | |
| |
| |
| Getting More Help | |
| |
| |
| |
| Developing a Logical Data Model | |
| |
| |
| Tested Skills and Suggested Practices | |
| |
| |
| Further Reading | |
| |
| |
| |
| Define entities | |
| |
| |
| |
| Design entity keys | |
| |
| |
| |
| Design attribute domain integrity | |
| |
| |
| |
| Implementing the Physical Database | |
| |
| |
| Tested Skills and Suggested Practices | |
| |
| |
| Further Reading | |
| |
| |
| |
| Create and alter databases | |
| |
| |
| |
| Create and alter database objects | |
| |
| |
| |
| Alter database objects to support replication and partitioned views | |
| |
| |
| |
| Troubleshoot failed object creation | |
| |
| |
| |
| Retrieving and Modifying Data | |
| |
| |
| Tested Skills and Suggested Practices | |
| |
| |
| Further Reading | |
| |
| |
| |
| Import and export data | |
| |
| |
| |
| Manipulate heterogeneous data | |
| |
| |
| |
| Retrieve, filter, group, summarize, and modify data by using Transact-SQL | |
| |
| |
| |
| Manage result sets by using cursors and Transact-SQL | |
| |
| |
| |
| Extract data in XML format | |
| |
| |
| |
| Programming Business Logic | |
| |
| |
| Tested Skills and Suggested Practices | |
| |
| |
| Further Reading | |
| |
| |
| |
| Manage data manipulation by using stored procedures, transactions, triggers, user-defined functions, and views | |
| |
| |
| |
| Enforce procedural business logic by using stored procedures, transactions, triggers, user-defined functions, and views | |
| |
| |
| |
| Troubleshoot and optimize programming objects | |
| |
| |
| |
| Tuning and Optimizing Data Access | |
| |
| |
| Tested Skills and Suggested Practices | |
| |
| |
| Further Reading | |
| |
| |
| |
| Analyze the query execution plan | |
| |
| |
| |
| Capture, analyze, and replay SQL Profiler traces | |
| |
| |
| |
| Create and implement indexing strategies | |
| |
| |
| |
| Improve index use by using the Index Tuning Wizard | |
| |
| |
| |
| Monitor and troubleshoot database activity by using SQL Profiler | |
| |
| |
| |
| Designing a Database Security Plan | |
| |
| |
| Tested Skills and Suggested Practices | |
| |
| |
| Further Reading | |
| |
| |
| |
| Control data access by using stored procedures, triggers, user-defined functions, and views | |
| |
| |
| |
| Define object-level security including column-level permissions by using GRANT, REVOKE, and DENY | |
| |
| |
| |
| Create and manage application roles | |
| |
| |
| Glossary | |
| |
| |
| Index | |