杭州實(shí)施微軟SQL Server 2005數(shù)據(jù)庫(kù)培訓(xùn)、杭州維護(hù)微軟 SQL Server 2005數(shù)據(jù)庫(kù)培訓(xùn)、杭州設(shè)計(jì)微軟 SQL Server 2005基礎(chǔ)設(shè)施培訓(xùn)、杭州設(shè)計(jì)微軟 SQL Server 2005的安全性培訓(xùn)、杭州微軟 SQL Server 2005數(shù)據(jù)庫(kù)與Services 2005的管理與自動(dòng)化培訓(xùn)、采用微軟 SQL Server 2005排除數(shù)據(jù)庫(kù)服務(wù)器故障并進(jìn)行優(yōu)化
開(kāi)設(shè)課程：實(shí)施微軟SQL Server 2005數(shù)據(jù)庫(kù)
課程長(zhǎng)度：3天/18小時(shí)
課程描述：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。
培訓(xùn)對(duì)象：This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for implementing a database.
培訓(xùn)目標(biāo)： 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
課程內(nèi)容：
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
開(kāi)設(shè)課程：維護(hù)微軟 SQL Server 2005數(shù)據(jù)庫(kù)
課程長(zhǎng)度：3天/18小時(shí)
課程描述：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.
培訓(xùn)對(duì)象：This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for maintaining a database.
培訓(xùn)目標(biāo)： 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.
課程內(nèi)容：
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
開(kāi)設(shè)課程：設(shè)計(jì)微軟 SQL Server 2005基礎(chǔ)設(shè)施
課程長(zhǎng)度：2天/12小時(shí)
課程描述：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。
培訓(xùn)對(duì)象：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。
培訓(xùn)目標(biāo)： 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.
課程內(nèi)容：
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
開(kāi)設(shè)課程：設(shè)計(jì)微軟 SQL Server 2005的安全性
課程長(zhǎng)度：2天/12小時(shí)
課程描述：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。
培訓(xùn)對(duì)象：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
課程內(nèi)容：
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
開(kāi)設(shè)課程：微軟 SQL Server 2005數(shù)據(jù)庫(kù)與Services 2005的管理與自動(dòng)化
課程長(zhǎng)度：1天/6小時(shí)
課程描述：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.
培訓(xùn)對(duì)象：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
培訓(xùn)目標(biāo)： After completing this course, students will be able to:
Manage and automate databases and servers.
Manage supporting services.
課程內(nèi)容：
Managing and Automating Databases and Servers
Managing SQL Server Supporting Services
開(kāi)設(shè)課程：采用微軟 SQL Server 2005排除數(shù)據(jù)庫(kù)服務(wù)器故障并進(jìn)行優(yōu)化
課程長(zhǎng)度：2天/12小時(shí)
課程描述：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.
培訓(xùn)對(duì)象：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
課程內(nèi)容：
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
