114培训网欢迎您来到杭州博学国际教育培训中心!

400-850-8622

全国统一学习专线 8:30-21:00

杭州SQL Server 2005培训

授课机构:杭州博学国际教育培训中心

关注度:1751

课程价格: 请咨询客服

上课地址:请咨询客服

开课时间:滚动开班

咨询热线:400-850-8622

在线报名

课程详情在线报名

更新时间:2024-12-22
杭州实施微软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
姓名不能为空
手机号格式错误