SQL Server 2000

Duration : 8 Weeks

Price : £590

Tutors : Dr V Moham PhD, S Arul CIW

Course Benefits
Microsoft SQL Server 200 provides extensive administration capabilities to improve the reliability availability and scalability of this enterprise class RDBMS. It also offers XML integration and improved data transformation and analysis. This course offers a hands-on experience to gain skills that are required to administer SQL Server 2000 effectively in an enterprise environment.

Course Pre-requisites
Knowledge of Windows NT / 2000 networking would be beneficial.

Course Content

SQL SERVER 2000 INSTALLATION
System requirements
Choosing installation options
Managing multiple instances
Installing on a cluster
Applying a service pack

Transact-SQL

Retrieving data with Transact-SQL
Adding, Changing and Deleting Information in Tables
Indexes and Keys
Transactions and Locking
Rules, Constraints and Defaults
Stored Procedures
Flow-Control Statements

UPGRADING PREVIOUS VERSIONS
Preparing for the upgrade
Migrating from 6.5 and 7.0

SETTING UP CLIENTS
Choosing network libraries
ODBC
OLE DB
Resolving connectivity problems
Connecting to named instances
Storage Management

DISK STRUCTURES
Defining files
Creating databases and transaction logs

SPACE MANAGEMENT STRATEGIES
Managing dynamic database growth
Reclaiming unused space
Backup and Recovery
Transaction log architecture
Choosing a recovery model
Performing full, log and differential backups
Recovering system and user databases
Scheduling Jobs and Alerts

THE SQL SERVER AGENT
Configuring the Agent
Setting up SQL Mail

MULTISTEP JOBS
Defining jobs to handle routine tasks
Creating alerts and operators
Associating alerts with jobs
Managing Security

LOGIN SECURITY
NT authentication vs. SQL Server authentication
Creating logins
Working with server roles
Establishing a secure SQL Server

DATABASE SECURITY
Adding users
Defining new roles
Taking advantage of pre-defined roles
Assigning users to roles

OBJECT SECURITY
Ownership
Granting permissions
How roles and permissions interact

MONITORING SQL SERVER
Resolving contention problems
Studying server activity with SQL Profiler
Implementing Replication

REPLICATION CONCEPTS
Publish/subscribe metaphor
Replication types
Replication agents

MANAGING TRANSACTIONAL REPLICATION
Configuring the publisher
Creating publications
Setting up subscribers
Converting and Migrating Data

DATA TRANSFORMATION SERVICES (DTS)
Importing data using the GUI
Transforming data with simple scripts

COLLECTING DATA FROM MULTIPLE SOURCES
Configuring linked servers
Issuing distributed queries

DEVELOPING APPLICATION WITH MS SQL SERVER
Developing Application to work with SQL Server
Understanding SQL Server and the Internet
Accessing SQL Server Databases through Front-End Products
Upsizing Microsoft Office 97 Applications to SQL Server

Course Delivery Method
Initially, students receive introductory classes on the fundamentals of Microsoft SQL. This is followed by theoretical classes (40 percent of study-time), demonstrations (10%) and computer based training and practising using structured exercise manuals (50%).