Microsoft SQL Server 2000 Admin
by Mark Long
Start the free chapterVirtual 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.
Course content
A Few Words About SQL Server4 lessons
Overview1 lessons
General Database Information8 lessons
General Administrative Responsibilities5 lessons
Hardware Requirements3 lessons
Installing SQL Server 200011 lessons
- SQL Server 2000 Editions3:171 credit or ad
- Licensing3:221 credit or ad
- Multiple Instances3:261 credit or ad
- Choosing a Security Mode3:521 credit or ad
- Collation and Sort Selection4:571 credit or ad
- Network Libraries3:341 credit or ad
- Installation Methods3:061 credit or ad
- Upgrading to SQL Server 20003:351 credit or ad
- Default Databases4:401 credit or ad
- Installation5:341 credit or ad
- Troubleshooting an Installation3:431 credit or ad
SQL Server Security5 lessons
System Services2 lessons
System Databases2 lessons
Data Storage3 lessons
Administrative Tools2 lessons
Enterprise Manager3 lessons
Query Analyzer4 lessons
Transact-SQL Select Statement4 lessons
Transact-SQL Insert Statement3 lessons
Transact-SQL Update Statement3 lessons
Transact-SQL Delete Statement2 lessons
Creating a Database7 lessons
- Using the Create Database Statement7:041 credit or ad
- Database Properties and Options2:551 credit or ad
- Database Creation Considerations3:351 credit or ad
- Managing File Growth3:461 credit or ad
- Shrinking Database Files4:311 credit or ad
- Sizing the Database5:011 credit or ad
- Importance of Good Design3:171 credit or ad
Transaction Logs5 lessons
Filegroups4 lessons
RAID & SQL2 lessons
SQL Profiler3 lessons
Operators3 lessons
Jobs8 lessons
- Automating SQL Server3:111 credit or ad
- Mail Enabling SQL Server 20004:341 credit or ad
- Creating a New Job3:391 credit or ad
- Scheduling a Job4:341 credit or ad
- Job Notifications2:531 credit or ad
- Starting/Stopping a Job3:371 credit or ad
- Multi Server Jobs4:071 credit or ad
- Viewing Job History4:131 credit or ad
Alerts5 lessons
Linked Servers3 lessons
Database Backups16 lessons
- Backup Strategy2:171 credit or ad
- Database Recovery Models3:571 credit or ad
- SQL Server Backup2:361 credit or ad
- Who When and Where2:171 credit or ad
- System Databases2:341 credit or ad
- User Databases5:191 credit or ad
- Performing a Backup4:351 credit or ad
- Using Multiple Devices1:501 credit or ad
- SQL Backup Statement3:431 credit or ad
- Tape Backup3:481 credit or ad
- Backup Types2:151 credit or ad
- Transaction Log Backups2:381 credit or ad
- File and Filegroup Backups2:541 credit or ad
- Full Backup Strategy2:571 credit or ad
- Differential Backup Strategy1:401 credit or ad
- Backup Review1:301 credit or ad
Restoring Data7 lessons
- SQL Server Recovery Process2:071 credit or ad
- Preparing to Restore a Database3:141 credit or ad
- The SQL Restore Statement5:501 credit or ad
- Restore Options2:251 credit or ad
- Restoring Transaction Logs3:101 credit or ad
- Restoring System Databases3:101 credit or ad
- Bottom Line on Restoring Data3:191 credit or ad
Maintaining High Availability4 lessons
Data Transformation Services7 lessons
- Importing and Exporting Data2:111 credit or ad
- SQL Data Transport Tools2:561 credit or ad
- DTS Overview4:131 credit or ad
- Creating a DTS Package5:451 credit or ad
- More DTS Package Functionality3:201 credit or ad
- Defining Transformation Tasks Creating5:021 credit or ad
- Using DTS in Various Ways2:231 credit or ad
Monitoring SQL Server 20006 lessons
Replication Basics7 lessons
- Dealing With Distributed Data2:111 credit or ad
- SQL Server Replication3:201 credit or ad
- SQL Server Replication Types3:331 credit or ad
- SQL Server Replication Models2:131 credit or ad
- Replication Agents2:541 credit or ad
- Web Based Data Applications2:261 credit or ad
- SQL Server Replication Notes3:041 credit or ad