Design tests are always tricky and require some experience. There is not a whole lot you can do to prepare for this test other than have the experience with SQL Server 2000. So, in order to practice, you should think up an application requirement, design a database, and play with it using Enterprise Manager and Transact-SQL. And, you must not forget to check out the new features of SQL Server 2000. You can also do the following to practice the 70-229 test:

  1. Install and uninstall SQL Server 2000.
  2. Create a database, tables, primary keys, foreign keys, indexes, views, triggers, stored procedures, and functions.
  3. Insert, update, and delete data using Transact-SQL statements
  4. Continue reading

Pasan is a Software Engineer at AKLO Information Technologies (Pvt.) Ltd, a Colombo based financial services solution provider. He has experience in developing software in c#.net.

Pasan holds a Special Honours Degree in Information Technology from Sri Lanka Institute of Information Technology(SLIIT). He has been an MCP since 2006 and currently holds the Microsoft Certified Solution Developer.NET title.

Pasan reivewed the uCertify 70-229 practice test, which provides credit towards MCAD, MCDBA, MCSD.NET, MCSA, and MCSE certifications. Continue reading