0800 282 353 or +44 1372 364610
TRAINING YOU CAN TRUST
 
 

SQL Server 2000 Database Administration: Hands-On

 
Course: 531   Type: Hands-On Training   Duration: 5 Days
 
 

You Will Learn How To

  • Effectively administer SQL Server 2000 using Enterprise Manager and Transact-SQL
  • Install multiple SQL Server instances
  • Utilise SQL Server recovery models to back up and restore databases
  • Manage multistep jobs with SQL Server Agent
  • Manage SQL Server login, database and object security
  • Set up transactional replication

Course Benefits

Microsoft SQL Server 2000 provides extensive administration capabilities that improve the scalability, reliability and availability of this enterprise class DBMS. To effectively administer SQL Server, DBAs must learn how to take advantage of its rich and robust feature set. In this hands-on course, you gain practical experience performing real-world administrative tasks.

Who Should Attend

Administrators, engineers, consultants, analysts and others. Course 530, "SQL Server 2000 Comprehensive Introduction", or equivalent experience is assumed.

Hands-On Training

Extensive hands-on exercises provide you with experience administering SQL Server 2000, including:
  • Administering SQL Server with graphical tools and Transact-SQL
  • Installing multiple SQL Server instances
  • Creating databases
  • Backing up and restoring databases
  • Maintaining a warm standby server
  • Setting up jobs and defining alerts
  • Implementing login, database and object security
  • Managing transactional replication
  • Participants recovering a failed SQL Server

Related Courses

  • 532 SQL Server 2000 Transact-SQL Programming
  • 534 SQL Queries for SQL Server
  • 535 High-Performance SQL Server Databases
  • 523 SQL Server Reporting Services
  • 539 Deploying Clusters on Windows Server 2003
  • 315 Developing User Requirements
  • 284 Critical Thinking and Problem Solving

This course helps you prepare for Microsoft professional certification exam(s).

 
SQL Server is a trademark of Sybase, Inc.
   SQL Server 2000 Database Administration

Upcoming Dates

20 - 24 Oct, 2008
London
2 - 6 Feb, 2009
London
18 - 22 May, 2009
London

For complete schedule, please visit www.learningtree.co.uk
 
http://www.learningtree.co.uk/courses/uk531.htm
 
 
0800 282 353 or +44 1372 364610
TRAINING YOU CAN TRUST
 
 

SQL Server 2000 Database Administration: Hands-On

 
Course: 531   Type: Hands-On Training   Duration: 5 Days
 
 
Course Content
 

SQL Server 2000 Components

  • Services
  • Editions
  • Enterprise Manager and Transact-SQL
  • System and user databases

Installing and Upgrading SQL Server

SQL Server 2000 installation

  • System requirements
  • Choosing installation options
  • Managing multiple instances
  • Installing on a cluster
  • Applying a service pack

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

  • Windows vs. SQL Server authentication
  • Creating logins
  • Working with server roles
  • Running the Microsoft Baseline Security Analyser

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

Implementing Replication

Replication concepts

  • Publish/subscribe metaphor
  • Replication types
  • Replication agents

Managing transactional replication

  • Configuring the publisher
  • Creating publications
  • Setting up subscribers

Monitoring SQL Server

Analysing resource contention

  • Managing concurrent users
  • Identifying blocking problems

Monitoring server activity with SQL Profiler

  • Studying deadlock situations
  • Capturing problem queries

Converting and Migrating Data

Employing bulk methods

  • bcp
  • BULK INSERT
  • SELECT INTO

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
 
http://www.learningtree.co.uk/courses/uk531.htm
 
 
0800 282 353 or +44 1372 364610
TRAINING YOU CAN TRUST
 
 

SQL Server 2000 Database Administration: Hands-On Tuition

 
Course: 531   Type: Hands-On Training   Duration: 5 Days
 
 

Course 531 Tuition

£ 1,995Standard Tuition
Tuition with a Savings Plan
£ 1,22510-Day Training Pass
£ 915Flex-Training Pass
£ 1,46010-Training Vouchers
£ 1,5605-Training Vouchers
£ 1,795Alumni Gold Tuition

Your Course Fee Entitles You To...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Lunch
  • Course Completion Certificate
  • FREE participation in the Learning Tree Professional Certification Programmes (including related exams)
  
 

Tuition Savings Plans

Flex-Training Pass
  • 3 Courses for £2 750
  • As little as £915
  • Savings as much as 50%
  • 3 courses in 24 months
10-Day Training Pass
  • Save as much as £770 per course
  • Any combination of courses
  • Only £2,450
Training Vouchers
  • Save as much as £535 per course
  • Fully transferable
  • As low as £1,460 per course
Alumni Gold Discount Attend your first course and you will receive a personalised Alumni Gold Discount card, entitling you to save as much as £200 on each course you take in the following 24 months. Take just one course every two years, and you will be entitled to ongoing discounts...year after year. You save 10%.
* Exact savings may vary depending on courses selected.

Your Guarantee of Satisfaction

Unless you feel 100% satisfied that Learning Tree delivered even more than you expected, there is no fee for your course attendance. Our Guarantee of Quality lets you experience the value of the course - and then pay only if you feel the course was well worth the fee.

Enrolling is Easy and Flexible!

Enrol by phone or online. If your plans change, just let us know and, without a fee, you can transfer to another course or cancel your enrollment. Pay after you've taken the course, and then only if you are 100% satisfied.
 
http://www.learningtree.co.uk/courses/uk531.htm