Course
: 2072 Administering a MS SQL Server 2000 Database
Course : 2071 Querying Microsoft
SQL Server 2000 with Transact-SQL
familiarity with the role of the database administrator (
Duration : 30 / 30 hours
Associated Exam : 70 - 228, 70-229
Description
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. The course content is being revised to reflect changes in the
product.
Objective
This course focuses on the installation, configuration, and
administering the 2003 exchange server, Managing the users and inboxes.
Configuring clustering on the exchange servers. Config. the routing and
connectors. Trouble shooting and repairing the non functional server.
Audience
This course is design for the system administrator and the SQL
programmer, SQL developers who wants to enhance their skills and sit in
the certification exam.
Prerequisites
A+ Technician
Network+ or equivalent experience in the computer environment 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
the NTFS file system. Implement Windows 2000 security. Optimize
performance in Windows 2000. For students who do not meet this
prerequisite, the following courses provide students with the necessary
knowledge and skills.
Course : 2151 - MS 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, many-to-many). How data
is stored in tables (rows and columns). For students who do not meet
this prerequisite, 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, UPDATE, and INSERT
statements). For students who do not meet this prerequisite, the following
course provides students with the necessary knowledge and skills.
Course : 2071 - Querying Microsoft SQL Server 2000 with Transact-SQL
Familiarity with the role of the database administrator.
