Microsoft SQL Server 2000 Admin Tutorial

We hope you enjoyed the FREE lessons above. To view the complete contents, including ALL the lessons below, please purchase the CD.
CLICK HERE TO BUY THIS CD

General Administrative Responsibilities
Administration in the Real World
Creating Databases
Data Maintenance Explained
Backing up/Restoring Data
Security of Databases

Hardware Requirements
Chapter Overview
HW Compatibility
How to Optimise HW for SQL Server

How to Install SQL Server 2000
SQL Server 2000 Editions
Licensing
Multiple Instances Explained
Selecting a Security Mode
Collation and Sort Selection
Network Libraries Explored
Install Methods
Upgrade to SQL Server 2000
The Default Databases
Installation
Installation Troubleshoot

SQL Server Security
Chapter Overview
Authentication Modes
Roles in Security
Assigning Permissions
Application Roles Explained

System Services
SQL Services Overview
Issues for SQL Services

System Databases
Chapter Overview
Sample Databases

Data Storage
Chapter Overview and how SQL Stores Data
Fillfactor Overview
File and Log Location

Administrative Tools
Chapter Overview
Considerations for the Exam

Enterprise Manager
MS Management Console
Open and Customise the Enterprise Manager
Working with the Enterprise Manager

Query Analyzer
Query Analyzer Explored
How to Issue Queries with the Query Analyzer
Features of the Query Analyzer
Graphical Query Plan Explained

Transact-SQL Select Statement
Utilising a Select Statement
Simple Syntax
Select Options
Select Considerations to Take Note of

Transact-SQL Insert Statement
Utilising an Insert Statement
Simple Syntax
Inserting Options and Further Considerations

Transact-SQL Update Statement
Utilising the Update Statement
Simple Syntax/Options
Important Update Considerations

Transact-SQL Delete Statement
Utilising the Delete Statement
Simple Syntax/Important Considerations

Creating a Database
Utilising the Create Database Statement
Database Properties and Options Described
Considerations for Database Creation
Handling File Growth
How to Shrink Database Files
Sizing the Database - Step by Step
Practicing Good Design

Transaction Logs
Chapter Overview and how they work
What Transactions Look Like
The Importance of Location
Utilising Transaction Logs
Transaction Log Options Explained

Filegroups
Filegroups Explained
Filegroups - the Advantages
Filegroups - the Disadvantages
Microsoft's Recommendation on Filegroups

RAID & SQL
Chapter Overview
SQL and RAID

SQL Profiler
The Function of the SQL Profiler
Open the SQL Profiler
Utilising the SQL Profiler

Operators
Operators Explained
The Creation of an Operator
Using Operators - Considerations

Jobs
How to Automate an SQL Server
Mail Enabling SQL Server 2000
Create a New Job
Schedule a Job
Job Notifications Explained
How to Start and Stop a Job
Multi Server Jobs Explained
View Job History

Alerts
Alerts Explained
Performance and User Defined Alerts
Disabling Alerts
Using Alerts - Important Considerations

Linked Servers
SQL In a Distributed Environment
Refer to SQL Server Objects
How to Set Up a Linked Server Relationship

Database Backups
Backup Strategy Explained
Database Recovery Models Explored
SQL Server Backup Explored
Who, When and Where
System and User Databases - Lesson 1
System and User Databases - Lesson 2
Taking a Backup
Working with Multiple Devices
SQL Backup Statement Explained
Tape Backup - Step by step
Backup Types Explained
Transaction Log Backups
File Backups
Filegroup Backups
Full Backup Strategy
Differential Backup Strategy
Backup Summary

Restoring Data
The Process SQL Server Recovery
Restoring a Database - the Preparation
The SQL Restore Statement
Restore Options
Restoring Transaction Logs and System Databases
Bottom Line on Restoring Data

Maintaining High Availability
How to Determine Requirements
Clustering Explained
Standby Servers
Log Shipping

Data Transformation Services
Importing and Exporting Data
SQL Data Transport Tools Described
DTS Introduction
The Creation of a DTS Package
Further DTS Package Functionality
How to Define Transformation Tasks
Utilising DTS

Monitoring SQL Server 2000
Performance Surrounding Issues
Monitor and Tune - Fundamentals
How to Improve Performance
Common Monitoring Tasks and Tools
What To Monitor
Locks

Replication Basics
Dealing With Distributed Data
SQL Server Replication:
• Overview
• Types
• Models
Replication Agents
Web Based Data App.
SQL Server Replication Notes

Course Summary
Value of SQL Server knowledge
MS MCDBA Certification