COURSE SEARCH
 
   HOME > COURSE > MICROSOFT SQL SERVER 7.0 NEW FEATURES 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 7.0 New Features



Course Aims
This intensive course introduces the new features of Microsoft SQL Server 7.0. It covers the issues involved in installing SQL Server 7.0 and upgrading from previous releases; focuses on the improved user interface and data management tools; discusses changes to the security model and application development platform; and summarizes the new design elements and architecture of SQL Server 7.0.
Assumed Knowledge
Experience of SQL administration, such as that gained on an SQL Server 6.x Administration course, and basic administration experience with Windows NT.
Course Audience
Experienced SQL Server 6.x users.

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

Table of Contents
Installing Version 7.0 and Upgrading from 6.5
  		• Pre-Installation Check List
  		• Pre-Requisites
  		• Installing SQL Server 7.0
  		• Migrating from 6.5
  		• Installed SQL Server Components
  		• Migrating and Testing SQL Server 6.x with 7.0
     
    New and Improved SQL Server Tools
  		• SQL Server Service Manager
  		• User Interface
  		• SQL Server Enterprise Manager Wizards
  		• Improved Task Management
  		• SQL Server Query Analyser
  		• Import and Export (Data Transformation Services)
  		• SQL Server Profiler
  		• The Index Tuning Wizard
  		• Improved Web Assistant
  		• Microsoft English Query
  		• OLAP Services
     
    What's New for Developers
  		• New Database Structure and Data Dictionary Changes
  		• Data Definition Changes
  		• Calculated Columns
  		• New Query Tools
  		• New Transact SQL Statements
    What's New for Administrators
  		• Easier Configuration
  		• Data File Management
  		• AutoStats
  		• New Security Features
  		• Better NT Integration
  		• Fixed Server Roles
  		• Fixed Database Roles
  		• User-Defined Roles
  		• Grant, Revoke and DENY
  		• Application Roles
  		• New Backup/Restore Features
  		• Fuzzy Backup
  		• New Restrictions
  		• The New Backup Types
  		• Automating Jobs
  		• What's New in Replication
    TRY BEFORE YOU BUY BECOME A RESELLER TERMS & PRIVACY
    Saturday 13th March 2010  © COPYRIGHT 2010 - VISUALSOFT