(<img height='1' width='1' border='0' src="http://www.googleadservices.com/pagead/conversion/1072619999/?value=1&label=Lead&script=0" />)
F1
About F1Course ScheduleOther ServicesSite MapContactHome

SQL Server 7.0 Upgrade and Migration

Exchange Server
Office (inc Access)
SQL Server
Visual Studio .NET
Windows
Web Development
Visual FoxPro
Programming
Business
Knowledge Management
Certification
Learning Options
Reserve a Place
No scheduled Course : Contact for Details
View Other Courses in Same Category

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
.

Exams:

  • There are no exams directly associated with this course

Price Options ex VAT:

Classroom Training
?		 Distance Learning
?		 eLearning Options
?		 Book Learning
?
£ 1185
(€1683) 		£ 674.00
(€957) 		- No Books Supported for Course at present

Call Free on 0800 169 1890
Print 2 Page Flyer
Last Modified 01 May 2008