CertForums 70-228 & 70-229 Forum FAQ Page

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Welcome to the CertForums 70-228 & 70-229 Forum FAQ Page

What is the purpose of this forum ?
This forum is designed to discuss any issue related to the Microsoft 70-228 and 70-229 exams.

What Areas do these exams cover ?
70-228 and 70-229 Cover designing, installing, configuring and administering Microsoft SQL 2000 servers in an enterprise environment.

So what is a Microsoft SQL 2000 Server ?
SQL Server 2000 is a family of products designed to meet the data storage requirements of a wide variety of people from individuals and small businesses to large data processing systems and commercial Web sites. At its core, SQL Server 2000 provides two fundamental services. The first service is the SQL Server service, which is a high-performance, highly scalable relational database engine. The second service is SQL Server 2000 Analysis Services, which provides tools for analyzing the data stored in data warehouses for decision support.

Who are these exams aimed at ?
They are aimed at people who already work as Database Administrators (DBA's) in a Microsoft SQL 2000 server environment who are seeking to become MCDBA certified.

What sort of topics are appropriate for this forum ?
Any aspect of designing, installing, configuring and administering Microsoft SQL 2000 servers especially any topic covered by the 70-228 and 70-229 exams. If you have questions regarding other database products such as Oracle or MySql you may be better posting them in the Software or Programming, Scripting & Web Design forums.

What if no-one answers my question ?
Hopefully someone on the forum will always be able to help, but in those instances when you receive no response in a timely manner, please direct your comments to the forum moderator or the site administrator. Also, please keep in mind that, if your question is quite involved, it may take a bit of research on a responder's part before they can provide any assistance. Please try to be patient.

How detailed should my question be ?
The more detail, the better. Very often, it is difficult to respond meaningfully to a question if not enough detail is included. Sometimes, of course, it can be hard to know how much detail to include in an initial question and, in that event, responders may ask you to clarify certain points.

What Qualifications do the exams count towards ?
Both exams count toward
Microsoft Certified Professional
Core credits for Microsoft Certified Database Administrator on Microsoft SQL Server 2000
Elective credits for Microsoft Certified Systems Engineer on Microsoft Windows 2000
Elective credits for Microsoft Certified Systems Engineer on Microsoft Windows NT 4.0

70-228 Counts toward
Elective credit for Microsoft Certified Systems Administrator on Microsoft Windows 2000

70-229 Counts toward
Elective credit for Microsoft Certified Solution Developer for Microsoft .NET
Elective credit for Microsoft Certified Solution Developer
Elective credit for Microsoft Certified Application Developer for Microsoft .NET


Are there any Microsoft courses for these exams ?
Yes there are 3 covering various aspects of the exams
Course 2071: Querying Microsoft SQL Server 2000 with Transact-SQL
Course 2072: Administering a Microsoft SQL Server 2000 Database
Course 2073: Programming a Microsoft SQL Server 2000 Database


Where can I find further information on these exams ?
You can find more details of the exam requirements in the official Microsoft preparation guides, they can be found here for 70-228 and here for 70-229, if you are considering studying for these exams, they should be your next stop as they have a complete list of the skills being measured. CertForums has a separate Resources page with links to web pages we’ve found particularly helpful as tutorials and information providers. Also, a member may suggest a particular website to you as part of their response to your question.

Are there any books for self studying the 70-228 and 70-229 exams ?

MCSE SQL Server 2000 System Administration Training Kit
Microsoft Press International
ISBN: 0735619611

Learn how to install, configure, and administer SQL Server 2000--as you prepare for MCP Exam 70-228, a core requirement for MCDBA certification and an elective for the MCSE and MCSA tracks.




Microft SQL Server 2000: Readiness Review (MCSE: Exam 70-22
Microsoft Press International
ISBN: 0735612501

Microsoft Certified Professional (MCP) Exam 70-228 measures ability to install, configure, and administer SQL Server 2000 Enterprise Edition. With READINESS REVIEW, certification candidates can sharpen their test-taking skills, save valuable time and money, and build their confidence for the real exam with the help of this exclusive MCP exam simulation on CD-ROM.


MCSA/MCSE/MCDBA: SQL Server 2000 Administration Study Guide
Sybex International
ISBN: 0782142788

Here's the book you need to prepare for Exam 70-228, Installing, Configuring, and Administering Microsoft SQL Server 2000. This Study Guide provides: In-depth coverage of every official exam objective Practical information on installing, configuring, and administering SQL Server 2000 Real-world insights, advice, and recommendations Hundreds of challenging practice questions, in the book and on the CD Leading-edge exam preparation software


MCSE SQL 2000 Administration (Exam Cram)
Coriolis Group
ISBN: 1588800334

The MCSE SQL 2000 Administration Exam Cram is the premier test preparation title for candidates choosing to take the elective "Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition" exam (70-22. Covers vital exam topics such as creating and managing SQL Server 2000 Databases, performing disaster recovery, troubleshooting Integrity Checks, extracting and transforming data, and SQL Server 2000 Security. Candidates can also complete their total exam preparation with insightful test taking strategies, helpful hints and tips, and realistic case studies and practice questions.


MCSE Training Kit: SQL Server 2000 Database Design and Implementation
Microsoft Press International
ISBN: 0735619603

Learn how to design and implement database solutions using SQL Server 2000 Enterprise Edition--as you prepare for MCP Exam 70-229, a core requirement for MCDBA certification and an elective for the MCAD, MCSE, and MCSA tracks.




MCSE: SQL Server 2000 Design Study Guide
Sybex International
ISBN: 0782129420

Full coverage of all the information you need to not only pass the MCSE SQL Server 2000 Design exam, but also all the knowledge you need as a system administrator in the real world. --Content mirrors the Microsoft objectives, and includes an assessment exam to get you started, review questions at the end of every chapter, and a practice exam at the end to test your skill. --CD includes all chapter exams, the practice exam, a bonus exam, and a searchable electronic version of the book


MCSE SQL Design Exam Crammer
Coriolis Group
ISBN: 1588800342

The MCSE SQL 2000 Database Design Exam Cram is the ideal study aid for IT professionals aiming at the "Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition" exam (70-229). Essential exam objectives like Logical Data Modeling, Database Objects, Data Integrity, XML, and Tuning and Optimizing Data Access are thoroughly covered. Readers can also complete their total exam preparation with insightful test taking strategies, helpful hints and tips, and realistic case studies and practice questions.