Certification Training CD
  MCSE Training
  CCNA Training
  A+ (APlus) Training
  Network+
  CISSP Training
  Certification Training Library Suites
   
  IT Training Courses
  CompTIA
  Cisco
  CIW
  Linux
  Microsoft
  Oracle
  Programming
  SAP
  Unix
   
  Desktop Training CD
  Office 2003
  Office XP
   
  Soft Skills Training CD
  Accounting and Finance
  Communication Skills
  Customer Service Skills
  Government
  Industrial Safety
  Operations
  Project Management
  Team Building Skills
   
  Link To Our Site
 
 

Back To Microsoft Training Courses

Microsoft SQL Server 2000 Database Administration Training CBT Suite

Price: $645.00

CBT Course Overview:

The Self Study Store Computer Based Training Microsoft SQL Server 2000 Database Administration presents learners with instruction of how to install, manage, monitor, and troubleshoot SQL Server 2000.

Total Training Duration:

24 hours

CBT Course Modules:

  • Microsoft SQL Server 2000 Database Administration Part 1: Installing SQL Server 2000 Training CBT
  • Microsoft SQL Server 2000 Database Administration Part 2: Managing Databases Training CBT
  • Microsoft SQL Server 2000 Database Administration Part 3: Security and Data Recovery Training CBT
  • Microsoft SQL Server 2000 Database Administration Part 4: Managing Data Training CBT
  • Microsoft SQL Server 2000 Database Administration Part 5: Maintaining SQL Server 2000 Training CBT

Training Course Topics:

  • Learn the features and functions of SQL Server.
  • Learn the components involved in the client-server communication process.
  • Learn the steps in the client-server communication process.
  • Learn the minimum hardware requirements for SQL Server 2000.
  • Learn the typical hardware optimization issues for Microsoft SQL Server 2000.
  • Select an appropriate edition of SQL Server 2000.
  • Learn the different types of SQL Server 2000 installations.
  • Install a default instance of SQL Server 2000.
  • Learn the database option categories.
  • Learn features of the tools used to view database properties.
  • View database information by using SQL Server Enterprise Manager.
  • Match the different types of data integrity with their characteristics.
  • Learn the different types of constraints.
  • Learn guidelines for creating constraints.
  • Learn how login accounts are processed.
  • Learn the characteristics of the two authentication modes.
  • Sequence the steps to implement an authentication mode.
  • Learn the guidelines for preventing data loss.
  • Match database recovery models with their features.
  • Learn the process behind SQL Server 2000 backup.
  • Learn guidelines for importing and exporting data.
  • Match SQL Server 2000 tools used to import and export data with their functions.
  • Learn the features and functions of the Data Transformation Services (DTS) process.
  • Learn the features of distributed data.
  • Learn the different methods of distributing data.
  • Learn guidelines for configuring SQL Server Agent.
  • Learn guidelines for using SQLAgentMail and SQL Mail.
  • Configure a Microsoft Outlook Exchange profile for your administrative account.
  • Learn the goals of SQL Server 2000 monitoring.
  • Learn guidelines for performance tuning.
  • Learn the factors to consider when detecting database performance problems.
The Self Study Store Computer Based Training Microsoft SQL Server 2000 Database Administration course audience for this exam operate in medium to very large computing environments that use SQL Server 7.0 (and plan to upgrade to SQL Server 2000), Windows 2000 Active Directory, and Internet Information Server (IIS). They have a minimum of one year's experience administering SQL Server environments. General categories include system administrators, database administrators, application developers, systems analysts, and software engineers. Learners are expected to have an understanding of basic relational database concepts, and should be familiar with basic transact-SQL syntax. This curriculum prepares learners for Microsoft Exam 70-228.