We will be undergoing scheduled maintenance on May 20th, 2013 at 02:00 GMT.
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.
Optimizing Hardware for SQL Server
File and Log Location/Management
Opening & Customizing the Enterprise Mgr
Important Select Considerations
Important Update Considerations
Basic Syntax/Important Considerations
Using the Create Database Statement
Database Properties and Options
Database Creation Considerations
Location / Location / Location
Advantages of Using Transaction Logs
Microsofts Recommendation on Filegroups
Considerations When Using Operators
Using SQL In a Distributed Environment
Referring to SQL Server Objects
Setting Up a Linked Server Relationship
More DTS Package Functionality
Defining Transformation Tasks Creating
Microsofts MCDBA Certification
Every course on the vtc.com website contains free movies that let you assess the quality of our tutorials before you subscribe - just click on the blue links to watch them. Become a member today to access over 100,000 instructional videos!
Sign Up NowIf you are already an active vtc.com member, please log in to access the tutorials.