PowerPoint Slides
The CD-ROM that accompanied this manual contains a number of slides that may be useful for presenting the material. Check the PPT directory on the CD for a presentation file named 03DesignIM.ppt that contains the following Chapter 3 slides:
|
Slide |
Slide Name |
Use |
|
3-1 |
Chapter Title |
This is a title slide that you can use to introduce the subject of this chapter. |
|
3-2 |
Module Objectives |
Use this slide to give an overview of what your students will be learning in this chapter. |
|
3-3 |
Study Strategies |
This is a brief synopsis of the references mentioned in the Training Guide as ways for students to increase their understanding and knowledge of the material in this chapter. |
|
3-4 |
Creating and Altering Databases |
Overview slide for the first section of the chapter. There are four parts to this section. Use this slide to give a brief overview of what is covered in the "Creating and Altering Database" section of the Training Guide. |
|
3-5 |
Creating Database Files |
This slide provides talking points regarding the creation of databases, and leads the topic through the material in the Training Guide regarding this part of the first section. |
|
3-6 |
Create Database Syntax |
This slide provides the most common syntax for creating a database. Although some examples are in the Training Guide for creating a database, none include all of the most common options. |
|
3-7 |
A Common Implementation |
This slide illustrates the most common usage of TSQL to create a database, identifying where to place the primary and log. In this situation a primary file called "Datastore" will be placed on drive d://, and the log file, called "Logstore", will be placed on drive e://. |
|
3-8 |
Using Filegroups |
This slide provides talking points in regard to the use of file groups, and leads your discussion through the material in the Training Guide regarding this part of the first section. |
|
3-9 |
Creating Filegroups |
This slide shows the syntax for creating three file groups, called "Primary", "Group1", and "Group2". The Primary group contains the file Data1. Group1 contains one file, G1Dat1, while Group2 contains two files, G2Dat1 and G2Dat2. This slide has a lot of information on it. For this reason it has been broken up into five sections, in an animation, so that you can explain each part of the code separately to give a clear understanding of how to create different file groups for different types of files. |
|
3-10 |
Creating and Altering Database Objects |
This is an overview slide of the second section of this chapter. Use it as a means of briefly describing the material that will be covered in this section. |
|
3-11 |
Table Characteristics |
This is an overview slide for this section of the Training Guide. A lot of material is covered in this section, so give a brief overview to the students to introduce the importance of understanding the concepts in this section, and what will be covered. |
|
3-12 |
Index Organization |
This slide is Figure 3.4 in the Training Guide under "Index Organization," and illustrates the B-Tree structure used for index storage. Identify for students the differences between how a clustered and non-clustered index are stored, and how this affects their leaf, intermediate, and root pages. |
|
3-13 |
Exam Tip: |
Cascading Actions is a new feature—and this tip focuses on your students' need to understand the ramifications of this feature. |
|
3-14 |
Exam Tip: |
SCHEMA BINDING is likely to be covered in the exam—so, ensure that your students understand the context in which the word "schema" is used in relationship to SQL Server 2000. |
|
3-15 |
Exam Tip: |
Indexed Views require certain options to be set in order to work. Emphasize to students that while this will be covered in Chapter 7, they will need to pay close attention to details in the course. |
|
3-16 |
Referential Integrity |
This slide is Figure 3.7 in the Training Guide. The slide illustrates the relationship between Primary and Foreign keys. Use this slide to address the various scenarios that can happen to data—modification, deletion of primary key, and addition or modification of foreign key. |
|
3-17 |
Integrity Maintenance Objects |
This slide is Table 3.1 in the Training Guide. While covering the various Integrity Maintenance Objects, you can use this slide to bring it all together. Compare and contrast the use of these various objects. These concepts are extremely important for the exam. |
|
3-18 |
Replication |
Replication will more fully be covered in Chapter 11, "Implementing and Understanding Replication Metho-dologies," so use this slide for talking points regarding the three types of replication, and give an overview of why each might be used. |
|
3-19 |
Creating Table Constraints |
This slide contains the example code in step by step 3.7. Use it to review the syntax for creating constraints on tables. |
|
3-20 |
Troubleshooting SQL Server Objects |
This is an overview slide for the last section of this chap ter, and can be used for talking about the two main parts of the section: configuring SQL Server settings, and configuring Database settings. |
|
3-22 thru |
Exam Questions & Answers |
The rest of this chapter's slide deck is designed with 3-41 questions of a difficulty level comparable to what your students will face on the SQL Server 2000 Design exam. The first slide (and in some cases two) will present a problem and some potential solutions, requesting the student to identify the "best" answer, or a strategy for solving the problem. The second (or third) slide will present first the answer, and then an explanation regarding why the answer is truly the best of the options provided. |