Microsoft SQL Server 2000 Database
Administration Curriculum - user pack
This curriculum presents
learners with instruction of how to install, manage, monitor, and troubleshoot
SQL Server 2000. This curriculum consists of five Skill Builder courses:
-
Course 73475 Microsoft SQL
Server 2000 Database Administration Part 1: Installing SQL Server 2000
-
Course 73476 Microsoft SQL
Server 2000 Database Administration Part 2: Managing Databases
-
Course 73477 Microsoft SQL
Server 2000 Database Administration Part 3: Security and Data Recovery
-
Course 73478 Microsoft SQL
Server 2000 Database Administration Part 4: Managing Data
-
Course 73479 Microsoft SQL
Server 2000 Database Administration Part 5: Maintaining SQL Server 2000
Audience
Candidates for this exam
operate in medium to very large computing environments that use SQL Server
7.0 (and plan to upgrade to SQL Server 2000), Windows 2000 Active Directory,
and Internet Information Server (IIS). They have a minimum of one year's
experience administering SQL Server environments. General categories include
system administrators, database administrators, application developers,
systems analysts, and software engineers. Learners are expected to have
an understanding of basic relational database concepts, and should be familiar
with basic transact-SQL syntax.
This curriculum prepares
learners for Microsoft Exam 70-228.
Total Learning Time
30 to 40 hours
73475 - Microsoft SQL Server
2000 Database Administration Part 1: Installing SQL Server 2000
This is the first course in
a five part series that presents the students with both theoretical and
practical instruction in the subject of installing SQL Server 2000.
Learn To
• Identify the features
and functions of SQL Server.
• Identify the components
involved in the client-server communication process.
• Identify the steps in
the client-server communication process.
• Identify the minimum
hardware requirements for SQL Server 2000.
• Identify the typical
hardware optimization issues for Microsoft SQL Server 2000.
• Select an appropriate
edition of SQL Server 2000.
• Identify the different
types of SQL Server 2000 installations.
• Install a default instance
of SQL Server 2000.
• Sequence the stages of
an unattended installation.
• Identify the types of
SQL Server databases.
• Identify the database
objects related to SQL Server.
• Identify the features
of the SQL Server 2000 object-naming standard.
Audience
Candidates for this exam
operate in medium to very large computing environments that use SQL Server
7.0 (and plan to upgrade to SQL Server 2000), Windows 2000 Active Directory,
and Internet Information Server (IIS). They have a minimum of one year's
experience administering SQL Server environments. General categories include
system administrators, database administrators, application developers,
systems analysts, and software engineers. Students are expected to have
an understanding of basic relational database concepts. Students should
be familiar with basic transact-SQL syntax.
Total Learning Time
6 to 8 hours
73475 Objectives
Unit 1: SQL Server 2000
Overview 1 - 2 hours
• Identify the features
and functions of SQL Server.
• Identify the components
involved in the client-server communication process.
• Identify the steps in
the client-server communication process.
• Identify the features
and functions of SQL Server services.
• Identify the activities
associated with administering a SQL Server database.
• Identify the steps associated
with implementing a SQL Server database.
• Identify the types of
application architecture.
Unit 2: Planning the
Installation 1 - 2 hours
• Identify the minimum
hardware requirements for SQL Server 2000.
• Identify the typical
hardware optimization issues for Microsoft SQL Server 2000.
• Select an appropriate
edition of SQL Server 2000.
• Identify guidelines for
selecting SQL Server 2000 service logon accounts.
• Identify the features
of instances of a SQL Server.
• Identify guidelines for
selecting an authentication mode.
• Select appropriate server
collations and sort rules.
• Identify the characteristics
of network libraries.
• Configure an appropriate
network library.
Unit 3: Installation
Process 2 hours
• Identify the different
types of SQL Server 2000 installations.
• Install a default instance
of SQL Server 2000.
• Sequence the stages of
an unattended installation.
• Identify the characteristics
of a remote installation.
• Identify the features
of SQL Server 2000 components after installation.
• Identify different methods
of managing SQL Server 2000 services.
• Connect to a SQL Server
2000.
• Verify the installed
version of SQL Server.
• Identify the features
of registering SQL Server.
• Configure registration
information in SQL Server Enterprise Manager.
• Create shared registration
information.
• Identify how SQL Server
2000 communicates installation problems.
• Identify guidelines for
troubleshooting SQL Server 2000 installation problems.
• Review the SQL Server
error logs.
• Identify considerations
for upgrading from SQL Server 7.0 to SQL Server 2000.
• Perform an upgrade from
SQL Server 6.5 by using the Upgrade Wizard.
Unit 4: Database Creation
2 hours
• Identify the types of
SQL Server databases.
• Identify the database
objects related to SQL Server.
• Identify the features
of the SQL Server 2000 object-naming standard.
• Identify the effects
of the database creation process.
• Identify the available
options during database creation.
• Create a database by
using the Create Database Wizard.
• Create a database by
using SQL Server Enterprise Manager.
• Create a database by
using Transact-SQL statements.
73476 - Microsoft SQL Server
2000 Database Administration Part 2: Managing Databases
This is the second course in
a five part series that will teach students how to plan for managing databases
with SQL Server 2000. This course also includes both theoretical and practical
instruction in the creation and management of objects.
Learn To
• Identify the database
option categories.
• Identify features of
the tools used to view database properties.
• View database information
by using SQL Server Enterprise Manager.
• Match the different types
of data integrity with their characteristics.
• Identify the different
types of constraints.
• Identify guidelines for
creating constraints.
Audience
Candidates for this exam
operate in medium to very large computing environments that use SQL Server
7.0 (and plan to upgrade to SQL Server 2000), Windows 2000 Active Directory,
and Internet Information Server (IIS). They have a minimum of one year's
experience administering SQL Server environments. General categories include
system administrators, database administrators, application developers,
systems analysts, and software engineers. Students are expected to have
an understanding of basic relational database concepts. Students should
be familiar with basic transact-SQL syntax.
Total Learning Time
6 hours
73476 Objectives
Unit 1: Database Management
3 hours
• Identify the database
option categories.
• Identify features of
the tools used to view database properties.
• View database information
by using SQL Server Enterprise Manager.
• Modify a database by
using SQL Server Enterprise Manager.
• Identify ways to modify
databases by using the ALTER DATABASE statement.
• Identify the features
of the sp_dboption stored procedure.
• Create a database diagram
by using the Create Database Diagram Wizard.
• Identify guidelines for
deleting a database.
• Delete a database by
using the SQL Server Enterprise Manager.
• Identify guidelines for
managing data and log file growth.
• Identify the features
of shrinking a database or database file automatically.
• Identify the guidelines
of shrinking a database or database file manually.
• Identify the features
of user-defined filegroups.
• Identify guidelines to
create a user-defined filegroup.
• Identify the guidelines
for using user-defined filegroups for maintenance.
• Identify the steps for
creating filegroups.
• Identify the characteristics
of transaction logs.
• Identify guidelines for
placing transaction logs.
• Identify guidelines for
optimizing a database by using hardware-based RAID.
• Identify features of
filegroups that improve performance.
• Identify the benefits
of combining filegroups with hardware-based RAID.
• Identify guidelines for
optimizing database performance.
• Identify guidelines for
managing databases.
• Identify guidelines for
estimating the size of a database.
• Identify guidelines for
estimating the amount of data in a table.
Unit 2: Object Management
3 hours
• Match the different types
of data integrity with their characteristics.
• Identify the different
types of constraints.
• Identify guidelines for
creating constraints.
• Identify guidelines for
disabling constraints.
• Identify guidelines for
disabling constraint checking when loading new data.
• Identify the features
of clustered indexes.
• Identify the features
of nonclustered indexes.
• Identify guidelines for
creating indexes.
• Identify guidelines for
using the DROP_EXISTING option.
• Identify guidelines for
using the Index Tuning Wizard.
• Identify performance
considerations for planning and creating indexes.
• Identify the features
of stored procedures.
• Identify guidelines for
creating stored procedures.
• Identify the syntax used
to execute a stored procedure.
• Identify considerations
for modifying a stored procedure.
• Identify considerations
for optimizing a stored procedure.
• Identify the features
and functions of triggers.
• Identify the advantages
of using triggers.
• Identify guidelines for
creating triggers.
• Identify the syntax used
to alter a trigger.
• Identify the features
of views.
• Identify the considerations
for creating a view.
• Identify the critical
steps in creating a view by using the Create View Wizard.
• Identify the syntax used
to alter a view.
• Identify the features
of broken ownership chains.
• Identify the considerations
for modifying data with views.
• Identify the different
types of user-defined functions.
• Match syntax arguments
used to create user-defined functions with their description.
73477 - Microsoft SQL Server
2000 Database Administration Part 3: Security and Data Recovery
This is the third course in
a five part series that deals with the backup and restore strategies for
SQL Server 2000 and with managing security and permissions with SQL Server
2000.
Learn To
• Identify how login accounts
are processed.
• Identify the characteristics
of the two authentication modes.
• Sequence the steps to
implement an authentication mode.
• Identify the guidelines
for preventing data loss.
• Match database recovery
models with their features.
• Identify the process
behind SQL Server 2000 backup.
Audience
Candidates for this exam
operate in medium to very large computing environments that use SQL Server
7.0 (and plan to upgrade to SQL Server 2000), Windows 2000 Active Directory,
and Internet Information Server (IIS). They have a minimum of one year's
experience administering SQL Server environments. General categories include
system administrators, database administrators, application developers,
systems analysts, and software engineers. Students are expected to have
an understanding of basic relational database concepts. Students should
be familiar with basic transact-SQL syntax.
Total Learning Time
7 hours
73477 Objectives
Unit 1: Security 3 hours
• Identify how login accounts
are processed.
• Identify the characteristics
of the two authentication modes.
• Sequence the steps to
implement an authentication mode.
• Identify the properties
of a SQL Server login.
• Configure SQL Server
2000 to use Windows Authentication Mode.
• Authorize Windows 2000
users and groups to access SQL Server 2000.
• Test the logins created
for Windows 2000 user and group accounts.
• Revoke access from a
Windows 2000 user or group.
• Deny access to a Windows
2000 group or user.
• Identify the methods
for assigning a login account to user accounts.
• Match fixed server roles
with their permissions.
• Identify features of
fixed database roles in SQL Server 2000.
• Identify the features
of user-defined database roles.
• Create a user-defined
database role.
• Identify types of permissions.
• Identify guidelines for
managing permissions.
• Identify the methods
for revoking granted and denied permissions.
• Assign statement permissions
by using SQL Server Enterprise Manager.
• Assign object permissions
by using SQL Server Enterprise Manager.
• Identify the guidelines
for managing security with views and stored procedures.
• Implement permissions
by using views and stored procedures.
• Identify the features
of application roles in managing client application security.
• Create an application
role.
• Activate an application
role.
Unit 2: Backup and Restore
Strategies 4 hours
• Identify the guidelines
for preventing data loss.
• Match database recovery
models with their features.
• Identify the process
behind SQL Server 2000 backup.
• Identify when to back
up system databases.
• Identify when to back
up a user database.
• Identify the guidelines
for creating a backup device.
• Create a backup device
by using SQL Server Enterprise Manager.
• Create a backup device
by using Transact-SQL.
• Identify the guidelines
for using multiple backup files to store backups.
• Identify the guidelines
for using the BACKUP DATABASE statement.
• Identify the features
of backing up to a tape device.
• Identify guidelines for
performing a full database backup.
• Back up a database.
• Back up a database to
multiple files.
• Identify guidelines for
performing a differential backup.
• Identify the process
for implementing a transaction log backup.
• Identify guidelines for
clearing the transaction log.
• Backup a transaction
log.
• Identify the reasons
for performing a database file and filegroup backup.
• Sequence stages of the
SQL Server 2000 recovery process.
• Identify the functions
of the RESTORE statements for verifying backups.
• Identify the tasks that
you must perform before restoring a backup.
• Match RESTORE DATABASE
statement options with their functions.
• Identify guidelines for
initiating the recovery process.
• Identify guidelines for
restoring from a full database backup.
• Identify guidelines for
restoring from a differential backup.
• Restore a full database
backup.
• Identify guidelines for
restoring a transaction log backup.
• Restore a transaction
log backup.
• Sequence the steps to
restore a damaged system database.
73478 - Microsoft SQL Server
2000 Database Administration Part 4: Managing Data
This course deals with transferring
data, managing replication services, and maintaining high availability.
Learn To
• Identify guidelines for
importing and exporting data.
• Match SQL Server 2000
tools used to import and export data with their functions.
• Identify the features
and functions of the Data Transformation Services (DTS) process.
• Identify the features
of distributed data.
• Identify the different
methods of distributing data.
• Identify the features
of the publisher-subscriber metaphor.
• Identify the features
of the Database Maintenance Plan Wizard.
• Troubleshoot a database
by using the Database Consistency Checker (DBCC).
• Identify the guidelines
for performing a Database Consistency Checker (DBCC) SHOWCONTIG.
Audience
Candidates for this exam
operate in medium to very large computing environments that use SQL Server
7.0 (and plan to upgrade to SQL Server 2000), Windows 2000 Active Directory,
and Internet Information Server (IIS). They have a minimum of one year's
experience administering SQL Server environments. General categories include
system administrators, database administrators, application developers,
systems analysts, and software engineers. Students are expected to have
an understanding of basic relational database concepts. Students should
be familiar with basic transact-SQL syntax. (Microsoft Course 2071: Querying
Microsoft SQL Server 2000).
Total Learning Time
6 to 8 hours
73478 Objectives
Unit 1: Transferring
Data 2 - 3 hours
• Identify tasks that can
be defined within a Data Transformation Services (DTS) package.
• Identify guidelines for
creating a Data Transformation Services (DTS) package.
• Import data into SQL
Server 2000 by using the Bulk Insert Task.
• Import data from a Transact-SQL
(T-SQL) Query.
• Modify a Data Transformation
Services (DTS) package by using DTS Designer.
• Transfer SQL Server 2000
objects.
• Identify requirements
for configuring linked servers.
• Identify the characteristics
of XML support in Internet Information Services (IIS).
• Identify guidelines for
importing and exporting data.
• Match SQL Server 2000
tools used to import and export data with their functions.
• Identify the features
and functions of the Data Transformation Services (DTS) process.
• Identify the features
and functions of Data Transformation Services (DTS) tools.
• Identify guidelines for
managing data.
• Identify the functions
of data transformation and mapping.
Unit 2: Replication Services
2 - 3 hours
• Identify the features
of distributed data.
• Identify the different
methods of distributing data.
• Identify the features
of the publisher-subscriber metaphor.
• Identify the characteristics
of publications and articles.
• Match filtering methods
with their functions.
• Identify the different
ways of subscribing to a publication.
• Identify the features
of the different replication agents.
• Match the replication
types with their characteristics.
• Identify features of
merge replication.
• Identify features of
different physical replication models.
• Identify features of
a Central Publisher/Remote Distributor model.
• Identify features of
a Central Subscriber/Multiple Publishers model.
• Identify features of
a Multiple Publishers/Multiple Subscribers model.
• Register a SQL Server.
• Create a publication.
• Create a subscription.
• Verify that a change
to a published article has been updated on the subscriber.
Unit 3: Maintaining High
Availability 2 hours
• Identify the features
of the Database Maintenance Plan Wizard.
• Troubleshoot a database
by using the Database Consistency Checker (DBCC).
• Identify the guidelines
for performing a Database Consistency Checker (DBCC) SHOWCONTIG.
• Identify the features
of Windows clustering.
• Identify the features
of SQL Server 2000 failover clustering.
• Identify the features
of active/passive clustering.
• Identify the features
of active/active clustering.
• Identify the considerations
for failover clustering.
• Identify the features
and functions of standby servers and log shipping.
• Sequence the steps to
prepare the Primary and Standby servers.
• Identify the guidelines
for configuring log shipping.
• Sequence the steps to
configure the Primary server.
• View the log shipping
pair properties.
• Identify the characteristics
of the process for changing log shipping roles.
• Change the role of the
Standby server.
73479 - Microsoft SQL Server
2000 Database Administration Part 5: Maintaining SQL Server 2000
This is the last course in
a five part series that deals with managing, monitoring, and troubleshooting
SQL Server 2000.
Learn To
• Identify guidelines for
configuring SQL Server Agent.
• Identify guidelines for
using SQLAgentMail and SQL Mail.
• Configure a Microsoft
Outlook Exchange profile for your administrative account.
• Identify the goals of
SQL Server 2000 monitoring.
• Identify guidelines for
performance tuning.
• Identify the factors
to consider when detecting database performance problems.
Audience
The audience for this course
include system administrators, database administrators, application developers,
systems analysts, and software engineers. A prerequisite skill for this
course is an understanding of basic relational database concepts. Students
should be familiar with basic transact-SQL syntax.
Total Learning Time
7 hours
73479 Objectives
Unit 1: Automating Routine
Administrative Tasks 3 hours
• Identify guidelines for
configuring SQL Server Agent.
• Identify guidelines for
using SQLAgentMail and SQL Mail.
• Configure a Microsoft
Outlook Exchange profile for your administrative account.
• Configure a Microsoft
Outlook Exchange profile for the SQL Service account.
• Verify that SQL Server
Agent has been configured to use a specific mail profile.
• Configure SQL Mail.
• Identify guidelines for
creating jobs.
• Identify the factors
that determine the permissions required for executing jobs.
• Identify guidelines for
defining job steps.
• Identify the options
for scheduling jobs.
• Identify guidelines for
notifying operators.
• Identify considerations
for managing job history.
• Create an operator to
receive notifications from SQL Server Agent.
• Create a job by using
the Create Job Wizard.
• Create a job consisting
of multiple steps.
• Identify the process
for using alerts to respond to problems.
• Identify the conditions
for SQL Server 2000 to write events to the Windows application log.
• Identify considerations
for creating alerts to respond to SQL Server 2000 errors.
• Identify the guidelines
for creating alerts on a user-defined error.
• Identify the options
available when responding to performance condition alerts.
• Identify the guidelines
for assigning a fail-safe operator.
• Identify the guidelines
for troubleshooting alerts.
• Create an alert by using
the Create Alert Wizard.
• Create a user-defined
error message for use in an alert.
• Create a performance
condition alert.
• Identify guidelines for
troubleshooting automated tasks.
Unit 2: Monitoring SQL
Server 2000 4 hours
• Identify the goals of
SQL Server 2000 monitoring.
• Identify guidelines for
performance tuning.
• Identify the factors
to consider when detecting database performance problems.
• Match common monitoring
tasks with their features.
• Identify guidelines for
monitoring SQL Server 2000.
• Identify the monitoring
features of the Windows 2000 Event Viewer.
• Identify the characteristics
of the Windows System Monitor.
• Monitor SQL Server 2000
and Windows resources by adding performance counters.
• Identify the features
and functions of the SQL Query Analyzer.
• Generate performance
statistics and a graphical execution plan by using SQL Query Analyzer.
• Identify the characteristics
of SQL Profiler.
• Configure SQL Profiler
to detect login attempts.
• Configure a new trace
to detect long running queries by using SQL Profiler.
• Identify the information
you can monitor by using the Current Activity Details Pane.
• Identify the functions
and features of Transact-SQL (T-SQL) monitoring tools.
• Identify guidelines for
monitoring memory usage.
• Identify guidelines for
monitoring threads and processor usage.
• Identify guidelines for
monitoring physical disk I/O.
• Identify how different
types of locks affect performance.
• View locking information.
• Detect lock blocking.
• Identify the causes of
poorly performing queries.
Regular price: $999.95
Sale price: $839.95
Click here for Secure
Yahoo Order: Microsoft
SQL Server 2000 Database Administration Curriculum - 1 user pack
Regular price: $3,495.95 Sale
price: $2,935.95
Click here for Secure
Yahoo Order: Microsoft
SQL Server 2000 Database Administration Curriculum - 5 user pack
Regular price: $5,999.95 Sale
price: $5,030.95
Click here for Secure
Yahoo Order: Microsoft
SQL Server 2000 Database Administration Curriculum - 10 user pack
Regular price: $13,999.95
Sale price: $11,739.95
Click here for Secure
Yahoo Order: Microsoft
SQL Server 2000 Database Administration Curriculum - 25 user pack
Get Train in SQL
SQL
Software Training
Best Regards,
Oracle Database,
SQL, Application, Programming Tips
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
All product names are trademarks of their respective
companies.
The site www.erpgreat.com is not affiliated with or endorsed
by any company listed at this site.
Every effort is made to ensure the content integrity.
Information used on this site is at your own risk.
The content on this site may not be reproduced
or redistributed without the express written permission of
www.erpgreat.com or the content authors.
|