Designing a Microsoft SQL Server 2005 Infrastructure
This course provides database administrators
working in enterprise environments with the knowledge
and skills to design a Microsoft SQL ServerT 2005
database infrastructure. The course focuses on the
development of strategies for data archiving,
consolidation, distribution, and recovery. The course
also stresses the importance of capacity analysis and
emphasizes the tradeoffs that need to be made during
design.
|
1 day |
Designing Security for Microsoft SQL Server 2005
This two-day
instructor-led course enables database administrators who
work with enterprise environments to design security for
database systems using Microsoft SQL ServerT 2005. The
course emphasizes that students should think about the whole
environment, which includes business needs, regulatory
requirements, network systems, and database considerations
during design. Students will also learn how to monitor
security and respond to threats.
|
1 day |
Designing High Availability Database Solutions Using Microsoft
SQL Server 2005
This instructor-led
course provides students with the knowledge and skills to design
high availability database solutions using Microsoft® SQL ServerT
2005. The course focuses on teaching experienced database
administrators working in enterprise environments to design database
solutions that meet the availability needs of their organization. It
emphasizes that students should think broadly about high
availability, which includes thinking about the database itself and
about their entire environment, including business needs; regulatory
requirements; and network, systems, and database considerations
during design. Students will also learn how to document and test the
high availability database solution. |
1.5 days |
Administering and Automating Microsoft SQL Server 2005
Databases and Servers
This course
provides students with the knowledge and skills to
administer and automate Microsoft SQL Server 2005 databases
and servers. This course focuses on the need to maintain
administration and automation information.
|
0.5 day |
Troubleshooting and Optimizing Database Servers Using
Microsoft SQL Server 2005
The purpose of this
workshop is to teach database administrators working in
enterprise environments how to determine and troubleshoot
performance issues using Microsoft SQL Server 2005. The
primary focus of this workshop is to teach the overall
process of troubleshooting. It includes establishing
monitoring standards and baselines, determining performance
thresholds, and focusing the investigation on specific
issues.
|
1 day |