COURSE SEARCH
 
   HOME > COURSES > MICROSOFT SQL SERVER 2000 ADMINISTRATION MEMBERS LOGIN 
UNLIMITED ACCESS TO OVER 575 ONLINE TRAINING COURSES FOR ONE ANNUAL PAYMENT OF ONLY $149 USD
BUY NOW
  HOME     COURSE LIBRARY     QUESTIONS & ANSWERS     CONTACT US
There are many excellent online courses. This has been hugely beneficial in my day to day work.
- Louise Nolan


Microsoft SQL Server 2000 Administration




Course Aims
This intensive course will introduce readers to administration of Microsoft SQL Server 2000 databases. The general objective of the course is to install SQL Server, create databases, import data, set up security, automate jobs and alerts, set up replication and create a robust backup regime.
Assumed Knowledge
Previous experience of SQL Server would be useful as would administration experience with Windows NT or 2000.
Course Audience
This course has been created for readers who are using or planning to use SQL Server 2000 in their applications or who wish to take the Microsoft Certified Professional exam for SQL Server. It should be useful both to people that are new to SQL Server and to those who have experience with an earlier version.

This course can be found in the following categories:
Courses > Databases > SQL Server Database
Courses > Microsoft > SQL Server

Table of Contents
SQL Server Feature Overview and History
  		• What is Microsoft SQL Server 2000?
  		• Client/Server Architecture
  		• Microsoft SQL Server ~ A Brief History
  		• The Sybase-Ashton Tate-Microsoft Deal
  		• The Sybase-Microsoft split
  		• Microsoft SQL Server 6.0
  		• Microsoft SQL Server 7.0 ~ "The Defining Release"
  		• Microsoft SQL Server 2000 ~ "The Intended Release"?
  		• New Names
  		• Relational Database Enhancements
  		• XML Integration of Relational Data
  		• Graphical Administration Enhancements
  		• Replication Enhancements
  		• Data Transformation Services Enhancements
  		• What's New in Analysis Services
  		• What's New in Meta Data Services
  		• What's New in English Query
     
    Installing Version 2000 and Upgrading From Previous Releases
  		• SQL Server Editions
  		• Pre-Installation Check list
  		• Install Microsoft SQL Server 2000
  		• Installation Methods
  		• Installed SQL Server Components
  		• Upgrading and Compatibility Issues
  		• Post-Installation Issues
     
    Data Storage Management
  		• Creating Databases and Logs
  		• The System Databases
  		• Planning Database Scope
  		• Create New Databases Through Enterprise Manager
  		• Use Templates to Create Databases
  		• Script a CREATE DATABASE Command
  		• Use Filegroups
  		• What Happens When you Create a Database?
  		• Manage Database Availability
  		• Detach Databases
  		• Upgrade Access MSDE Files to Microsoft SQL Server 2000
  		• Database Options
  		• Recovery Models
  		• Database Collation Options
  		• General Options
  		• Manage Database Size
  		• Delete Databases
     
    Importing and Exporting with DTS and Linked Servers
  		• Data Transformation Services
  		• Modify DTS Packages
  		• DTS Transformations
  		• BCP (The Lowest Common Denominator)
  		• Use Backup and Restore to Transfer Databases
  		• Linking Servers
    Full-Text Searching
  		• Full Text Searching
  		• Create a Full-Text Catalog
  		• Use the Catalog
  		• Query Full-Text Data
     
    Security
  		• SQL Server 2000 Security Overview and Terminology
  		• Authentication Options
  		• SQL Server 2000 Authentication Modes
  		• Giving Access to SQL Server 2000
  		• Create Logins
  		• Fixed Server and Database Roles
  		• Fixed Database Roles
  		• User-Defined Roles
  		• Application Roles
  		• Database Permissions
  		• Security and Backward Compatibility
     
    Backing Up and Restoring Databases
  		• Planning SQL Server Fault Tolerance
  		• Backup Overview
  		• SQL Server 2000's Backup Mechanism
  		• Backup Types
  		• Backup Destinations
  		• Perform the Backup
  		• Restore Databases from Backup
  		• Standby Servers and the Log Shipping Feature
  		• Restore System Databases
     
    Automating Administration
  		• Automation Overview
  		• Set Up SQLMail
  		• Set Up Operators in Microsoft SQL Server
  		• Jobs, Events and Alerts
  		• Set Up Alerts
     
    Data Replication
  		• Replication Overview
  		• Replication Topologies
  		• Types of Replication
  		• Set Up Replication
  		• Generate a Replication Script
     
    Troubleshooting, Monitoring and Optimising
  		• Troubleshoot SQL Server
  		• Monitor SQL Server
  		• Optimise SQL Server
  		• Hardware Optimisation - Memory, CPUs and Disks
  		• Windows Optimisation
  		• SQL Server Configuration Options
  		• Optimal Database Design
  		• Client-Side Optimisations
    TRY BEFORE YOU BUY BECOME A RESELLER TERMS & PRIVACY
    Tuesday 22nd May 2012  © COPYRIGHT 2012 - website design by Website Design by Visualsoft