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