Microsoft SQL Server 2000 Admin Tutorial Try for FREE
Select a tutorial category
Discounted Training Courses
Members of the VTC Online University have unlimited access to this tutorial. At the moment, you are in demo mode and only the first 3 chapters will play. But members have access to EVERY SINGLE TITLE IN OUR RANGE, i.e., over 40,000 tutorials on 400+ titles all with expert tutors. Where else can you get high quality one to one training for just $30.00 per month!
Benefits
:- 01. Unlimited viewing.
- 02. Downloadable working files.
- 03. Expert instructors.
- 04. Use at home / work or both.
- 05. Works on PC or Mac.
- 06. Telephone Tech support.
- 07. Cancel at any time.
- 08. 300+ courses for 1 low fee.
- 09. New titles added regularly.
- 10. 100% Guaranteed
Should you need any help, just call - contact details at the bottom of the page.
Unlimited Professional Training on over 400+ applications and programming languages for only $30.
The fastest and most cost effective way to learn! Forget boring books! No need for expensive classroom training - just easy to follow training videos that play right from your own computer. Login from home or office - the choice is yours. All courses are taught by world leading experts, unlimited access, on over 400 different subjects.Please Note:
You are in Demo mode which only allows access to the first 3 chapters of this Microsoft SQL Server 2000 Admin training course and all the other titles listed on this site, this is to help you evaluate the quality of the training before joining. If you decide to join, you will instantly have totally UNLIMITED ACCESS to over 400 professionally created video tutorials, you will be able to access the content from any location and no restrictions are placed on the amount of content you can watch, you can also cancel at any time you wish. Over 4000 hours of training for just $30.00.
You are in Demo mode which only allows access to the first 3 chapters of this Microsoft SQL Server 2000 Admin training course and all the other titles listed on this site, this is to help you evaluate the quality of the training before joining. If you decide to join, you will instantly have totally UNLIMITED ACCESS to over 400 professionally created video tutorials, you will be able to access the content from any location and no restrictions are placed on the amount of content you can watch, you can also cancel at any time you wish. Over 4000 hours of training for just $30.00.
Topics covered on this course include:
A Few Words About SQL Server
Overview
General Database Information
- Main Purpose of a Database
- What Makes Up a Database
- Two Main Types of Databases
- Normalization
- Denormalization
- Database Relationships
- Indexes
- Proper Design
General Administrative Responsibilities
- Real World Administration
- Designing/Building Databases
- Data Maintenance/Transfer
- Backup/Restore of Data
- Security
Hardware Requirements
- Minimum Hardware Requirements
- Hardware Compatibility
- Optimizing Hardware for SQL Server
Installing SQL Server 2000
- SQL Server 2000 Editions
- Licensing
- Multiple Instances
- Choosing a Security Mode
- Collation and Sort Selection
- Network Libraries
- Installation Methods
- Upgrading to SQL Server 2000
- Default Databases
- Installation
- Troubleshooting an Installation
SQL Server Security
- Security Overview
- Authentication Modes
- Roles
- Assigning Permissions
- Application Roles
System Services
- SQL Services
- SQL Services Issues
System Databases
- System Databases
- Sample Databases
Data Storage
- How SQL Stores Data
- Fillfactor
- File and Log Location/Management
Administrative Tools
- Overview of Admin Tools
- Exam Considerations
Enterprise Manager
- Microsoft Management Console
- Opening & Customizing the Enterprise Mgr
- Using the Enterprise Manager
Query Analyzer
- Opening and Exploring the QA
- Issuing Queries Using the QA
- Query Analyzer Features
- Graphical Query Plan
Transact-SQL Select Statement
- Using a Select Statement
- Basic Syntax
- Select Options
- Important Select Considerations
Transact-SQL Insert Statement
- Using an Insert Statement
- Basic Syntax
- Insert Options/Considerations
Transact-SQL Update Statement
- Using the Update Statement
- Basic Syntax/Options
- Important Update Considerations
Transact-SQL Delete Statement
- Using the Delete Statement
- Basic Syntax/Important Considerations
Creating a Database
- Using the Create Database Statement
- Database Properties and Options
- Database Creation Considerations
- Managing File Growth
- Shrinking Database Files
- Sizing the Database
- Importance of Good Design
Transaction Logs
- How Transaction Logs Work
- What Transactions Look Like
- Location / Location / Location
- Advantages of Using Transaction Logs
- Transaction Log Options
Filegroups
- What Are Filegroups?
- Advantages of Filegroups
- Disadvantages of Filegroups
- Microsoft's Recommendation on Filegroups
RAID & SQL
- RAID Basics
- SQL and RAID
SQL Profiler
- What SQL Profiler Does
- Opening SQL Profiler
- Using SQL Profiler
Operators
- What are Operators?
- Creating an Operator
- Considerations When Using Operators
Jobs
- Automating SQL Server
- Mail Enabling SQL Server 2000
- Creating a New Job
- Scheduling a Job
- Job Notifications
- Starting/Stopping a Job
- Multi Server Jobs
- Viewing Job History
Alerts
- What are Alerts
- Performance Alerts
- User Defined Alerts
- Disabling Alerts
- Considerations When Using Alerts
Linked Servers
- Using SQL In a Distributed Environment
- Referring to SQL Server Objects
- Setting Up a Linked Server Relationship
Database Backups
- Backup Strategy
- Database Recovery Models
- SQL Server Backup
- Who When and Where
- System Databases
- User Databases
- Performing a Backup
- Using Multiple Devices
- SQL Backup Statement
- Tape Backup
- Backup Types
- Transaction Log Backups
- File and Filegroup Backups
- Full Backup Strategy
- Differential Backup Strategy
- Backup Review
Restoring Data
- SQL Server Recovery Process
- Preparing to Restore a Database
- The SQL Restore Statement
- Restore Options
- Restoring Transaction Logs
- Restoring System Databases
- Bottom Line on Restoring Data
Maintaining High Availability
- Determining Requirements
- Clustering
- Standby Servers
- Log Shipping
Data Transformation Services
- Importing and Exporting Data
- SQL Data Transport Tools
- DTS Overview
- Creating a DTS Package
- More DTS Package Functionality
- Defining Transformation Tasks Creating
- Using DTS in Various Ways
Monitoring SQL Server 2000
- Performance Issues
- Monitoring and Tuning Basics
- Improving Performance
- Common Monitoring Tasks and Tools
- What To Monitor
- Locks
Replication Basics
- Dealing With Distributed Data
- SQL Server Replication
- SQL Server Replication Types
- SQL Server Replication Models
- Replication Agents
- Web Based Data Applications
- SQL Server Replication Notes
Course Wrap-Up
- Value of SQL Server knowledge
- Microsoft's MCDBA Certification
If you would like to own this Microsoft SQL Server training title on CD, you may purchase it from our online store, because we don't have to use the same level of compression on the CDs as we do with the online, the audio and video playback is of a higher quality. For a single low payment you can buy this
After you have completed a tutorial, a 
In order to view the training, you must have the latest version of QuickTime installed. Please note that the online movies have been compressed for quicker downloads, CDs and DVDs have far higher audio and video quality.