AppDev - Technical learning ...in a class by itself
Product Search
Browse Catalog
Training Topics
 Developer
ADO.NET
ASP, ASP.NET
BizTalk Server
Cloud
HTML
Java, Javascript
LightSwitch
MCTS
Metro
Mobile Development
Office Developer
SharePoint
Silverlight
SQL Server
Visual Basic
Visual C#
Visual Studio .NET
Visual Studio 2005
Visual Studio 2008
Visual Studio 2010
Visual Studio 6.0
XML, XSLT
AppDev OnDemand
Training Suites

IT Professional
MCSE, MCSA
Microsoft Windows

End User
Learning Office
Learning Windows
Team Training Solutions
 Overview
AppDev OnDemand Enterprise
Instructor-Led
Blended Learning
Multi-User Licensing
Resources
 Conferences
Free Training
International
About AppDev
 AppDev Experts
Company Profile
Press Releases
Contact Us
Jobs
Testimonials
Privacy Policy
Site Map


Sign-in | New User? Click here to sign up
  View Cart My Account Customer Service Product Support
AppDev Home Page CD, DVD, Online Learning Team Learning: Online, Classroom ILT Solutions
Ready to Order? Order online or call 1-800-578-2062    AppDev on Facebook AppDev on YouTube
MCSE 2000 Elective: SQL Server 7.0 System Administration Training

MCSE 2000 Elective: SQL Server 7.0 System Administration

with Wayne Snyder

View Course Outline

This Microsoft approved course provides step-by-step preparation to install, configure, administer, and troubleshoot Microsoft SQL Server version 7.0. At the conclusion of this course, you’ll be fully prepared for system administration using Microsoft SQL Server version 7.0, and be prepared to pass MCP exam #70-028.

Course includes 8+ hours of total training time...

  • 5 CDs
  • Over 8 hours of media run time

SPECIAL OFFER: BUY 1 GET 1 FREE TRAINING! Details...
Hurry, offer ends 2/29/2012. Not valid on printed books.

FormatModulesRetail Price
70-028 Course
CD-ROM

 5 CD-ROMs
ZWN00-CD-30

Retail Price: $195.00

Multi-User LicenseNeed to train multiple users? Call 800-578-2062 to purchase additional user licenses for your AppDev Product.
100% Satisfaction Guaranteed. Details...
View the text of AppDev's Single-User License Agreement.
See additional order and shipping information.
Read about Wayne Snyder.
View the certification map to see where this training fits into the Windows 2000 MCSE track.
Save even more on this course when you buy a Training Suite: MCSE 2000 Electives Suite: SQL Server 2000
Course Outline (Outlines are subject to change.)

Administering SQL Server 7.0

ModulesRun Time
5 CDs8 hours

This Microsoft approved course provides step-by-step preparation to install, configure, administer, and troubleshoot Microsoft SQL Server version 7.0. At the conclusion of this course, you’ll be fully prepared for system administration using Microsoft SQL Server version 7.0, and be prepared to pass MCP exam #70-028.

SESSION 1
Total Time: 97 Minutes

  • Introduction
  • Installation Planning
  • Installation
  • SQL Enterprise Manager
  • SQL Tools

SESSION 2
Total Time: 105 Minutes

  • Troubleshooting Installation
  • Advanced Installation
  • Upgrade
  • Client Install
  • Creating Databases
  • Database Considerations

SESSION 3
Total Time: 104 Minutes

  • Performance Considerations
  • Managing Databases
  • Security Models
  • Logins & Users
  • Permissions & Roles
  • Applying Permissions & Roles

SESSION 4
Total Time: 106 Minutes

  • Backups
  • Transaction Logs
  • Filegroup Backups
  • Optimizing Backups
  • Restore
  • Backup & Restore
  • Relocating Data

SESSION 5
Total Time: 96 Minutes

  • Replication Overview
  • Configuring Replication
  • Linked Server
  • Automation
  • Alerts & Troubleshooting
  • SQL Mail
  • Monitoring & Optimizing
  • Full Text Search

back to top


Your Instructor

Wayne Snyder is a recognized expert in application development and database design and modeling with specialization in Microsoft SQL Server. Wayne has worked with SQL from its first release, and won the prized Microsoft MVP (Most Valuable Professional) award in 1998. His certifications include MCDBA, MCSE, and MCT. Wayne is a highly respected speaker at industry conferences and a sought-after reviewer for major technical publications. He is a popular instructor and consultant currently working with IKON Education Services.

back to top



About This Site | Privacy Policy | Site Map
©2010 AppDev Products, LLC. All Rights Reserved. PHONE: 800-578-2062 or 952-943-1363
10250 Valley View Road Suite 120 | Eden Prairie, MN 55344 | FAX: 952-942-8452 | info@appdev.com