< Return To Course List
Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Overview/Description
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
Prerequisites
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 (hours)
1.8
Lesson Objectivesdiscuss 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.
Course Number:
31478_eng
Overview of SQL Server 2000
Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Overview/Description
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
Prerequisites
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 (hours)
1.8
Lesson Objectives
Overview of SQL Server 2000
31478_eng
Copyright© 2010 SkillSoft - All Rights Reserved