|
MS-2072
Administering a Microsoft SQL Server
2000
Course Length:
5 days
Tuition:
$2125
What past
students had to say about this class:
Enjoyed the class. The
instructor was extremely helpful and very knowledgeable. Would recommend
this class to my peers.
~K.M.\ USMC
Instructor was very
approachable and easy to learn from. Instructor had practical application
knowledge and experience. Truly enjoyed the training. ~B.T. \ GIA
Course 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 TM 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.
Prerequisites
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.
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).
- Knowledge of basic Transact-SQL syntax
(SELECT, INSERT, UPDATE, and DELETE statements).
- Familiarity with the role of the database
administrator.
For students who do not meet these
prerequisites, the following course provides 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
- Course 2071, Querying Microsoft SQL
Server 2000
- Course 1609, Designing Data Services and
Data Models Microsoft Certified Professional Exams
Microsoft Certified Professional Exams
This course will help the student prepare
for the following Microsoft Certified Professional exam:
- Exam 70-228, System Administration
for Microsoft SQL Server 2000 Skills Gained
Skills Gained
At the end of the course, students will be
able to:
- Describe SQL Server architecture.
- 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.
- Perform and automate administrative
tasks and create custom administrative tools.
- Back up databases and implement a backup
strategy. · Restore databases.
- Monitor and optimize SQL Server
performance.
- Transfer and migrate data into
databases.
- Maintain the high availability of SQL
Server.
- Describe how to replicate data from one
SQL Server to another.
|
