Title Language  : 

Find a Course... Try for Free!

 

Microsoft SQL Server 2000 Admin Tutorials

Course Content
Virtual Training Company's Microsoft SQL Server 2000 Admin tutorial is just what you need to learn how to administer SQL Server in the real world and to help you prepare for the Microsoft Certification Exam 70-228. Mark Long, a Microsoft certified instructor, will teach you installation and building and backing up databases. He begins with general information about databases and general administrative responsibilities. He will then instruct you on the specifics of the administration of SQL Server 2000, such as installation, data storage, and file groups. You will learn the two main administrative tools, enterprise manager and query analyzer, through real-life examples. In this tutorial, you will also learn how to automate the administration and how to monitor the SQL server. To start learning right away, click on one of the movie topics below.
QT To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.
Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.

лл Hide This
A Few Words About SQL Server
What Is SQL Server? (04:13)
SQL Server Mystique (04:02)
Transact SQL (05:07)
SQL Server History (01:55)
Overview
Overview of Course (05:45)
General Database Information
Main Purpose of a Database (03:26)
What Makes Up a Database (05:34)
Two Main Types of Databases (06:12)
Normalization (03:53)
Denormalization (02:42)
Database Relationships (05:09)
Indexes (05:40)
Proper Design (03:25)
General Administrative Responsibilities
Real World Administration (06:27)
Designing/Building Databases (06:00)
Data Maintenance/Transfer (03:02)
Backup/Restore of Data (03:26)
Security (05:55)
Hardware Requirements
Minimum Hardware Requirements (01:39)
Hardware Compatibility (02:52)
Optimizing Hardware for SQL Server (03:24)
Installing SQL Server 2000
SQL Server 2000 Editions (03:17)
Licensing (03:21)
Multiple Instances (03:26)
Choosing a Security Mode (03:52)
Collation and Sort Selection (04:56)
Network Libraries (03:34)
Installation Methods (03:05)
Upgrading to SQL Server 2000 (03:34)
Default Databases (04:40)
Installation (05:33)
Troubleshooting an Installation (03:43)
SQL Server Security
Security Overview (03:02)
Authentication Modes (04:10)
Roles (04:27)
Assigning Permissions (04:44)
Application Roles (04:16)
System Services
SQL Services (02:48)
SQL Services Issues (04:48)
System Databases
System Databases (03:38)
Sample Databases (02:17)
Data Storage
How SQL Stores Data (05:16)
Fillfactor (02:50)
File and Log Location/Management (03:01)
Administrative Tools
Overview of Admin Tools (04:01)
Exam Considerations (03:36)
Enterprise Manager
Microsoft Management Console (03:08)
Opening & Customizing the Enterprise Mgr (04:46)
Using the Enterprise Manager (04:17)
Query Analyzer
Opening and Exploring the QA (04:42)
Issuing Queries Using the QA (03:22)
Query Analyzer Features (03:59)
Graphical Query Plan (04:35)
Transact-SQL Select Statement
Using a Select Statement (02:04)
Basic Syntax (02:15)
Select Options (03:53)
Important Select Considerations (02:22)
Transact-SQL Insert Statement
Using an Insert Statement (02:34)
Basic Syntax (02:16)
Insert Options/Considerations (03:13)
Transact-SQL Update Statement
Using the Update Statement (02:47)
Basic Syntax/Options (03:47)
Important Update Considerations (02:30)
Transact-SQL Delete Statement
Using the Delete Statement (04:21)
Basic Syntax/Important Considerations (02:53)
Creating a Database
Using the Create Database Statement (07:04)
Database Properties and Options (02:55)
Database Creation Considerations (03:34)
Managing File Growth (03:45)
Shrinking Database Files (04:31)
Sizing the Database (05:01)
Importance of Good Design (03:17)
Transaction Logs
How Transaction Logs Work (03:32)
What Transactions Look Like (03:26)
Location / Location / Location (02:59)
Advantages of Using Transaction Logs (02:43)
Transaction Log Options (04:47)
Filegroups
What Are Filegroups? (02:31)
Advantages of Filegroups (02:23)
Disadvantages of Filegroups (02:29)
Microsofts Recommendation on Filegroups (02:24)
RAID & SQL
RAID Basics (06:41)
SQL and RAID (03:54)
SQL Profiler
What SQL Profiler Does (02:18)
Opening SQL Profiler (04:56)
Using SQL Profiler (03:29)
Operators
What are Operators? (02:51)
Creating an Operator (04:01)
Considerations When Using Operators (02:18)
Jobs
Automating SQL Server (03:11)
Mail Enabling SQL Server 2000 (04:33)
Creating a New Job (03:38)
Scheduling a Job (04:33)
Job Notifications (02:52)
Starting/Stopping a Job (03:36)
Multi Server Jobs (04:06)
Viewing Job History (04:13)
Alerts
What are Alerts (02:53)
Performance Alerts (03:23)
User Defined Alerts (05:20)
Disabling Alerts (02:57)
Considerations When Using Alerts (02:25)
Linked Servers
Using SQL In a Distributed Environment (02:32)
Referring to SQL Server Objects (02:02)
Setting Up a Linked Server Relationship (02:13)
Database Backups
Backup Strategy (02:17)
Database Recovery Models (03:57)
SQL Server Backup (02:36)
Who When and Where (02:16)
System Databases (02:34)
User Databases (05:19)
Performing a Backup (04:34)
Using Multiple Devices (01:50)
SQL Backup Statement (03:42)
Tape Backup (03:47)
Backup Types (02:15)
Transaction Log Backups (02:38)
File and Filegroup Backups (02:54)
Full Backup Strategy (02:56)
Differential Backup Strategy (01:39)
Backup Review (01:30)
Restoring Data
SQL Server Recovery Process (02:07)
Preparing to Restore a Database (03:14)
The SQL Restore Statement (05:50)
Restore Options (02:24)
Restoring Transaction Logs (03:10)
Restoring System Databases (03:10)
Bottom Line on Restoring Data (03:19)
Maintaining High Availability
Determining Requirements (03:55)
Clustering (03:00)
Standby Servers (03:32)
Log Shipping (02:38)
Data Transformation Services
Importing and Exporting Data (02:10)
SQL Data Transport Tools (02:55)
DTS Overview (04:12)
Creating a DTS Package (05:44)
More DTS Package Functionality (03:20)
Defining Transformation Tasks Creating (05:01)
Using DTS in Various Ways (02:22)
Monitoring SQL Server 2000
Performance Issues (02:45)
Monitoring and Tuning Basics (06:24)
Improving Performance (01:50)
Common Monitoring Tasks and Tools (03:42)
What To Monitor (02:49)
Locks (05:10)
Replication Basics
Dealing With Distributed Data (02:10)
SQL Server Replication (03:19)
SQL Server Replication Types (03:32)
SQL Server Replication Models (02:12)
Replication Agents (02:53)
Web Based Data Applications (02:26)
SQL Server Replication Notes (03:03)
Course Wrap-Up
Value of SQL Server knowledge (03:10)
Microsofts MCDBA Certification (05:21)

Email this Page     Send us Feedback
Tutorial Information / Pricing
Title: Microsoft SQL Server 2000 Admin
Author: Mark Long
SKU: 33369
ISBN: 1932072020
Duration: 10 hrs / 154 Lessons
Compatibility: Win XP, 2000, 98, NT, Mac OS X, OS 9

Online University Access all our Training for only 30
The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP LEARN MORE »

Get this title on CD
Single User: US$ 99.95 - Purchase CD / Add to Cart

Multi User (10): US$ 500.00 - Purchase CD / Add to Cart

Select Bandwidth
Click "High Bandwidth" if you want to view movies at the highest quality available. Click "Low Bandwidth" if on a slow dial-up connection (28 Kbps and such). The low bandwidth movies are slightly more compressed and smaller in file size, allowing for faster streaming.

Select:

Select Category

Special Groups

Publisher or Products