GET IN THE LEAD - get certified today! Experience the benefits of classroom learning - anytime, anywhere! QuickCert's expert instruction and multi-media courses are to get you certified - or your money back! Read why successful professionals choose QuickCert >

 

QuickCert's 70-228 course provides students with the knowledge and skills that are needed to  install, configure, and administer Microsoft's SQL Server.   When you pass the Installing, Configuring, and Administering Microsoft SQL Server exam, you achieve Microsoft Certified Professional (MCP) status.

For training on Microsoft SQL Server 2005, consider the MCITP Database Adminstrator or MCITP Database Developer Certifications.

* PLEASE NOTE: This course and exam were discontinued by Microsoft on March 31, 2009.  The exam date has been extended to May 31, 2009 for those already registered. Please see your nearest Prometric exam center for availability. QuickCert is offering this course for general training purposes only.

 

Not sure what course is right for you?
Contact one of our Career Advisors at 888.840.2378 for assistance.

Your QuickCert Microsoft Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Training Package:

Delivery Format	Instructor Led Modules	eBook	Practice Exam Simulator	Exam Pass Guarantee
DVDs or online

Exam Pass Guarantee - Learn More

Free Product Upgrades

Toll Free Educational Support

Compatibility with:
NT | 95 | 98 | 2000 | ME | XP | 2003| Vista | Windows 7

 

Hear What Our Customers Are Saying...

“I’m 100% satisfied with QuickCert’s training program. I love that it’s broken into manageable sections.   This is an all-inclusive training solution… they give you the manuals, the lectures broken into short segments, and practice tests that really mirror the actual tests I’ve taken. I plan to renew my membership!!”

— Karen S., Network Administrator, Calabasas, California

Questions?  Contact one of our Career Advisors at 888.840.2378 for assistance or email sales@quickcert.com.

Microsoft Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Course Curriculum:

 

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 object

Define object-level security including column-level permissions by using GRANT, REVOKE, and DENY

Create and manage application roles

 

Questions?  Contact one of our Career Advisors at 888.840.2378 for assistance or email sales@quickcert.com.

Free Demo