Microsoft Certified Systems Engineer
Microsoft Certified Database Administrator
Microsoft Certified Systems Administrator
Microsoft Office User Specialist
CompTIA Certification for PC Hardware with Windows Specialty
CompTIA Certification for Computer Networking
CompTIA Certification for Internet Specialists
CompTIA Linux+ Certification
CompTIA Certified Document Imaging Architect
Cisco Certified Network Associate
Video Training Series
Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition 70-229
Candidates for this exam operate in medium to very large computing environments that use Microsoft SQL Server 2000 Enterprise Edition. Candidates have at least one year of experience administering SQL Server. They also have at least one year of experience implementing relational databases in environments that contain:
Skills Being Measured
This certification exam measures your ability to administer and troubleshoot information systems that incorporate Microsoft SQL Server 2000 Enterprise Edition. Before taking the exam, you should be proficient in the job skills listed below.
Developing a Logical Data Model
Define entities. Considerations include entity composition and normalization.
Design entity keys. Considerations include FOREIGN KEY constraints, PRIMARY KEY constraints, and UNIQUE constraints.
Design attribute domain integrity. Considerations include CHECK constraints, data types, and nullability.
Implementing the Physical Database
Create and alter databases. Considerations include file groups, file placement, growth strategy, and space requirements.
Create and alter database objects. Objects include constraints, indexes, stored procedures, tables, triggers, user-defined functions, and views.
Alter database objects to support replication and partitioned views.
Troubleshoot failed object creation
Retrieving and Modifying Data
Import and export data. Methods include the bulk copy program, the Bulk Insert task, and Data Transformation Services (DTS).
Manipulate heterogeneous data. Methods include linked servers, OPENQUERY, OPENROWSET, and OPENXML.
Retrieve, filter, group, summarize, and modify data by using Transact-SQL.
Manage result sets by using cursors and Transact-SQL. Considerations include locking models and appropriate usage.
Extract data in XML format. Considerations include output format and XML schema structure.
Programming Business Logic
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. Objects include stored procedures, transactions, triggers, user-defined functions, and views.
Tuning and Optimizing Data Access
Analyze the query execution plan. Considerations include query processor operations and steps.
Capture, analyze, and replay SQL Profiler traces. Considerations include lock detection, performance tuning, and trace flags.
Create and implement indexing strategies. Considerations include clustered index, covering index, indexed views, nonclustered index, placement, and statistics.
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.
Define object-level security including column-level permissions by using GRANT, REVOKE, and DENY.
Create and manage application roles.
Our dynamic training program includes:
Price and Ordering