Want to boost enrolments? Login and promote your courses
Searching for courses? Login or register
Courses    
  Most popular search | Share this page  
open My list: 0 courses
Homepage IT, Computing, Telecommunications Courses Database Administration Courses SQL Server Courses

SQL Server 2000: Administration

in PTR Associates Ltd (England)

Classes Course

Place:

Wokingham

Price:

£1,475 + VAT

Duration:

5 Days

Start:

14/12/2008 calendar
See course programme

Requirements:

To ensure your success, we recommend you first take either the Windows 2000 for Windows NT Administrators: ... see more

Request free information

Course objectives:

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.

More courses Subject area
Place
 

Request information

Contact directly and with no obligation with
PTR Associates Ltd
You must complete all fields on this form in order for us to send it to the course provider.
We have highlighted incomplete/ incorrect details in red.
* Compulsory fields
By clicking "Email request / Telephone" you registering and accepting the Terms of Use and privacy policy of Emagister.
I wish to receive the personalised newsletter (during a maximum period of 15 days)

Availability?
How do I enrol?
Where can I get more information?

The person in charge of this course will receive your information request instantly.

Response time:
:| :) ;)
Average Fast Very fast
 

Course details

Type Course Duration 5 Days
Method / place Contact course provider Classes in Wokingham where
Course objectives 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.
Requirements
To ensure your success, we recommend you first take either the Windows 2000 for Windows NT Administrators: or have equivalent knowledge.
Price £1,475 + VAT
Get direct information on how to enrol, venues and availability...

SQL Server courses (from other course providers)

 
SQL Server 2000 Admin MCDBA MCSA MCSE 70-228
We Teach You
Distance - £50 + VAT
 
SQL for the web
ACS Distance Education
Distance - £280 + VAT
 
Sql Server 2000 Database Design Mcse 70-229 Series
Sales 101 Ltd
Online - £75 + VAT
 
Server+
focus4training
Multimedia - £298 + VAT
 
Database Administration
Futures Development Limited
Blended - Price: On request
Compare the selected courses

Course programme

SQL Server 2000: Administration
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
  • see the full course programme

    on request

    get more information on the programme directly from PTR Associates Ltd.

    Request information for free
    Get direct information on how to enrol, venues and availability...
     

    Venues and dates



    Where Wokingham, 21a Peach Street see map
    When Start: 14/12/2008 Finish: 18/12/2008 See calendar
     
    Get direct information on how to enrol, venues and availability...
     

    Ex-students

     
    Opinions
     
    Have you attended this course?

    Voice your opinion and help thousands of other users

    opinions

    from users who have attended
    this course.
    Get direct information on how to enrol, venues and availability...
     

    On PTR Associates Ltd

    Provider description
    PTR specialises in technical training, particularly in the areas of data communications & networking, internet/intranet, operating systems, programming languages and relational databases. Company specific courses are available for organisations that have several employees who all need training at the same time or who have a requirement for a tailored course. Closed courses typically provide cost benefits when there are at least four employees who need training simultaneously. Courses can be run at PTR's Training Centre or on-site if suitable facilities exist. Benefit from substantial discounts on technical training with our SAVE IT Scheme. If you, or your organisation has a training requirement of 10+ days then our Save IT Scheme may provide additional savings on your training.
    Advantages of studying with PTR Associates Ltd
    Vendor-independent & Generic Training - unbiased independent knowledge Small Class Sizes - increased interaction with lecturer Hands-on - increased learning efficiency Training Environment - modern, air-conditioned classrooms Course Notes - up-to-date, plain English, excellent reference material Training Experience - friendly, personal service
    Refreshments - morning and afternoon breaks with lunch arrangements second to none, at one of the many local restuarants ROI - our prices and quality mean an excellent Return on Investment   Lecturer Expertise - vendor certified with real-world product experience
    Course provider history
    PTR Associates Ltd was established in 1989.
    Specialises in
    Applications Programming Databases Operating Systems Data Communications and Networking Internet Scripting

    All courses

    by PTR Associates Ltd on emagister.

    See list of courses

    Get direct information on how to enrol, venues and availability...

    Training related to SQL Server

     
    International sites Spain  |  Italy  |  France  |  Mexico  |  Germany  |  UK  |  Japan  |  Argentina

    Words related to the courses viewed: sql sql server

    emagister.com complies with the 15/1999 Organic Law dated 13th December (Spain), the Data Protection Law and holds the inscription code 2002010053 on the General Register of the Data Protection Agency. Copyright 1999/2000 - Grupo Intercom - All rights