杭州实施微软SQL Server 2005数据库培训、杭州维护微软 SQL Server 2005数据库培训、杭州设计微软 SQL Server 2005基础设施培训、杭州设计微软 SQL Server 2005的安全性培训、杭州微软 SQL Server 2005数据库与Services 2005的管理与自动化培训、采用微软 SQL Server 2005排除数据库服务器故障并进行优化
开设课程:实施微软SQL Server 2005数据库
课程长度: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数据库
课程长度: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基础设施
课程长度: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的安全性
课程长度: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的管理与自动化
课程长度: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.
课程内容:
Managing and Automating Databases and Servers
Managing SQL Server Supporting Services
开设课程:采用微软 SQL Server 2005排除数据库服务器故障并进行优化
课程长度: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