QuickCert's 70-229 course provides students with the knowledge and skills that are needed to administer and troubleshoot information systems that incorporate Microsoft SQL Server™ 2000 Enterprise Edition. When you pass the Designing and Implementing Databases with Microsoft SQL Server 2000 exam, you achieve Microsoft Certified Professional (MCP) status.
Developing a Logical Data Model |
Define entities
Specify entity attributes |
Specify degree of normalization |
|
Design entity keys
Specify attributes that uniquely identify records |
Specify attributes that reference other entities |
|
Design attribute domain integrity
Specify scale and precision of allowable values for each attribute |
Allow or prohibit NULL for each attribute |
Specify allowable values for each attribute |
|
Implementing the Physical Database |
Create and alter databases
Specify space management parameters |
Specify file group and file placement |
Specify transaction log placement |
|
Create and alter database objects
Specify table characteristics |
Specify schema binding and encryption for stored procedures, triggers, user-defined functions, and views |
Specify recompile settings for stored procedures |
Specify index characteristics |
|
Alter database objects to support replication and partitioned views
Support merge, snapshot, and transactional replication models |
Design a partitioning strategy |
Design and create constraints and views |
Resolve replication conflicts |
|
Troubleshoot failed object creation |
Retrieving and Modifying Data |
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 |
Manage data manipulation by using stored procedures, transactions, triggers, user-defined functions, and views
Implement error handling in stored procedures, transactions, triggers, and user-defined functions |
Pass and return parameters to and from stored procedures and user-defined functions |
Validate data |
|
Enforce procedural business logic by using stored procedures, transactions, triggers, user-defined functions, and views
Specify trigger actions |
Design and manage transactions |
Manage control of flow |
Filter data by using stored procedures, triggers, user-defined functions, and views |
|
Troubleshoot and optimize programming objects |
Tuning and Optimizing Data Access |
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 |
Control data access by using stored procedures, triggers, user-defined functions, and views
Apply ownership chains |
Use programming logic and objects |
|
Define object-level security including column-level permissions by using GRANT, REVOKE, and DENY |
Create and manage application roles |