MCITP Administrator: Microsoft SQL Server 2005 Database Server Infrastructure Design Study

0-470-04744-5 Instructor Materials

MCITP Administrator: Microsoft SQL Server 2005 Database Server Infrastructure Design Study Guide (70-443)

Introduction

Dear Instructor:

The purpose of this letter is to give you a perspective, from one trainer to another, on how to use these materials in your delivery of a course on Microsoft SQL Server 2005. First, as instructors, we realize that teaching is tough work, and SQL Server 2005 is a genuinely vast subject to teach. The following materials have been assembled to assist your course delivery.

The Book: There are fourteen chapters of solid material covering many aspects of SQL Server 2005 administration. It includes chapter review questions and in-chapter exercises.

PowerPoint Slides: We average 20-30 slides per chapter, enough to cover the main content. Feel free to modify these slides in any way that improves the delivery of your class.

Review Questions with Answers: Each chapter in the book already has 10-20 review questions, and we’ve added another 100-question bonus exam with this ancillary package. These questions have been written to highlight main points, as well as other subtle but noteworthy points that are often the subject of certification exam questions. These questions will make a good review at the beginning of the day’s class to verify that the students understood what was covered during the previous session. You will notice that many of the chapters use case studies for the basis of questions, whereas others are typical questions, depending on the content.

Practical Examples/Labs: Every chapter in the book contains several excellent examples to demonstrate the points made in the chapter. Some labs overlap what the book’s authors created and some don’t. As in the review questions, we have highlighted some interesting points outside of the primary focus in each chapter. These items, if used, will provide a more comprehensive understanding of each subject. Some of the labs may require the completion of certain exercises from the text, so you will want to be intimately familiar with the system changes introduced by each exercise in the book, in addition to our own exercises. As always, it is highly recommended that you run through the labs yourself before class so that you’re familiar with their subtleties before the session begins.

Syllabi: You have also been provided a syllabus for a short course (3–6 days) and for a long course (12–15 weeks). These will give a structure to the flow of the course material—however these schedules often change “on the fly,” and you’ll need to adapt any class to students’ needs.

Prerequisites: Before beginning class, ensure that all your students are familiar with basic database theory (e.g. what a database is what a table is, etc.), basic computer networking fundamentals, and can successfully use a graphical user interface to operate a computer. Lack of any of these skills will dramatically slow down absorption of material by that student, and will absolutely frustrate the advanced students who are attending your class.

LAB SETUP DETAILS For SQL Server 2005:

Component / Requirement
Computer and processor / 600-MHz processor required; 1-GHz recommended; up to eight processors supported on one server
Memory / 512 MB of RAM minimum required; 1 GB or more recommended; 64 GB maximum
Hard disk / 425MB of available hard disk space
Drive / CD-ROM or DVD-ROM drive
Display / VGA or hardware that supports console redirection required; Super VGA supporting 800 x 600 or higher-resolution monitor recommended
Operating System / Microsoft Windows 2000 Server with SP4 or newer; Windows 2000 Professional Edition with SP4 or newer; Windows XP with SP2 or newer; Windows Server 2003 Enterprise Edition, Standard Edition, or Datacenter Edition with SP1 or newer; Windows Small Business Server 2003 with SP1 or newer

Last, but not least, Microsoft SQL Server 2005 is a fun subject to teach, so have fun in class. Your students likely already know some of the basics of the subject, and they are eager to learn more, so be ready to share what you know. This technology is really exciting, and your enthusiasm for your subject will rub off on your students. We wish you the best in all your teaching endeavors.