United States Microsoft SQL Server 2000 Admin Tutorials
Online Contents For This Course
We have made some of the video tutorials for
Microsoft SQL Server 2000 Admin
freely available to help you evaluate our training. Click on any of the linked lesson listings below to preview FREE!
Course Description
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.
Choose your media type:
|
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 FeedbackCourse Information
| Course: | Microsoft SQL Server 2000 Admin |
| Author: | Mark Long |
| SKU: | 33369 |
| ISBN: | 1932072020 |
| Release Date: | 2002-07-31 |
| Duration: | 10 hrs / 154 tutorials |
| Captions: | No |
Subscription / Purchase Information
Visitors to VTC.com will be able to view all introductory videos for each training course.
Free Trial Members will gain access to first three chapters for each training course.
Sign up for a Free Trial
Full Access Members have full access to VTC.com’s entire library of video tutorials.
If you are already a member, please login here.