点击这里给我发消息
就业培训
点击这里给我发消息
认证培训
点击这里给我发消息
企业内训
点击这里给我发消息
认证考试
 
   
 

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:

  1. Create databases and database files.
  2. Create data types and tables.
  3. Use XML-related features in Microsoft SQL Server 2005.
  4. Plan, create, and optimize indexes.
  5. Implement data integrity in Microsoft SQL Server 2005 databases by using constraints, triggers, and XML schemas.
  6. Implement views.
  7. Implement stored procedures and functions.
  8. Implement managed code in the database.
  9. Use Service Broker to build a messaging-based solution

课程内容:

  1. Creating Databases and Database Files
  2. Creating Data Types and Tables
  3. Using XML
  4. Creating and Tuning Indexes
  5. Implementing Data Integrity
  6. Implementing Views
  7. Implementing Stored Procedures and Functions
  8. Implementing Managed Code in the Database
  9. 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:

  1. Install and configure SQL Server 2005.
  2. Manage database files.
  3. Manage security.
  4. Perform administrative tasks.
  5. Back up databases.
  6. Restore databases.
  7. Monitor SQL Server.
  8. Troubleshoot SQL Server.
  9. Transfer data.
  10. Maintain high availability.

课程内容:

  1. Installing and Configuring SQL Server 2005
  2. Managing Databases and Files
  3. Disaster Recovery
  4. Managing Security
  5. Monitoring SQL Server
  6. Transferring Data
  7. Automating Administrative Tasks
  8. Maintaining High Availability
  9. 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:

  1. Analyze storage, CPU, memory, and network capacity needs.
  2. Design a strategy for data archiving.
  3. Design a strategy for database server consolidation.
  4. Design a strategy for data distribution.
  5. Design a database server infrastructure.
  6. Design a strategy for data recovery.
  7. Establish database conventions and standards.

课程内容:

  1. Analyzing Capacity Needs
  2. Designing a Strategy for Data Archiving
  3. Designing a Strategy for Database Server Consolidat
  4. Designing a Strategy for Data Distribution
  5. Designing a Database Server Infrastructure
  6. Designing a Strategy for Data Recovery
  7. 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
课程内容:

  1. Introduction to Designing SQL Server Security
  2. Designing a SQL Server Systems Infrastructure Security Policy
  3. Designing Security Policies for Instances and Databases
  4. Integrating Data Encryption into a Database Security Design
  5. Designing a Security Exceptions Policy
  6. 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:

  1. Manage and automate databases and servers.
  2. Manage supporting services.

课程内容:

  1. Managing and Automating Databases and Servers
  2. 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
 
 

咨询专线:4008-999-123(杭州)  0571-88211998(其他地区)
E-MailTraining@boxue.com.cn
培训地点:浙江省杭州市文三路252号伟星大厦19楼

 
 
 
 
 
 
地址:浙江省杭州市文三路252号伟星大厦19楼   传真:0571-89922598  电话:0571-88211998
电子邮箱:所有:杭州博学信息技术服务有限公司
技术支持:中商科技-神州商务网  备案序号:浙ICP备09066235号
 
淘宝商场 淘宝城 淘宝购物 淘宝购物网 淘宝网服装 淘宝 网首页 淘宝网女装冬装
淘宝官方网站 淘宝网购物商城 淘宝网站 淘宝官网 陶宝商城 淘宝网冬装 购物导航 淘宝网购物商城首页 淘宝网官方网站 灭白蚁 白蚁药 白蚁 白蚁防治 白蚁防治方法 泉州白蚁防治 白蚁图片