1-800-THE-TREE (1-800-843-8733)
 

SQL Server 2000 Database Administration: Hands-On

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

Quick Enroll    

You Will Learn How To
  • Effectively administer SQL Server 2000 using Enterprise Manager and Transact-SQL
  • Install multiple SQL Server instances
  • Utilize 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
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 these capabilities. In this hands-on course, you gain practical experience performing real-world administrative tasks.

Who Should Attend
Administrators, engineers, consultants, analysts and others can benefit from this course. 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

Course 531 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 Analyzer
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
Analyzing 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

Related Courses
SQL Server is a trademark of Sybase, Inc.
  
 
Request More Info

Salutation

First Name

Last Name

Company

Zip Code

Country
   Codes
Work Phone

Extension

E-mail

A representative will contact you to follow up your request.
Privacy Statement

Save as much as $2,350 on a Triple-Pack!

SQL Server 2000 Database Administration: Hands-On
Upcoming Dates
Jun 9 - 13, 2008
 Washington, DC (Rockville, MD)
Jul 21 - 25, 2008
 New York

SQL Server 2000 Database Administration: Hands-On
Bring Learning Tree On-Site

Course Tuition
$ 2,950 Standard Tuition
Tuition with a Savings Plan
$ 2,075 10-Day Pass
$ 1,665 Training Passport
$ 1,830 Flex-Pass
$ 2,095 Voucher 10-Pack
$ 2,655 Alumni Gold Discount
$ 2,620 Government Discount
 

 

SQL Server 2000 Database Administration: Hands-On
SQL Server 2000 Database Administration: Hands-On
Participants recovering a failed SQL Server.

Certification Core Course CPE 29 Credits Vendor Cert - Microsoft 2 Hour(s) College Credit
Customer Service or Enroll: 1-800-843-8733