COURSE SEARCH
 
   HOME > COURSES > MICROSOFT SQL SERVER 6.5 INTRODUCTION MEMBERS LOGIN 
UNLIMITED ACCESS TO OVER 575 ONLINE TRAINING COURSES FOR ONE ANNUAL PAYMENT OF ONLY $149 USD
BUY NOW
  HOME     COURSE LIBRARY     QUESTIONS & ANSWERS     CONTACT US
There are many excellent online courses. This has been hugely beneficial in my day to day work.
- Louise Nolan


Microsoft SQL Server 6.5 Introduction




Course Aims
At the end of the course, readers will be able to install and configure SQL Server version 6.5; manage the storage requirements of a database and perform day-to-day operations including backing up and restoring a database, recovering from a system disaster, scheduling tasks, setting alerts, monitoring, and tuning. The basics of Transact SQL are also covered.
Assumed Knowledge
A good knowledge of Windows NT Server gained either through attendance on a "Windows NT Server Systems Support" course or from experience in the workplace. An understanding of client server computing would be useful.
Course Audience
New, recent or intending MS SQL Server Systems Administrators.

This course can be found in the following categories:
Courses > Databases > SQL Server Database
Courses > Microsoft > SQL Server

Table of Contents
SQL Server Feature
  		• Overview and History
  		• Relational Database Overview
  		• Organising Data into Tables
  		• Primary Keys and Foreign Keys
  		• Client/Server Architecture
  		• A Brief History of SQL Server
  		• SQL Server 6.5 New Features
  		• The Future of SQL
  		• SQL Server Components
     
    Installing and Upgrading SQL Server 6.5
  		• Server Prerequisites
  		• Where to Install SQL Server 6.5
  		• Client Prerequisites
  		• Planning an Installation
  		• Sort Order
  		• The SQL Set-up program
  		• Troubleshooting an Installation
  		• Upgrading SQL Server 4.2 and Below
  		• Initial Configuration
     
    Data Storage and Management
  		• How Data is Organised in SQL Server and Windows NT
  		• Creating Database Devices
  		• Extending a Database Device
  		• Removing Devices
  		• Default Devices
  		• Creating Databases and Logs
  		• Planning Database Scope
  		• What Happens When you Create a Database?
  		• Database Options
  		• Optimal Placement of Data and Logs
  		• Managing Growth of Data and Log Space
  		• Segments and Segmaps
    Safeguarding Against Data Loss
  		• Planning SQL Server Fault Tolerance
  		• SQL Server Mirroring
  		• Automatic Recovery
  		• File-Level Backup Versus SQL Server Backup
  		• Planning a Backup Strategy
  		• Backing Up System Databases
  		• Implementing a SQL Server Backup Strategy
  		• Online Backup
  		• Improving the Performance of Large Backups
  		• Recovering a Database
     
    Troubleshooting, Monitoring and Optimizing
  		• Troubleshooting SQL Server
  		• Monitoring SQL Server 6.5
  		• Monitoring the Query Mix with SQL Trace
  		• Optimizing SQL Server 6.5
  		• Hardware Optimization - Memory, CPUs and Disks
  		• Windows NT Optimization
  		• Monitoring NT Through Performance Monitor
  		• SQL Server Configuration Options
     
    Transact SQL
  		• Structured Query Language
  		• Transact SQL
  		• Basic SELECT Statement
  		• Selecting Fields and Expressions
  		• Restricting Duplicates
  		• Transact SQL built-in Functions
  		• Functions By Category
  		• Using the CASE statement
  		• The WHERE Clause
  		• ORDER BY
  		• Summary Queries
  		• Sub-Queries
    TRY BEFORE YOU BUY BECOME A RESELLER TERMS & PRIVACY
    Monday 21st May 2012  © COPYRIGHT 2012 - website design by Website Design by Visualsoft