Exam 70-229:
Designing and Implementing Databases with Microsoft SQL Server 2000
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. 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 Certified Partner, QuickCert follows the approved Microsoft course curriculum, ensuring you receive the training and knowledge needed to succeed. QuickCert is so certain this course meets and exceeds the exam objectives, we guarantee you will pass your exam!
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
For More Information E-Mail us at sales@quickcert.com
or call us at 1.888.840.2378
GET IN THE LEAD —
get certified today!
Experience the benefits of classroom learning - anytime, anywhere! QuickCert's expert instruction and multi-media courseware is guaranteed to get you certified- or your money back!
YOUR TRAINING PACKAGE INCLUDES:
Instructor-Led Training
Demos and Lab Learning
Multi-Media Presentations
Practice Exams and Test Simulators
Self-Paced Navigation
Multi-Media Presentations
CD-ROM or Online Delivery
Toll Free Educational Support
Money-Back Guarantee
Compatibility with NT | 95 | 98 | 2000 | ME | XP | Win 2003 server