.net c# vb.net delphi sql server asp java coldfusion web developer training course class uk floridaC# training course FLC#.net training course FLC# 2005 training courseSQL Server 2005 training course.net c# vb.net delphi sql server asp java coldfusion web developer training course class uk florida
.net c# vb.net delphi sql server asp java coldfusion web developer training course class uk floridaASP.NET training courseASP.NET 2.0 training courseDelphi training course FLtraining course FL UK.net c# vb.net delphi sql server asp java coldfusion web developer training course class uk florida

ASP.Net training

C#.Net training

VB.NET training

SQL Server training

ADO.NET training

Java training

Delphi training


Web Tech, UK
+44 (0) 1452 814 303

Web Tech, USA


Quick Search:


SQL101 - SQL Server 7.0 System Administration Call for schedule    
Cost / Duration Price: US $1,995, UK £1,495 + VAT | Duration :4 days


An understanding of basic relational database concepts. Knowledge of basic Transact-SQL syntax (SELECT, UPDATE and INSERT statements). Familiarity with the role of the database administrator.

Who Should Attend?

This course is designed for support personnel, database analysts, database administrators, or those whose role involves the setting up, administrationm tuning, and day to day maintenance of SQL Server.
Course Benefits

This course provides delegates with the knowledge and skills required to install, configure, administer and troubleshoot Microsoft SQL Server. The course provides extensive hands-on practical experience to build and develop competence and abilities in tasks such as installation, backup, recovery and managing security using SQL Server's tools.

You Will Learn How To

  • Plan for a SQL Server installation
  • Install SQL Server
  • Configure SQL Server, manage files and databases
  • Choose a login security method
  • Configure login security
  • Plan and implement database permissions
  • Back up databases
  • Restore databases
  • Automate administrative tasks using SQL Server Agent
  • Import, export and transform data
  • Monitor and maintain SQL Server performance
  • Replicate data from one SQL Server to another

Course Content













SQL Server Overview
What is Microsoft SQL Server | SQL Server architecture | SQL Server security | SQL Server databases | Working with SQL Server

Installing and Configuring
SQL Server | Minimum hardware and software requirements | SQL Server installation options | Running the SQL Server setup program | Verifying the installation | Preparing to use SQL Server | Troubleshooting

Managing Security
Implementing an authentication mode | Assigning login accounts to users and roles | Assigning permissions to users and roles | Planning security | Managing application security

Managing Database Files
Introduction to databases | Creating databases | Modifying databases | Managing databases on multiple disks | Capacity planning

Backing Up Databases
Preventing data loss | SQL Server backup | When to back up databases | Performing backups | Types of backup methods | Planning a backup strategy

Restoring Databases
SQL Server recovery process | Preparing to restore a database | Restoring backups | Restoring databases from different backup types | Using a standby SQL Server | Restoring damaged system databases

Automating Administrative Tasks
Reasons to automate | Introduction to SQL Server automation | Automating routine maintenance tasks | Creating alerts | Troubleshooting

SQL Server automation
Automating multiserver jobs | Publishing database data on the Web

Transferring Data
Introduction to importing and exporting data | Tools for importing and exporting data in SQL Server | Introduction to data transformation services (DTS) | Transferring data with DTS

Monitoring and Maintaining SQL
Why monitor SQL Server | Tools for monitoring SQL Server | Creating a maintenance plan for SQL Server

Introducing Replication
Introduction to distributed data | Introduction to SQL Server replication | SQL Server replication agents | SQL Server replication types | Physical replication methods

Planning and Setting Up Replication
Planning replication | Configuring network security access | Preparing the servers | Publishing | Subscribing

Managing Replication
Monitoring and troubleshooting replication | Replicating in heterogeneous environments | Publishing on the Internet

Copyright 1990 - 2013 - WebTech Training & Development - All Rights Reserved


home ] contact ] courses ] register ]