SQL Server 7.0 Upgrade and Migration(MOC Course No.1131) - Microsoft Training Courses London South West UK

Reserve a Place
28 Feb London
30 Mar London
25 Apr London
23 May London
20 Jun London
18 Jul London
15 Aug London
12 Sep London
10 Oct London
14 Nov London
12 Dec London
09 Jan London

View Other Courses in Same Category
Microsoft SQL Server 7.0 Overview (1140)
Designing and Implementing a Data Warehouse Using Microsoft SQL Server 7.0 (1502)
Accelerated Training for Microsoft SQL Server 7.0 (1634)
Optimizing Microsoft SQL Server 7.0 (2013)
Querying Microsoft SQL Server 2000 with Transact-SQL. (2071)
Administering a Microsoft SQL Server 2000 Database (2072)
Programming a Microsoft SQL Server 2000 Database (2073)
Designing and Implementing OLAP Solutions with Microsoft SQL Server 2000 (2074)
Building XML-Enabled Applications Using Microsoft SQL Server 2000 (2091)
Populating a Data Warehouse with Microsoft SQL Server 2000 Data Transformation Services (2092)
Implementing Business Logic with MDX in Microsoft SQL Server 2000 (2093)
Implementing Replication Using Microsoft SQL Server 2000 (2591)
Microsoft SQL Server 2000 for Experienced Database Professionals (2723)
System Administration for Microsoft SQL Server 7.0 (832)
Implementing a Database on Microsoft SQL Server 7.0 (833)
Updating Your Database Development Skills to SQL Server Yukon (2734)
Updating Your Database Administration Skills to SQL Server Yukon (2733)
Creating Reporting Solutions using Microsoft SQL Server 2000 Reporting Services (2030)

SQL Server 7.0 Upgrade and Migration - (MOC Course No.1131) - 3 days; £1185 Ex VAT

Target Audience	Pre-requisites
Purpose	Print 2 Page Flyer

COURSE OUTLINE

Introduction to Microsoft SQL Server 7.0	Changes to the SQL Server Architecture
Changes to Administrative Functions	Changes to Transact-SQL
New SQL Server Components	Upgrading to SQL Server 7.0
Migrating Databases to SQL Server	Particulars

Target Audience: This course is intended for database administrators and system engineers with experience working with Microsoft SQL Server 6.x, who are responsible for upgrading an installation or migrating data to Microsoft SQL Server 7.0. Pre-requisites: This course requires that students meet the following prerequisites: Course 867, System Administration for Microsoft SQL Server 6.5, or working knowledge of setting up security, creating devices and databases, backup and recovery, and the import and export of data using the bulk copy utility. Course 750, Implementing a Database Design on Microsoft SQL Server 6.5, or working knowledge of creating indexes, managing locking, retrieving data, and creating views, stored procedures, and triggers. Course 689, Supporting Microsoft Windows NT Server 4.0—Enterprise Technologies, or equivalent knowledge. Minimum of one year of experience with SQL Server 6.5. Experience using SQL Server Enterprise Manager, ISQL/w, and isql Purpose: At the end of this course, the student will be able to install Microsoft SQL Server 7.0; use the new and changed features of SQL Server 7.0; upgrade an existing SQL Server 6.x installation to version 7.0; migrate data and databases from various data sources to SQL Server 7.0.

Module 1: Introduction to Microsoft SQL Server 7.0

Why SQL Server Changed
Increased performance
More efficient storage engine
Componentization of architecture
Windows NT 5.0 Integration
Reduced cost of ownership
Dynamic resource management
Improved Management tools
Multi-site administration
Improved scalability
Very large database support
Microsoft Access 2000 integration
Microsoft Windows 95/98 support
Improve data warehousing capabilities
Built in Data Transformation Services
Built in OLAP Server
Graphical query processing
English Query support
Microsoft Repository
SQL Server 7.0 Installation Changes
New hardware and software requirements
Improved SQL Server installation options
Easier SQL Server Setup
SQL Server Enterprise Manager

Top

Module 2: Changes to the SQL Server Architecture

Security Architecture
Simpler Authentication Modes
Easier login account creation
Fixed Server Roles
User-defined Roles
Application Roles
Simplified object ownership
Introduction to Course Databases
Northwind
Credit
Storage Architecture
Database changes
sp_dboption changes
Moving databases between servers
New Page, Extent, and Table structures
Improved Transaction Log
Files and Filegroups support
Unicode Support
Data types
Changes to Char, VarChar, Binary, Bit, Text, Image, Numeric, Decimal datatypes
Better Ansi Null options
New Unicode data types
Support for GUIDs with UniqueIdentifier
Excellent Cursor support
New Index architecture
Query Processing
Graphical Query Processing
Read-ahead processing
Ad hoc query caching
Stored procedure processing
Processing Strategies
Sort operations
Join and group operations
Parallel queries
Index processing
Statistics management
Full-text search
Lock Management
Comparing Transaction Isolation levels
Row level locking
Memory Management

Top

Module 3: Changes to Administrative Functions

Backup and Restore
Who performs backups
Where to store backups
Multiple backup files
Dynamic backup process
Differential backup
File and Filegroup backups
Restore process
Restoring from a differential backup
Restoring from a file or Filegroup backup
Restoring damaged system databases
Automation
Jobs and Job steps
Performance Condition Alerts
SQLMail and SQL Server Agent
Mail Sessions
Database Maintenance Wizard
Replication
Immediately Updating Subscribers
Merge Replication
Monitoring and Tuning
DBCC
Processing
Commands
Index Tuning Wizard
Profiler
Ad-hoc Performance Monitor Counters

Top

Module 4: Changes to Transact-SQL

New Keywords
Commands
Syntax
Options
Changes for ANSI Compliance
Information Schema Views
ANSI Keywords
CAST
COMMIT/ROLLBACK WORK
PRIVILEGES
ODBC ANSI Settings
NULL
QUOTED IDENTIFIERS
Changes to Objects
New object-information functions
Referencing local and remoteObjects
Identifiers
Object Ownership
Changing Object Owners
Tables
Columns
Indexes
Views and Stored Procedures
Triggers
Cursors
Distributed Queries
Linking to a remote data source
Setting Up Linked Server Security
Getting information about linked servers
Changing a data source from a remote server to a linked server
Ad hoc queries
Linked server queries

Top

Module 5: New SQL Server Components

Data Transformation Services (DTS)
DTS Overview
DTS Processes
DTS Tools
Transferring Data with DTS
Restructuring and Mapping Data
Defining Transformation Steps
Defining Workflow
Creating a DTS Package
Executing and Scheduling a DTS Package
Full-text search
Installing full-text search
Creating a full-text index
Using full-text search
English Query
Installing English Query
Identifying Query Terms
Using English Query
OLAP Server
Introduction to OLAP Server
Installing OLAP Server

Top

Module 6: Upgrading to SQL Server 7.0

Steps in Upgrading
Version Upgrade Wizard
Considerations when upgrading TempDb: size and location
Upgrading SQL Server Enterprise Edition
Installing on dual-boot computers
Loading a 6.5 database
Running multiple instances of SQL Server
Expected upgrade issues
Troubleshooting an Upgraded Database
Specifying a Database Compatibility Level
Unattended Upgrades
Customizing Upgrades
Considerations in Upgrading an Application to SQL Server 7.0

Top

Module 7: Migrating Databases to SQL Server

Migrating an Access Database to SQL Server
Considerations when Migrating
Migration Process
Migrating a non-Microsoft relational database to SQL Server
Oracle & Sybase & Informix

Top

PARTICULARS:

Cost:	£1185 (€1647) excluding VAT
Numbers:	Maximum of 6 people on each course at F1’s training facilities in London, Bath or Onsite Call Free on 0800 169 1890 Print 2 Page Flyer Last Modified 08 February 2005