杭州crosoft SQL Server 2005 培训课程

Microsoft SQL Server 2005 培训课程

培训课程

编号

课程名称

课程时间

1

实施微软SQL Server 2005数据库（2779）

3天/18小时

2

维护微软 SQL Server 2005数据库（2780）

3天/18小时

3

设计微软 SQL Server 2005基础设施（2786）

2天/12小时

4

设计微软 SQL Server 2005的安全性（2787）

2天/12小时

5

微软 SQL Server 2005数据库与Services 2005的管理与自动化（2789）

1天/6小时

6

采用微软 SQL Server 2005排除数据库服务器故障并进行优化（2790）

2天/12小时

开设课程：实施微软SQL Server 2005数据库（2779）

课程长度：3天/18小时

课程描述：This three-day instructor-led course provides students with product knowledge and skills needed to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database。

培训对象：This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for implementing a database.

培训目标： After completing this course, students will be able to:

Create databases and database files.

Create data types and tables.

Use XML-related features in Microsoft SQL Server 2005.

Plan, create, and optimize indexes.

Implement data integrity in Microsoft SQL Server 2005 databases by using constraints, triggers, and XML schemas.

Implement views.

Implement stored procedures and functions.

Implement managed code in the database.

Use Service Broker to build a messaging-based solution

课程内容：

Creating Databases and Database Files

Creating Data Types and Tables

Using XML

Creating and Tuning Indexes

Implementing Data Integrity

Implementing Views

Implementing Stored Procedures and Functions

Implementing Managed Code in the Database

Using Service Broker

开设课程：维护微软 SQL Server 2005数据库（2780）

课程长度：3天/18小时

课程描述：This three-day instructor-led course provides students with product knowledge and skills needed to maintain a Microsoft SQL ServerT 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.

培训对象：This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for maintaining a database.

培训目标： After completing this course, students will be able to:

Install and configure SQL Server 2005.

Manage database files.

Manage security.

Perform administrative tasks.

Back up databases.

Restore databases.

Monitor SQL Server.

Troubleshoot SQL Server.

Transfer data.

Maintain high availability.

课程内容：

Installing and Configuring SQL Server 2005

Managing Databases and Files

Disaster Recovery

Managing Security

Monitoring SQL Server

Transferring Data

Automating Administrative Tasks

Maintaining High Availability

Introduction to Replication

开设课程：设计微软 SQL Server 2005基础设施（2786）

课程长度：2天/12小时

课程描述：This two-day instructor-led 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。

培训对象：This course is intended for current professional database administrators who have three or more years of on-the-job experience administering SQL Server database solutions in an enterprise environment。

培训目标： After completing this course, students will be able to:

Analyze storage, CPU, memory, and network capacity needs.

Design a strategy for data archiving.

Design a strategy for database server consolidation.

Design a strategy for data distribution.

Design a database server infrastructure.

Design a strategy for data recovery.

Establish database conventions and standards.

课程内容：

Analyzing Capacity Needs

Designing a Strategy for Data Archiving

Designing a Strategy for Database Server Consolidat

Designing a Strategy for Data Distribution

Designing a Database Server Infrastructure

Designing a Strategy for Data Recovery

Establishing Database Conventions and Standards

开设课程：设计微软 SQL Server 2005的安全性（2787）

课程长度：2天/12小时

课程描述：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。

培训对象：This course is intended for current professional database administrators who have three or more years of on-the-job experience administering SQL Server database solutions in an enterprise environment

课程内容：

Introduction to Designing SQL Server Security

Designing a SQL Server Systems Infrastructure Security Policy

Designing Security Policies for Instances and Databases

Integrating Data Encryption into a Database Security Design

Designing a Security Exceptions Policy

Designing a Response Strategy for Threats and Attacks

开设课程：微软 SQL Server 2005数据库与Services 2005的管理与自动化（2789）

课程长度：1天/6小时

课程描述：This one-day instructor-led 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.

培训对象：This course is intended for current professional database administrators who have three or more years of on-the-job experience administering SQL Server database solutions in an enterprise environment

培训目标： After completing this course, students will be able to:

Manage and automate databases and servers.

Manage supporting services.

学习热线188-5817-5617在线Q咨询1178018065(24小时在线)

更多开课信息http://www.114px.com/xuexiao/3392/

教学中心：浙江省杭州市文三路252号伟星大厦19楼

课程内容：

Managing and Automating Databases and Servers

Managing SQL Server Supporting Services

开设课程：采用微软 SQL Server 2005排除数据库服务器故障并进行优化（2790）

课程长度：2天/12小时

课程描述：The purpose of this two-day 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.

培训对象：This course is intended for current professional database administrators who have three or more years of on-the-job experience administering SQL Server database solutions in an enterprise environment

课程内容：

Building a Monitoring Solution for SQL Server Performance Issues

Troubleshooting Database and Database Server Performance Issues

Optimizing the Query Performance Environment

Troubleshooting SQL Server Connectivity Issues

Troubleshooting SQL Server Data Issues

Troubleshooting SQL Server Data Concurrency Issues