UCertifyOnline'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. You also earn credit toward the following certifications:

• Core credit toward Microsoft Certified Database Administrator (MCDBA) on Microsoft SQL Server 2000 certification
• Elective credit toward Microsoft Certified Systems Engineer (MCSE 2000) on Microsoft Windows 2000 certification
• Elective credit toward Microsoft Certified Systems Engineer (MCSE) on Microsoft Windows NT 4.0 certification
• Elective credit toward Microsoft Certified Solution Developer for (MCSD) Microsoft .NET certification
• Elective credit toward Microsoft Certified Solution Developer (MCAD) certification
• Elective credit toward Microsoft Certified Application Developer (MCAD) for Microsoft .NET certification

As a Microsoft IT Academy Program Member, UCertifyOnline follows the approved Microsoft course curriculum, ensuring you receive the training and knowledge needed to succeed.  UCertifyOnline is so certain this course meets and exceeds the exam objectives, we guarantee you will pass your exam!

 Course Duration: 3 Months

Learning segments

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