Installing, Configuring, and Administering SQL Server 2000 Outline:

(70-228)

Videos: 52
Demonstrations: 46
Simulations: 41
Fact Sheets: 74
Exam Questions: 171
Exams: 34

1.0 SQL Server Introduction

1.1 SQL Server Overview

1.1.1 Course Introduction
1.1.2 SQL Server Overview
1.1.3 Relational Database Concepts
1.1.4 SQL Server Editions

1.2 Management Tools

1.2.1 SQL Management Tools
1.2.2 Using Management Tools
1.2.3 Registering Servers
1.2.4 Manually Register a Server
1.2.5 SQL Tool Facts

1.3 SQL Databases and Objects

1.3.1 SQL Server Databases
1.3.2 SQL Database and Object Facts
1.3.3 Datatypes
1.3.4 Datatype Facts

1.4 Transact-SQL Overview

1.4.1 Building Queries
1.4.2 SQL Server Objects
1.4.3 Referencing SQL Objects
1.4.4 Identifier Facts
1.4.5 Batch Facts
1.4.6 Using Stored Procedures

1.5 SQL Server Components

1.5.1 SQL Services
1.5.2 SQL Services Facts
1.5.3 Database Files
1.5.4 File Groups
1.5.5 Database Structure Facts
1.5.6 System Tables
1.5.7 Querying System Tables
1.5.8 System Table Facts

2.0 Installation (13 questions)

2.1 Preparation

2.1.1 Multiple Instances
2.1.2 Service Accounts
2.1.3 Authentication Modes
2.1.4 Collations and Sort Rules
2.1.5 Network Libraries
2.1.6 Installation Methods
2.1.7 Installation Preparation Facts
2.1.8 ExamSim Questions - Section 2.1

2.2 Installation

2.2.1 Installing SQL
2.2.2 Installing a Named Instance
2.2.3 Verify Installation
2.2.4 Viewing Installation Results
2.2.5 Preparing for Installation
2.2.6 Unattended Installation Facts
2.2.7 Troubleshooting Installation
2.2.8 ExamSim Questions - Section 2.2

2.3 Upgrade and Coexistence

2.3.1 Upgrade Options
2.3.2 Upgrade and Coexistence Facts
2.3.3 ExamSim Questions - Section 2.3

3.0 Server Management (8 questions)

3.1 Services

3.1.1 Managing Services
3.1.2 Services Facts
3.1.3 Manage Services
3.1.4 ExamSim Questions - Section 3.1

3.2 Server Options

3.2.1 Configuring Server Options
3.2.2 Configure Server Properties
3.2.3 Set Login and Query Timeout

3.3 Net-Libraries

3.3.1 Configuring Net-Libraries
3.3.2 Net-Library Facts
3.3.3 Manage Server Protocols
3.3.4 Configure Protocol Encryption
3.3.5 ExamSim Questions - Section 3.3

4.0 Databases and Objects (15 questions)

4.1 Databases

4.1.1 Creating Databases with the Wizard
4.1.2 Creating Databases with Enterprise Manager
4.1.3 Create a Database
4.1.4 Creating Databases Using Scripts
4.1.5 Create Database
4.1.6 Creating Databases with Transact-SQL
4.1.7 Create Database Facts

4.2 Tables

4.2.1 Tables
4.2.2 Altering Tables
4.2.3 Creating Tables
4.2.4 Table Facts

4.3 Constraints and Triggers

4.3.1 Constraints
4.3.2 Creating Constraints
4.3.3 Creating Constraints
4.3.4 Constraint Facts
4.3.5 Triggers
4.3.6 Creating Triggers
4.3.7 Trigger Facts
4.3.8 ExamSim Questions - Section 4.3

4.4 Indexes

4.4.1 Indexes
4.4.2 Index Tuning Wizard
4.4.3 Creating Indexes
4.4.4 Index Facts

4.5 Views and Stored Procedures

4.5.1 Views
4.5.2 Creating Views
4.5.3 View Facts
4.5.4 Stored Procedures
4.5.5 Creating Stored Procedures
4.5.6 Stored Procedure Facts

4.6 Database File Management

4.6.1 Alter Database
4.6.2 Modifying Database Options
4.6.3 Modify Database Properties
4.6.4 Shrinking Datafiles
4.6.5 File Management Facts
4.6.6 Multiple Filegroups
4.6.7 Working with File Groups
4.6.8 Filegroup Facts
4.6.9 Create a Filegroup
4.6.10 ExamSim Questions - Section 4.6

4.7 Database and Table Modifications

4.7.1 Database Properties
4.7.2 Schema Modifications
4.7.3 Collation Facts
4.7.4 ExamSim Questions - Section 4.7

5.0 Security (36 questions)

5.1 SQL Security Concepts

5.1.1 SQL Security Concepts

5.2 Authentication Modes

5.2.1 Authentication Modes Facts
5.2.2 Configuring the Authentication Mode
5.2.3 Change the Authentication Mode
5.2.4 ExamSim Questions - Section 5.2

5.3 Logins and Users

5.3.1 SQL Server Logins
5.3.2 Creating SQL Logins
5.3.3 Create Login Accounts
5.3.4 Database Users
5.3.5 Granting Database Access
5.3.6 Deny Database Access
5.3.7 Login and User Operations
5.3.8 ExamSim Questions - Section 5.3

5.4 Roles

5.4.1 Roles
5.4.2 Role Procedures
5.4.3 Managing Roles
5.4.4 Role Facts
5.4.5 Role Operations
5.4.6 Assign Server Roles
5.4.7 Assign Database Roles
5.4.8 ExamSim Questions - Section 5.4

5.5 Permissions

5.5.1 Permissions
5.5.2 View and Stored Procedure Permissions
5.5.3 Managing Permissions
5.5.4 Permission Facts
5.5.5 Set Database Permissions
5.5.6 Set Permissions on a View
5.5.7 Set Permissions on a Stored Procedure
5.5.8 Deny Server Access
5.5.9 Configure Database Access
5.5.10 ExamSim Questions - Section 5.5

6.0 Data Access (33 questions)

6.1 Linked Servers

6.1.1 Linked Server Definitions
6.1.2 Managing Linked Servers
6.1.3 Linked Server Facts
6.1.4 Managing OLE DB Datasources
6.1.5 Managing Security Mappings
6.1.6 Create a Linked Server 1
6.1.7 Create a Linked Server 2
6.1.8 Create a Linked Server 3
6.1.9 Create a Linked Server 4
6.1.10 ExamSim Questions - Section 6.1

6.2 IIS Integration

6.2.1 Configuing IIS for SQL Support
6.2.2 IIS Support Facts
6.2.3 Accessing Data with HTTP
6.2.4 ExamSim Questions - Section 6.2

6.3 Data Import and Export

6.3.1 Import and Export Data
6.3.2 Using the DTS Import/Export Wizard
6.3.3 Creating a DTS Package
6.3.4 DTS Facts
6.3.5 Managing DTS Packages
6.3.6 BCP Facts
6.3.7 ExamSim Questions - Section 6.3

6.4 Replication

6.4.1 SQL Server Replication
6.4.2 Replication Facts
6.4.3 Configuring Replication
6.4.4 Using Merge Replication
6.4.5 Replication Configuration Facts
6.4.6 Configure a Publisher
6.4.7 Create a Push Subscription
6.4.8 Configure Merge Replication
6.4.9 Remove a Subscriber
6.4.10 ExamSim Questions - Section 6.4

6.5 Data Access Methods

6.5.1 Moving Databases
6.5.2 Data Access Tools
6.5.3 ExamSim Questions - Section 6.5

7.0 Protection and Availability (10 questions)

7.1 Planning

7.1.1 Recovery Models
7.1.2 Database Backup
7.1.3 Backup Considerations
7.1.4 Backup and Recovery Planning Facts
7.1.5 ExamSim Questions - Section 7.1

7.2 Backup

7.2.1 Backup
7.2.2 Backing Up Databases
7.2.3 Backing Up Filegroups
7.2.4 Backup Facts
7.2.5 Backup Operations
7.2.6 Create Backup Devices
7.2.7 Perform an Immediate Backup
7.2.8 Implement a Backup Strategy 1
7.2.9 Implement a Backup Strategy 2
7.2.10 Implement a Filegroup Backup
7.2.11 Change the Recovery Model 1
7.2.12 Change the Recovery Model 2
7.2.13 ExamSim Questions - Section 7.2

7.3 Recovery

7.3.1 Recover a User Database
7.3.2 Recover a System Database
7.3.3 Recovering Databases
7.3.4 Recovery Facts
7.3.5 Recovery Operations
7.3.6 Perform a Simple Recovery
7.3.7 Perform a Full Recovery
7.3.8 Restore to a Point-in-Time
7.3.9 ExamSim Questions - Section 7.3

7.4 Standby Servers

7.4.1 Log Shipping
7.4.2 Standby Server Facts
7.4.3 ExamSim Questions - Section 7.4

7.5 Clustering

7.5.1 Clustering
7.5.2 Windows Clustering Facts
7.5.3 SQL Clustering Facts
7.5.4 Configuring SQL Clustering
7.5.5 ExamSim Questions - Section 7.5

8.0 Performance and Management (56 questions)

8.1 System Monitoring

8.1.1 System Monitoring
8.1.2 Monitoring Tools
8.1.3 Using SQL Profiler
8.1.4 Using System Monitor
8.1.5 Server Optimization Facts
8.1.6 Security Auditing Facts
8.1.7 ExamSim Questions - Section 8.1

8.2 Database Optimization

8.2.1 Database Optimization
8.2.2 Query Optimization
8.2.3 Fragmentation
8.2.4 Managing Fragmentation
8.2.5 Maintenance Plan Facts
8.2.6 ExamSim Questions - Section 8.2

8.3 Mail Support

8.3.1 Mail Support
8.3.2 Configuring Mail Support
8.3.3 Mail Support Facts
8.3.4 Configure Mail Support
8.3.5 ExamSim Questions - Section 8.3

8.4 Jobs and Alerts

8.4.1 Jobs and Alerts
8.4.2 Jobs and Alerts Facts
8.4.3 Configuring Alerts
8.4.4 Managing SQL Server Agent Jobs
8.4.5 Create an Operator
8.4.6 Create and Start Jobs
8.4.7 Create an Alert
8.4.8 Multi-target TSX Jobs
8.4.9 Multiserver Job Facts
8.4.10 ExamSim Questions - Section 8.4

8.5 Transactions and Locking

8.5.1 Transactions and Locking
8.5.2 SQL Server Activity Window
8.5.3 Troubleshooting Locking
8.5.4 Locks and Deadlocking Facts
8.5.5 Locking Troubleshooting Facts
8.5.6 Optimizing Applications
8.5.7 ExamSim Questions - Section 8.5

ExamSim (216 questions)

Preparing for Certification

Exam Objectives
Exam FAQs
How to Register for an Exam
Exam-taking Hints and Tips

Objective 100, All Questions
Objective 200, All Questions
Objective 300, All Questions
Objective 400, All Questions
Objective 500, All Questions
Objective 600, All Questions
Typical Exam