CBT Training Courses
Cisco Training Videos
CompTIA Training Videos
Intuit Training Videos
Microsoft Office Training Videos
Microsoft Technical Training Videos
- Microsoft Certification Videos
- MCITP Certification Videos
- MCITP Enterprise Administrator Certification Videos
- MCITP Server Administrator Certification Videos
- MCITP Virtualization Administrator Certification Videos
- Dynamics CRM Training
- Exchange Server Training
- Exchange Server 2013
- Exchange Server 2010
- Lync Server
- Lync Server 2010
- Project Server Training
- SQL Server Training
- SQL Server 2012 Training
- SCCM 2012
- SCOM 2012
- SharePoint Server Training
- System Center Training
- Virtualization Training
- Visual Studio Training
- Windows Administration
- Windows 8 Administration
- Windows 7 Administration
- Windows Server Training
- Windows Server 8
- Windows Server 2008
- Windows Server 2003
Red Hat Training Videos
Security Training Videos
In the News
Administering a Microsoft SQL Server 2000 Database CBT Training Videos on CD
Price: $595.00
Course ID: 2072-tv
Microsoft Course Number:2072
Schedule CBT Planet’s instructor-led, classroom training using your own time schedule. This format is incredibly convenient, you’ll never miss another training class or lecture and you won’t fall behind. Your learning is under your full control. The best SQL Trainers in the industry helped us develop this ultimate training and certification program. We deliver everything you need for success!
This SQL Server 2000 Administration CBT training video course teaches network administrators techniques for the installation, configuration, and administration of SQL Server 2000. You’ll enjoy our expert instructor Kenneth Mayer and his friendly, knowledgeable presentation. His style makes this highly technical material easy to understand. Once you complete this course, you'll be fully prepared for successful system administration and you will be ready to pass exam #70-228. Passing this exam provides core credit towards MCDBA certification as well as elective credit towards MCSE certification.
Training Course Includes:
- Six fully featured CD-ROMs with live instructor-led classroom sessions, full audio, full video and demonstration components
- Printable courseware helps you study offline
- Exclusive LearningZone Live Mentor (valued at $195) lets you get help, 24/7, with certified instructors through online chats
- Microsoft’s Authorized MeasureUp Exam Simulation
- Content focuses on practical solutions for real-world development problems
- Free One Year Upgrade Policy
| Administering a Microsoft SQL Server 2000 Database Training Video CBT Features: | |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
Microsoft Course 2072 Outline:
| Level One |
SQL Server Overview
What is SQL Server?
Login, User Accounts & Roles
| Level Two |
Planning to Install SQL Server
Hardware requirements and Installation
Review of the Installation
Testing Our Connections
Troubleshooting Your Connection
Review Quiz
| Level Three |
How is Data Stored
Creating Databases
Managing Databases
Creating Filegroups
Filegroup Performance & Fault Tolerance
| Level Four |
How is Data Stored
Creating Databases
Managing Databases
Creating Filegroups
Filegroup Performance & Fault Tolerance
| Level Five |
Configuration Tasks
SQL Agent Mail vs SQL Mail
Routine Tasks & Creating Jobs
Alerts
Troubleshooting Alerts
Review Quiz
| Level Six |
Having a Backup Strategy
Different Ways to Perform Backups
| Level Seven |
SQL Server Recovery Process
Restoring or Rebuilding Master Database
Review Quiz
| Level Eight |
Performance Monitoring of SQL Server
Memory Use, Indexes, Locks & Queries
| Level Nine |
Importing & Exporting Data
DTS (Data Transformation Services)
Tasks
Review Quiz
| Level Ten |
Availability
Clustering
| Level Eleven |
Considerations for Distributing Data
Replication
Physical replication Models
Review Quiz