Administering a Microsoft SQL Server 2000 Database

Course Details:

  • Days: 5
  • Course Code: MS2072
  • Booking: Please ring 08450 50 45 05



Overview

This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft SQL Server™ 2000. Course 2072 is a revision of Course 832, System Administration for Microsoft SQL Server 7.0.


Leads to examination

  • 70-228 - Installing, Configuring, and Administering Microsoft SQL Server™ 2000 Enterprise Edition


Prerequisites

  • Before attending this course, students must have:

    • Experience using the Microsoft Windows® 2000 operating system to: • Connect clients running Windows 2000 to networks and the Internet.
    • Configure the Windows 2000 environment.
    • Create and manage user accounts.
    • Manage access to resources by using groups.
    • Configure and manage disks and partitions, including disk striping and mirroring.
    • Manage data by using NTFS.
    • Implement Windows 2000 security.
    • Optimize performance in Windows 2000.

    For students who do not meet these prerequisites, the following courses provide students with the necessary knowledge and skills:• Course 2151, Microsoft Windows 2000 Network and Operating System Essentials

    • Course 2152, Implementing Microsoft Windows 2000 Professional and Server
    • An understanding of basic relational database concepts, including: • Logical and physical database design.
    • Data integrity concepts.
    • Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many).
    • How data is stored in tables (rows and columns).

    For students who do not meet these prerequisites, the following course provides students with the necessary knowledge and skills:• Course 1609, Designing Data Services and Data Models

    • Knowledge of basic Transact-SQL syntax (SELECT, INSERT, UPDATE, and DELETE statements).For students who do not meet these prerequisites, the following course provides students with the necessary knowledge and skills:• Course 2071, Querying Microsoft SQL Server 2000
    • Familiarity with the role of the database administrator.

 

Delegates will learn how to

  • Plan for a SQL Server installation, and then install an instance of SQL Server
  • Manage files and databases, including determining resource requirements
  • Choose a login security method, configure login security, plan and implement database permissions, and describe how to secure SQL Server in an enterprise network
  • Choose a login security method, configure login security, plan and implement database permissions, and describe how to secure SQL Server in an enterprise network
  • Perform and automate administrative tasks and create custom administrative tools
  • Monitor and optimise performance
  • Back up databases and implement a backup strategy


Outline

  • Module 1: SQL Server Overview
  • Module 2: Planning to Install SQL Server
  • Module 3: Managing Database Files
  • Module 4: Managing Security
  • Module 5: Performing Administrative Tasks
  • Module 6: Backing Up Databases
  • Module 7: Restoring Databases
  • Module 8: Monitoring SQL Server for Performance
  • Module 9: Transferring Data
  • Module 10: Maintaining High Availability
  • Module 11: Introducing Replication


Recommended follow on course

For more information or advice please complete the form below.

Name*  
Phone*  
Mobile  
Email*  
Receive info on...   MCSE
MCDBA
MCAD
MCP
MCSA
MCDST
MCSD
Other
Status   Company
Individual
Where did you hear about us?*  
Comments  
Address  

* These fields are required

 

e-Learning           Classroom       Online Demo         Benefits          Contact us          Sitemap
  

Microsoft Training © 2005.

Please Note: We are not Microsoft. We are a training company that provides training materials and classes to gain your Microsoft certification.