Database Courses:
SQL Server 2000: Administration Training Course


Classroom Courses ~ Closed Courses ~ Onsite Courses ~ Training Passport ~ MCSE Courses ~ CBT Courses
Home Page ~ Contact ~ Training Centre ~ Course Schedule ~ Late Availability ~ Consultancy
   
    PTR Associates Ltd - Classroom Based Courses, Wokingham, Berkshire, uk
21a Peach Street, Wokingham, Berkshire, UK
Tel: 0118 979 4000       Fax: 0118 979 4035
Email:
training@ptr.co.uk      Web: www.ptr.co.uk
SAEVIT Button

SQL Server 2000: Administration Course


Course Description
This course teaches you how to install, configure, administer, and troubleshoot Microsoft SQL Server 2000 in a Windows 2000 Server environment. This course also assists you in preparing for the Microsoft Certified Systems Engineer and Microsoft Certified Database Administrator Exam #70-228, Installing, Configuring, and Administrating Microsoft SQL Server 2000 Enterprise Edition.

Course pre-requisites:
To ensure your success, we recommend you first take either the

Windows 2000 for Windows NT Administrators: or have equivalent knowledge.
scheduled dates / price

Topics covered on the 5 day SQL Server 2000: Administration course


Introduction to Microsoft SQL Server

  • Exploring the Components of SQL Server
  • Exploring the Features of Microsoft SQL Server
  • Identifying the Default Databases and System Tables
  • Understanding the SQL Server Architecture
  • Administering SQL Server
  • Identifying Administrative Utilities

Installing SQL Server

  • Identifying the Requirements for Installing SQL Server
  • Choosing the Hardware and Software for SQL Server 2000
  • Selecting Your Servers Hardware
  • Identifying Where to Install SQL Server
  • Choosing Installation Options for SQL Server
  • Installing SQL Server
  • Creating and Configuring a Service Account for SQL Server
  • Performing Unattended Installations
  • Using the SQL Server Service Manager to Manage the SQL Services
  • Exploring the SQL Server Installation
  • Starting SQL Server Enterprise Manager
  • Viewing the System Databases Within SQL Server Enterprise Manager
  • Creating and Working with a Database Diagram
  • Using SQL Server Enterprise Manager to Configure Your Server
  • Troubleshooting the SQL Server Installation
  • Testing the SQL Server Installation
  • Viewing the SQL Server Log

Designing & Implementing Databases

  • Developing a Strategy for Implementing Databases
  • Discussing SQL Server Terminology
  • Identifying the Space Requirements for Databases
  • Viewing Space Statistics
  • Optimizing Database Performance
  • Creating Databases
  • Using Transact-SQL to Create a New Database
  • Using SQL Server Enterprise Manager to Create a New Database
  • Changing the Default File group
  • Using SQL Server Enterprise Manager to Configure a Database
  • Using Stored Procedures to View Database Information
  • Managing Databases
  • Configuring SQL Server to Automatically Expand a Database
  • Manually Expanding a Database and its Transaction Log
  • Configuring SQL Server to Automatically Shrink a Database File
  • Deleting a Database

Creating & Managing Tables

  • Creating Tables
  • Designing Tables
  • Choosing Data Types for a Table
  • Identifying the Role of Constraints in a Table
  • Using SQL Server Enterprise Manager to Create a Table
  • Modifying the Structure of a Table
  • Using Transact-SQL to Work with Tables
  • Using the INSERT Statement to Add Rows to a Table
  • Using the UPDATE Statement
  • Using the DELETE Statement
  • Formatting Columns in a Query

Designing & Configuring SQL Server Security

  • Identifying the Security Features of SQL Server
  • Identifying the SQL Server Security Components
  • Configuring Your Servers Authentication Mode
  • Configuring Encryption
  • Creating Login Accounts
  • Creating a Login Account for a Windows Account
  • Denying Login Privileges
  • Creating and Testing a SQL Server Login Account
  • Assigning Login Accounts to Server Roles
  • Assigning Login Accounts as Database Users
  • Assigning a Login Account as a Database User in SQL ServerEnterprise Manager
  • Adding a Database User to a Database Role
  • Creating a User-defined Database Role
  • Implementing Statement and Object Permissions
  • Comparing Permission Types
  • Granting Statement Permissions
  • Granting Object Permissions
  • Denying Statement Permissions
  • Denying Object Permissions
  • Revoking Statement and Object Permissions
  • Creating and Using an Application Role
  • Creating and Using a View
  • Defining Linked Servers
  • Defining a Linked Server
  • Configuring Linked Server Security

Importing and Exporting Data

  • Introduction to Data Transfer
  • Comparing the Data Transfer Utilities
  • Creating a DTS Package by Using the DTS Import/Export Wizard
  • Using DTS Designer to Modify a Package
  • Bulk Data Transfers
  • Using bcp to generate a Transfer File
  • Using bcp to Import a Transfer File
  • Configuring XML Support
  • Creating a Virtual Directory for SQL Server
  • Running a URL Query

Backing Up SQL Server Databases

  • Planning Backups
  • Planning to Back Up Your Server
  • Reviewing the Backup Process
  • Backing Up Databases
  • Performing a Backup
  • Creating a Permanent Backup Device
  • Performing a Backup of the Master Database to a PermanentBackup Device
  • Performing a Parallel Backup of the Class_mgr Database
  • Performing a Filegroup Backup
  • Scheduling an Automatic Backup of the Msdb Database
  • Designing Your Backup Strategy

Restoring SQL Server Databases

  • Restoring User-defined Databases
  • Observing an Automatic Recovery
  • Reviewing User-initiated Database Recovery
  • Creating Tables and Backing Up
  • Simulating a Failed Database
  • Restoring the Class_mgr Database
  • Recovering System Databases
  • Simulating a Master Database Failure
  • Instructor Demo: Removing the Read-only Attribute From the SQL Server Installation Files
  • Restoring the Master Database

Automating SQL Server Administration

  • Configuring SQL Server to Send Mail
  • Verifying the Configuration of the SQL Server Agent Service
  • Instructor Demo: Configuring a Mailbox for the SQL Server Service Account
  • Creating a Mail Profile
  • Configuring SQL Agent Mail
  • Configuring the SQL Server Service to Send and Receive Mail
  • Using SQL Mail to Send Query Results
  • Defining SQL Operators
  • Using SQL Server Enterprise Manager to Define Operators
  • Specifying a Fail-Safe Operator
  • Managing Jobs
  • Creating a Job
  • Viewing Job History Information
  • Manually Running a Job
  • Running the Database Maintenance Plan Wizard
  • Managing Alerts
  • Creating an Alert
  • Configuring Event Forwarding
  • Troubleshooting Alerts

Designing, Configuring, and Managing Replication

  • Introduction to Replication
  • Identifying Publishable Information
  • Choosing a Replication Model
  • Choosing a Replication Strategy
  • Configuring Replication
  • Configuring a Publisher/Distributor
  • Configuring Distributor and Publisher Properties
  • Creating a Publication
  • Modifying a Publication
  • Configuring a Pull Subscription
  • Creating an Initial Snapshot for a Publication
  • Monitoring and Maintaining Replication
  • Using the Replication Monitor
  • Maintaining the Distribution Database
  • Creating Replication Scripts in SQL Server Enterprise Manager
  • Troubleshooting Replication
  • Examining Replication Information in the Error Logs

Implementing Fault Tolerance

  • Configuring Fault Tolerance in SQL Server 2000
  • Exploring Clustering

Monitoring SQL Server

  • Designing a Strategy for Monitoring SQL Server
  • Discussing Server Optimization and Monitoring Techniques
  • Identifying the Factors That Affect the Performance of SQL Server
  • Using Monitoring Tools
  • Observing Your Servers Current Activity
  • Using SQL Statements and SQL Server Enterprise Manager to Monitor Your Server
  • Using SQL Server Profiler
  • Using SQL Query Analyzer to Monitor a Query
  • Choosing a Monitoring Tool

view / print outline in pdf format
(click button to view / download course outline in printer friendly format)
(may take a few seconds to load)
This is an instructor led training course taught in a classroom based environment.

Course Classification:  Technical Training Course


Course Fee = £1475
   (excl.VAT)


Scheduled course dates
May 2008 June 2008 July 2008 August 2008 September 2008
12-1616-2021-2518-2222-26



If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite SQL Server 2000 Training and bespoke SQL Server 2000 courses


If you want to attend the course but can't make the dates published then click here for details of our one-to-one training packages.


The SQL Server 2000: Administration course qualifies for the PTR SAVE IT Scheme, which offers discounts on bookings for multiple courses and/or multiple delegates.

View SAVE IT Scheme Details




PTR Associates Limited

21A Peach Street, Wokingham, Berkshire, RG40 1XJ, United Kingdom
Tel: 0118 979 4000 Fax: 0118 979 4035
Email: training@ptr.co.uk
SQL Server 2000 Course Index & Training Schedule
More SQL Server 2000 Courses

SQL for Microsoft SQL Server Course

Advanced SQL, Stored Procedures & Triggers for Microsoft SQL Server Course

SQL Server 2000: Database Design Course

SQL Server 2000: Administration Course

Microsoft SQL Server Audit & Security Course

Populating a Data Warehouse with Microsoft SQL Server 2000 Data Transformation Services Course

Implementing Business Logic with MDX in Microsoft SQL Server 2000 Course

SQL Server Performance & Tuning Course

C Programming Courses
Cisco Courses
Citrix Courses
CIW Courses
CompTia Courses
Database Courses
Exchange Server Courses
Fortran Courses
Internet Courses
Java Courses
JSP Courses
Linux Courses
MCSD Courses
MCSE Courses
Microsoft Courses
Microsoft .NET Courses
Microsoft Access Courses
Microsoft Excel Courses
Microsoft Outlook Courses
Microsoft Powerpoint & Visio Courses
Microsoft Project Courses
Microsoft Server Products Courses
Microsoft Word Courses
Networking Courses
Oracle Courses
Perl Courses
Programming Courses
Security Courses
SQL Courses
SQL Server 2000 Courses
SQL Server 2005 Courses
Unix Courses
VBA Courses
Visual Basic Courses
Windows 2000 Courses
Windows Server 2003 Courses
Windows Vista Courses
Windows XP Courses
XML Courses