SQL Server 7 Training Tutorials - e-Learning - Distance Leaning - Self paced - Courses UK

Affordable Online Computer Courses
 
 
 
 
MCSE 2003 Training
MCSA Training
MCDBA Training
MCAD Training
MCSD Training
Mous Certification
CompTIA A+ Training
CompTIA Network+
CompTIA Security+ CompTIA Server+
CompTIA Linux+
Cisco CCNA Training
Cisco CCDA Training
CCNP BSCI Training
CCNP BCMSN Training
CCNP ISCW Training
CCNP CIT Training
Lotus Notes Training
Novell CNE Training
Solaris 8 Training
Sybase Training
CIW Foundations
Internet Marketing
ICDL Training
ECDL Training
Quickbooks Training
Groupwise Training
Data Warehousing
Project Server 2003
 
 
Windows 2003 Training
Windows XP Help
Windows Training
Windows NT4 Help
UNIX Tutorial
V.Studio .NET/ ASP
C++ Tutorial
SQL Server 2000
Visual Basic Tutorial
Visual C Training
Visual C# XML Training
Visual Studio .NET
Visual interdev
Oracle 10g Training
Powerbuilder Tutorial
SAP Training
SAS Training
Crystal Reports Training
OOP Training Course
Focus Training
 

 
 

Applicability:

This course is for database administrators who want to learn how to administer SQL Server 7.0, or who are preparing for the MCSE exam 70-028: Administering Microsoft SQL Server 7.0.
Get Certified!
Once you've completed your course, simply book the certification test online with Prometric.com, they have over 3,500 testing centres worldwide, they are also the provider for many of the most sought after professional qualifications, including: MCSE, CompTIA A+ and Cisco CCNA.
"Realistic Simulations"
So you can see how SQL Server 7.0 really works. All Courses also include pre and post-test which identifies individual strengths and weaknesses, allowing you to take only the units you haven't mastered and test how well you've mastered the completed Module.
   
 The Instant Mentoring window appears directly within your courses. Instant Mentoring allows you to type a question and receive a immediate response from a subject matter expert available 24/7 to help you succeed! MORE...
 
 

SQL Server 7 Admin Training

 
Windows Server 2003 Training
 
Try a
Demo
 
Usual Price
£245
Our
Price
12 Months Access:
UK:£149
US:$261
Eur:€219
 
 
  65%  
This series is designed to help users prepare for the MCSE Exam 70-028: Administering Microsoft SQL Server 7.0. The series covers a comprehensive array of topics, including planning a security strategy, SQL Server 7.0 system requirements, planning for system migration and replication, and server installation. System configuration, management of security, accounts, permissions, and the database, and backup and restores are also covered. Additional topics covered include the management of a variety of tasks, including replication, server jobs, events, alerts, linked servers, and remote servers; monitoring events, system optimization, and tuning resource usage. Server repair and troubleshooting strategies are also discussed.
  • EASY.....start your online training course within the hour
  • Available 24 hrs/day 7 days/week
  • High quality Web-based Training / e-Learning
  • Train ALL YEAR for 1 low price
   
Click the "Sign up Button" (above) to sign up for 12 months access to this course or buy our MCDBA Value Pack (this Course plus 8 other courses), if bought separately £1,192
Value Pack price:
Only £299! Save £893
MORE...  
 
SQL Server 7 Admin Modules Outline:  
SQL Server 7 Admin- Security Strategy
  • SQL Server Authentication Methods
  • Using Windows NT Groups
  • Planning the Use of SQL Server Roles
  • Developing a Security Strategy
  • Other Security Issues
SQL Server 7 Admin- System Requirements
  • Data File Placement and Space
  • Capacity Planning
  • Communication and Backup Strategies
  • Data Availability
SQL Server 7 Admin- Migration Planning
  • Planning an Upgrade
  • Upgrade Method and Upgrade Wizard
  • Migration Issues
  • Migrating Data from Other Sources
  • Using the Import Wizard
SQL Server 7 Admin- Replication Plans
  • Choosing a Replication Model
  • Additional Options
  • Choosing a Replication Type
  • Designing and Planning Replication
  • Data Definition Considerations
SQL Server 7 Admin- Installing the Server
  • Installation Prerequisites
  • Installing Components
  • Choosing Database Options
  • Installing Network Libraries & Protocols
  • Installing Services and Clients
SQL Server 7 Admin- Other Installations
  • Performing an Unattended Setup
  • Preparing for a Version 6.x Upgrade
  • Running the SQL Server Upgrade Wizard
  • Completing the Upgrade
SQL Server 7 Admin- Configuring
  • Using the Register Server Wizard
  • Configuring the Server
  • Configuring SQL Mail and ANSI Settings
  • Installing the Full-Text Search Service
  • Configuring the Full-Text Search Service
SQL Server 7 Admin- Security Management
  • Overview of SQL Server Security
  • Security Modes
  • Creating and Managing Logins
  • Database User IDs and Roles
  • Using the Create Login Wizard
SQL Server 7 Admin- Managing Accounts
  • Viewing ID Information
  • Viewing Roles
  • Managing Login IDs
  • Managing Database IDs and Roles
  • Server Roles and Management Procedures
SQL Server 7 Admin- Managing Permissions
  • Permissions
  • Permission Management Tools
  • Displaying Permissions Information
  • Granting and Revoking Permissions
  • Auditing Server and Database Activity
SQL Server 7 Admin- Database Management
  • Creating a Database
  • Managing Database Size
  • Database Options and Scripts
  • Managing and Deleting Databases
SQL Server 7 Admin- Loading Databases
  • The INSERT and SELECT INTO Statements
  • Bulk Copying Data
  • Importing and Exporting Data with DTS
  • Managing DTS Packages
SQL Server 7 Admin- Backups and Restores
  • Introduction to Backups
  • Database Backups
  • Differential Backups
  • Transaction Log Backups
  • Filegroup Backups
  • Backing Up System Databases
SQL Server 7 Admin- Managing Replication
  • Using Replication
  • Configuring Servers
  • Creating Publications
  • Subscribing to Publications
SQL Server 7 Admin- Management Tasks
  • Configuring the SQL Server Agent
  • Implementing Jobs
  • Multiserver Jobs
  • Managing Server Events
  • Linked Servers
SQL Server 7 Admin- Monitoring Events
  • Introduction to Monitoring
  • Understanding Trace Architecture
  • Creating Traces with the Trace Wizard
  • Creating Traces with Other Tools
  • Managing Traces
  • Analyzing Traces
SQL Server 7 Admin- Watching & Optimizing
  • Monitoring Disk I/O Performance
  • Monitoring CPU and Memory Usage
  • Other Monitoring Processes
  • Optimizing Server Performance
SQL Server 7 Admin- Server Repair
  • Overview of Troubleshooting
  • Solving Installation Problems
  • Solving Upgrading Problems
  • More About Upgrading Problems
  • Troubleshooting Server Access Problems
  • Troubleshooting SQL Server Permissions
SQL Server 7 Admin- More Troubleshooting
  • Troubleshooting Backups and Restores
  • Troubleshooting the SQL Server Agent
  • Troubleshooting Jobs and Alerts
  • Troubleshooting Replication
  • Linked Server Issues and Recovery Planning
 
           2006 © Sandline Learning Training Tutorials - e-Learning - Distance Learning - Self paced - Courses