70-229 Certification Links

Certifications
Microsoft

Microsoft 70-229 Exam
In the exam you will learn about MS SQL 2000 Enterprise Edition. You should have sufficient practical knowledge in Relational Databases. This exam is critical for achieving MCP status. On successful completion you should be able to develop logical data model, implement physical database, managing Data, Business logic and database security plan designing.

Microsoft 70-229 Certification Links

Home - Microsoft - 70-229

Chapter 1: Developing a Logical Data Model (20 links)
- Learn basics of Data Types and Table Structures - Learn basics of Data Types and Table Structures
- Learn about reseeding a value in SQL - Detailed description on reseeding a value in SQL
- More reading on NULL Values - More reading on NULL Values
- more...
Chapter 2: Implementing the Physical Database (21 links)
- Learn about Troubleshooting Failed Object Creation - A brief article on Troubleshooting Failed Object Creation
- Learn about how to Merge Replication Conflict Detection and Resolution - Learn about how to Merge Replication Conflict Detection and Resolution
- Learn how to Create view - A brief description on how to Create view
- more...
Chapter 3: Retrieving and Modifying Data (16 links)
- A Quick guide on Understanding XML in SQL Server - A Quick guide on Understanding XML in SQL Server
- Learn about Retrieving Data as XML from SQL Server - A guide on Retrieving Data as XML from SQL Server
- Learn how to extract data from XML documents - Brief description on how to extract data from XML documents
- more...
Chapter 4: Programming Business Logic (18 links)
- Article on how to manage transactions - Article on how to manage transactions
- Learn about SQL Server Triggers - Brief description of SQL Server Triggers
- Learn about Data Validation SQL Server - Brief description of Data Validation SQL Server
- more...
Chapter 5: Tuning and Optimizing Data Access (16 links)
- How to Monitor and troubleshoot database activity by using SQL Profiler - Detailed account on how to Monitor and troubleshoot database activity by using SQL Profiler
- Common issues on SQL Server Index Tuning - Common issues on SQL Server Index Tuning
- More on SQL Server Index Tuning Wizard - More on SQL Server Index Tuning Wizard
- more...
Chapter 6: Designing a Database Security Plan (11 links)
- More on Application roles making SQL Server Secure - More on Application roles making SQL Server Secure
- Different aspects of Application Roles in SQL Server Security - Article on Application Roles in SQL Server Security
- Learn about Application roles in SQL Server 2000 Security - Find out about application roles in SQL Server 2000 Security
- more...