Overview of SQL Server 2000

This course is included in our On-demand training solution.


To provide a high-level overview of SQL Server

Target Audience

Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition


Familiarity with a medium to enterprise computing environment that uses SQL Server 2000 Enterprise Edition, at least one year’s experience administering SQL Server, and at least one year’s experience implementing relational databases in environments that contain heterogeneous databases, SQL Server security integrated with Windows Authentication, client/server configurations of 50 to 50,000 or more users, web configurations that use Internet Information Services (IIS) or COM+, databases as large as 2 TB, multiple installations of SQL Server 2000

Expected Duration

105 min.

Course Objectives

Overview of SQL Server 2000

  • discuss relational database management systems (RDBMSs) and explain what makes SQL Server an RDBMS.
  • describe how SQL Server integrates with Windows NT, Windows 2000, and other applications.
  • explain the underlying architecture of SQL Server.
  • provide an overview of the two levels of security provided by SQL Server, namely login authentication and permissions validation.
  • identify system and user databases and discuss the different database objects.
  • describe system tables and explain how to access the information they contain.
  • describe the design options available for client applications and the implementation and administration of a SQL Server database.