Course
Outline
System
Administration
for Microsoft
SQL Server
This
course
provides
students with
the knowledge
and skills
required to
install,
configure,
administer,
and
troubleshoot
Microsoft SQL
Server
client/server
database
management
system .
Objective
At
the end of
the course,
students will
be able to:
- Prepare
for Exam
70-028,
System
Administration
for
Microsoft
SQL
Server
- Describe
SQL
Server
architecture.
- Plan
for a SQL
Server
installation.
- Install
SQL
Server.
- Configure
SQL
Server;
manage
files and
databases.
- Choose
a login
security
method.
- Configure
login
security.
- Plan
and
implement
database
permissions.
- Back
up
databases.
- Restore
databases.
- Automate
administrative
tasks
using SQL
Server
Agent.
- Import,
export
and
transform
data.
- Monitor
and
maintain
SQL
Server
performance.
- Replicate
data from
one SQL
Server to
another.