Installing, Configuring, and Administering SQL Server 2000 Enterprise Edition Training for Exam 70-228 - Course Outline

Estimated Time to Complete - 50 hours

 Lecture Videos: 52 Lessons (4 Hrs 39 Mins)
 Demonstration Videos: 46 Lessons (6 Hrs 8 Mins)
 Hands-on Labs: 41 Scenarios (Student lab activities)
 Fact Sheets: 74 (each with 1 or more printable pages)
 Exam Questions: 171 (each with answers and explanations)
 Exams: 34 Practice Tests (each with detailed reporting)

1.0 SQL Server Introduction

• 1.1 SQL Server Overview
  
   1.1.1 Course Introduction (0 Mins 35 Secs)
   1.1.2 SQL Server Overview (4 Mins 22 Secs)
   1.1.3 Relational Database Concepts
   1.1.4 SQL Server Editions
  
  1.2 Management Tools
  
   1.2.1 SQL Management Tools (2 Mins 05 Secs)
   1.2.2 Using Management Tools (6 Mins 52 Secs)
   1.2.3 Registering Servers (5 Mins 40 Secs)
   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 (2 Mins 45 Secs)
   1.3.2 SQL Database and Object Facts
   1.3.3 Datatypes (9 Mins 39 Secs)
   1.3.4 Datatype Facts
  
  1.4 Transact-SQL Overview
  
   1.4.1 Building Queries
   1.4.2 SQL Server Objects (2 Mins 13 Secs)
   1.4.3 Referencing SQL Objects (2 Mins 46 Secs)
   1.4.4 Identifier Facts
   1.4.5 Batch Facts
   1.4.6 Using Stored Procedures (4 Mins 34 Secs)
  
  1.5 SQL Server Components
  
   1.5.1 SQL Services (2 Mins 25 Secs)
   1.5.2 SQL Services Facts
   1.5.3 Database Files (5 Mins 36 Secs)
   1.5.4 File Groups (2 Mins 19 Secs)
   1.5.5 Database Structure Facts
   1.5.6 System Tables (2 Mins 14 Secs)
   1.5.7 Querying System Tables (8 Mins 37 Secs)
   1.5.8 System Table Facts

2.0 Installation (13 questions)

• 2.1 Preparation
  
   2.1.1 Multiple Instances (1 Min 14 Secs)
   2.1.2 Service Accounts (0 Mins 39 Secs)
   2.1.3 Authentication Modes (1 Min 22 Secs)
   2.1.4 Collations and Sort Rules (7 Mins 09 Secs)
   2.1.5 Network Libraries (2 Mins 18 Secs)
   2.1.6 Installation Methods (2 Mins 27 Secs)
   2.1.7 Installation Preparation Facts
   2.1.8 ExamSim Questions - Section 2.1
  
  2.2 Installation
  
   2.2.1 Installing SQL (7 Mins 37 Secs)
   2.2.2 Installing a Named Instance (1 Min 56 Secs)
   2.2.3 Verify Installation (1 Min 23 Secs)
   2.2.4 Viewing Installation Results (9 Mins 27 Secs)
   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 Mins 08 Secs)
   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 (4 Mins 40 Secs)
   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 (4 Mins 49 Secs)
   3.2.2 Configure Server Properties
   3.2.3 Set Login and Query Timeout
  
  3.3 Net-Libraries
  
   3.3.1 Configuring Net-Libraries (4 Mins 40 Secs)
   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 (3 Mins 02 Secs)
   4.1.2 Creating Databases with Enterprise Manager (1 Min 06 Secs)
   4.1.3 Create a Database
   4.1.4 Creating Databases Using Scripts (3 Mins 29 Secs)
   4.1.5 Create Database (3 Mins 42 Secs)
   4.1.6 Creating Databases with Transact-SQL (10 Mins 13 Secs)
   4.1.7 Create Database Facts
  
  4.2 Tables
  
   4.2.1 Tables (10 Mins 03 Secs)
   4.2.2 Altering Tables (2 Mins 22 Secs)
   4.2.3 Creating Tables (12 Mins 33 Secs)
   4.2.4 Table Facts
  
  4.3 Constraints and Triggers
  
   4.3.1 Constraints (6 Mins 18 Secs)
   4.3.2 Creating Constraints (17 Mins 46 Secs)
   4.3.3 Creating Constraints (23 Mins 29 Secs)
   4.3.4 Constraint Facts
   4.3.5 Triggers (10 Mins 50 Secs)
   4.3.6 Creating Triggers (17 Mins 22 Secs)
   4.3.7 Trigger Facts
   4.3.8 ExamSim Questions - Section 4.3
  
  4.4 Indexes
  
   4.4.1 Indexes (10 Mins 50 Secs)
   4.4.2 Index Tuning Wizard (2 Mins 18 Secs)
   4.4.3 Creating Indexes (14 Mins 53 Secs)
   4.4.4 Index Facts
  
  4.5 Views and Stored Procedures
  
   4.5.1 Views (11 Min 58 Secs)
   4.5.2 Creating Views (10 Mins 13 Secs)
   4.5.3 View Facts
   4.5.4 Stored Procedures (11 Min 47 Secs)
   4.5.5 Creating Stored Procedures (11 Min 19 Secs)
   4.5.6 Stored Procedure Facts
  
  4.6 Database File Management
  
   4.6.1 Alter Database (2 Mins 24 Secs)
   4.6.2 Modifying Database Options (6 Mins 23 Secs)
   4.6.3 Modify Database Properties
   4.6.4 Shrinking Datafiles (6 Mins 39 Secs)
   4.6.5 File Management Facts
   4.6.6 Multiple Filegroups (4 Mins 36 Secs)
   4.6.7 Working with File Groups (13 Mins 06 Secs)
   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 (4 Mins 20 Secs)
   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 (4 Mins 33 Secs)
   5.3.2 Creating SQL Logins (5 Mins 09 Secs)
   5.3.3 Create Login Accounts
   5.3.4 Database Users (5 Mins 48 Secs)
   5.3.5 Granting Database Access (5 Mins 51 Secs)
   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 (10 Mins 21 Secs)
   5.4.2 Role Procedures (6 Mins 35 Secs)
   5.4.3 Managing Roles (13 Mins 20 Secs)
   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 (4 Mins 15 Secs)
   5.5.2 View and Stored Procedure Permissions (1 Min 34 Secs)
   5.5.3 Managing Permissions (6 Mins 41 Secs)
   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 (4 Mins 38 Secs)
   6.1.2 Managing Linked Servers (10 Mins 36 Secs)
   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 (5 Mins 23 Secs)
   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 (5 Mins 30 Secs)
   6.3.2 Using the DTS Import/Export Wizard (6 Mins 52 Secs)
   6.3.3 Creating a DTS Package (15 Mins 34 Secs)
   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 (11 Min 16 Secs)
   6.4.2 Replication Facts
   6.4.3 Configuring Replication (12 Mins 40 Secs)
   6.4.4 Using Merge Replication (12 Mins 19 Secs)
   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 Mins 11 Secs)
   7.1.2 Database Backup (10 Mins 03 Secs)
   7.1.3 Backup Considerations (4 Mins 02 Secs)
   7.1.4 Backup and Recovery Planning Facts
   7.1.5 ExamSim Questions - Section 7.1
  
  7.2 Backup
  
   7.2.1 Backup (5 Mins 29 Secs)
   7.2.2 Backing Up Databases (15 Mins 51 Secs)
   7.2.3 Backing Up Filegroups (4 Mins 27 Secs)
   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 (12 Mins 32 Secs)
   7.3.2 Recover a System Database (2 Mins 35 Secs)
   7.3.3 Recovering Databases (17 Mins 49 Secs)
   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 (3 Mins 18 Secs)
   7.4.2 Standby Server Facts
   7.4.3 ExamSim Questions - Section 7.4
  
  7.5 Clustering
  
   7.5.1 Clustering (5 Mins 40 Secs)
   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 Mins 25 Secs)
   8.1.2 Monitoring Tools
   8.1.3 Using SQL Profiler (8 Mins 29 Secs)
   8.1.4 Using System Monitor (4 Mins 49 Secs)
   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 (3 Mins 12 Secs)
   8.2.4 Managing Fragmentation (9 Mins 29 Secs)
   8.2.5 Maintenance Plan Facts
   8.2.6 ExamSim Questions - Section 8.2
  
  8.3 Mail Support
  
   8.3.1 Mail Support (2 Mins 11 Secs)
   8.3.2 Configuring Mail Support (7 Mins 24 Secs)
   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 (5 Mins 22 Secs)
   8.4.2 Jobs and Alerts Facts
   8.4.3 Configuring Alerts (10 Mins 53 Secs)
   8.4.4 Managing SQL Server Agent Jobs (13 Mins 57 Secs)
   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 (4 Mins 32 Secs)
   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 (4 Mins 22 Secs)
   8.5.3 Troubleshooting Locking (8 Mins 01 Sec)
   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