|
 Administering a Microsoft SQL Server 2000 Database
Course Details:
- Days: 5
- Course Code: MS2072
- Booking: Please ring 08450 50 45 05
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™ 2000. Course 2072 is a revision of Course 832, System Administration for Microsoft SQL Server 7.0.
Leads to examination
- 70-228 - Installing, Configuring, and Administering Microsoft SQL Server™ 2000 Enterprise Edition
Prerequisites
-
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 NTFS.
- Implement Windows 2000 security.
- Optimize performance in Windows 2000.
For students who do not meet these prerequisites, the following courses provide 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
- 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).
For students who do not meet these prerequisites, 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, INSERT, UPDATE, and DELETE statements).For students who do not meet these prerequisites, the following course provides students with the necessary knowledge and skills:• Course 2071, Querying Microsoft SQL Server 2000
- Familiarity with the role of the database administrator.
Delegates will learn how to
- 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
- 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
- Monitor and optimise performance
- Back up databases and implement a backup strategy
Outline
- Module 1: SQL Server Overview
- Module 2: Planning to Install SQL Server
- Module 3: Managing Database Files
- Module 4: Managing Security
- Module 5: Performing Administrative Tasks
- Module 6: Backing Up Databases
- Module 7: Restoring Databases
- Module 8: Monitoring SQL Server for Performance
- Module 9: Transferring Data
- Module 10: Maintaining High Availability
- Module 11: Introducing Replication
Recommended follow on course
|