|
Installing,
Configuring, and Administering Microsoft SQL Server 2000
Enterprise Edition Exam
#70-228
Candidates
for this exam operate in medium to very large computing
environments that use Microsoft SQL Server 2000 Enterprise
Edition. Candidates have at least one year of experience
administering SQL Server. They also have at least one year
of experience implementing relational databases in environments
that contain:
- Heterogeneous
databases.
- SQL
Server security integrated with Windows Authentication.
- Client/server
configurations of 50 to 5,000 or more users.
- Web
configurations that use Microsoft Internet Information
Services (IIS) or COM+.
Databases as large as 2 terabytes.
- Multiple
installations of SQL Server 2000.
................................................................................................................................................
Skills
Being Measured
This certification exam measures your ability to administer
and troubleshoot information systems that incorporate Microsoft
SQL Server™ 2000 Enterprise Edition. Before taking
the exam, you should be proficient in the job skills listed
below.
Installing
and Configuring SQL Server 2000
Install
SQL Server 2000. Considerations include clustering, default
collation, file locations, number of instances, and service
accounts.
Upgrade
to SQL Server 2000.
- Perform
a custom upgrade.
- Upgrade
to SQL Server 2000 from SQL Server 6.5.
- Upgrade
to SQL Server 2000 from SQL Server 7.0.
- Create
a linked server.
Configure
SQL Mail and SQLAgentMail.
Configure
network libraries.
Troubleshoot
failed installations.
................................................................................................................................................
Creating
SQL Server 2000 Databases
Configure
database options for performance. Considerations include
capacity, network connectivity, physical drive configurations,
and storage locations.
Attach
and detach databases.
Create
and alter databases.
- Add
filegroups.
- Configure
filegroup usage.
- Expand
and shrink a database.
- Set
database options by using the ALTER DATABASE or CREATE
DATABASE statements.
- Size
and place the transaction log.
Create
and manage objects. Objects include constraints, indexes,
stored procedures, triggers, and views.
................................................................................................................................................
Managing,
Monitoring, and Troubleshooting SQL Server 2000 Databases
Optimize
database performance. Considerations include indexing, locking,
and recompiling.
Optimize
data storage.
- Optimize
files and filegroups.
- Manage
database fragmentation.
- Modify
the database schema.
Perform
disaster recovery operations.
- Perform
backups.
- Recover
the system state and restore data.
- Configure,
maintain, and troubleshoot log shipping.
Perform
integrity checks. Methods include configuring the Database
Maintenance Plan Wizard and using the Database Consistency
Checker (DBCC).
Troubleshoot transactions and locking by using SQL Profiler,
SQL Server Enterprise Manager, or Transact-SQL.
................................................................................................................................................
Extracting
and Transforming Data with SQL Server 2000
Set
up IIS virtual directories to support XML.
Import
and export data. Methods include the Bulk Insert task, the
bulk copy program, Data Transformation Services (DTS), and
heterogeneous queries.
Develop
and manage DTS packages.
Manage
linked servers.
- Manage
OLE DB Providers.
- Configure
security mapping.
Convert
data types.
Configure,
maintain, and troubleshoot replication services.
................................................................................................................................................
Managing
and Monitoring SQL Server 2000 Security
Configure
mixed security modes or Windows Authentication. Considerations
include client connectivity, client operating system, and
security infrastructure.
Create
and manage log ons.
Create
and manage database users.
Create
and manage security roles. Roles include application, database,
and server.
Add
and remove users from roles.
Create roles to manage database security.
Enforce and manage security by using stored procedures,
triggers, views, and user-defined functions.
Set
permissions in a database. Considerations include object
permissions, object ownership, and statement permissions.
Manage
security auditing. Methods include SQL Profiler and C2 auditing.
................................................................................................................................................
Managing,
Monitoring, and Troubleshooting SQL Server 2000
Create,
manage, and troubleshoot SQL Server Agent jobs.
Configure
alerts and operators by using SQL Server Agent.
Optimize
hardware resource usage. Resources include CPU, disk I/O,
and memory.
- Monitor
hardware resource usage by using System Monitor.
- Resolve
system bottlenecks by using System Monitor.
Optimize and troubleshoot SQL Server system activity. Activities
include cache hits, connections, locks, memory allocation,
recompilation, and transactional throughput.
- Monitor
SQL Server system activity by using traces.
-
Monitor SQL Server system activity by using System Monitor.
This
course will allow you to study at your own pace through
a system of case-study scenarios and tutorials to gain practical
experience analyzing, planning and optimizing a network
infrastructure for Windows 2000 Server. As you build these
real-world design skills, you are also preparing for MCP
Exam 70-221 - a core credit on the Windows 2000 MCSE track.
................................................................................................................................................
Our
dynamic training program includes:
- 5
Videos or 6 Interactive CD-ROM's
- 1
Microsoft approved e-Book Study Guide
- 1
QuickCert Practice Exam Simulator
- Our
Upgrade Policy
- Compatibility
with: NT/ 95 / 98 / 2000
- One
year of educational support
With
our dynamic video/CD-ROM series and the accompanying
QuickCert
Exam and student workbook we include plenty of clear and
concise demos, technical tips and tricks and real-world
scenarios.
See the entire
MCSE 2000 course description!
Call
Us @ 1.800.942.1660
|
