通过本课程的培训,使学员尽快掌握SQL Server 2000及2005应用环境及各种工具。使学员能够安装或配置SQL服务器,并管理或维护数据库、多维数据库、用户账户、数据库可用性、数据库恢复以及报告等。他们还能够设计或实施安全机制、服务器自动化机制,监视SQL服务器的工作并及时排除故障。通过进一步的实践成为优秀的技术专家。在培训过程中,通过大量实验及分析题目帮助学员尽快通过MCITP数据库技术专家认证。
课程大纲
课程模块 课程内容 实验内容 Module 1 Installing and Configuring SQL Server Preparing to Install SQL Server Installing SQL Server 2005 Managing a SQL Server 2005 Installation Performing an Installation Managing SQL Server Module 2: Managing Databases and Files Planning Databases Creating Databases Managing Databases Creating a Database Monitoring and Managing Filegroup Usage Viewing Database Metadata Module 3: Disaster Recovery Planning a Backup Strategy Backing Up User Databases Restoring User Databases Performing Online Restore Operations Recovering Data from Database Snapshots System Database and Disaster Recovery Implementing a Backup Strategy Restoring and Recovering a Database Performing Piecemeal Backup and Restore Operations Restoring the master Database Module 4: Managing Security Overview of SQL Server Security Protecting the Server Scope Protecting the Database Scope Managing Keys and Certificates in SQL Server Creating Logins and Assigning Server-Scope Permissions Creating and Managing Users Using a Certificate to Protect Data Module 5: Monitoring SQL Server Viewing Current Activity Using System Monitor Using SQL Server Profiler Using DDL Triggers Using Event Notifications Monitoring SQL Server Performance Tracing SQL Server Activity Implementing DDL Triggers Module 6: Transferring Data Overview of Data Transfer Introduction to SQL Server Integration Services Using SQL Server Integration Services Features of SQL Server Integration Services Creating an SSIS Package Deploying an SSIS Package Using SSIS to Extract Data, Perform Lookups, Sort, and Split Data
Module 7: Automating Administrative Tasks Automating Administrative Tasks Configuring the SQL Server Agent Creating Jobs and Operators Creating Alerts Managing Multiple Servers Managing SQL Server Agent Security Configuring SQL Server Agent Creating Operators and Jobs Creating Alerts Module 8: Implementing Replication Overview of Replication Implementing Replication Configuring Replication in Some Common Scenarios Creating a Publication Creating a Subscription Implementing HTTP Merge Replication Module 9: Maintaining High Availability Introduction to High Availability Implementing Server Clustering Implementing Database Mirroring Implementing Log Shipping Implementing Peer-to-Peer Replication Configuring Database Mirroring to Support Failover Implementing Distributed High Availability
培训师介绍
通过本课程的培训,使学员尽快掌握SQL Server 2000及2005应用环境及各种工具。使学员能够安装或配置SQL服务器,并管理或维护数据库、多维数据库、用户账户、数据库可用性、数据库恢复以及报告等。他们还能够设计或实施安全机制、服务器自动化机制,监视SQL服务器的工作并及时排除故障。通过进一步的实践成为优秀的技术专家。在培训过程中,通过大量实验及分析题目帮助学员尽快通过MCITP数据库技术专家认证。
课程介绍 评价详情(0)
培训受众:
课程收益:
课程大纲
课程内容 实验内容
Module 1
Installing and Configuring SQL Server
Preparing to Install SQL Server
Installing SQL Server 2005
Managing a SQL Server 2005 Installation
Performing an Installation
Managing SQL Server
Module 2:
Managing Databases and Files
Planning Databases
Creating Databases
Managing Databases
Creating a Database
Monitoring and Managing Filegroup Usage
Viewing Database Metadata
Module 3:
Disaster Recovery
Planning a Backup Strategy
Backing Up User Databases
Restoring User Databases
Performing Online Restore Operations
Recovering Data from Database Snapshots
System Database and Disaster Recovery
Implementing a Backup Strategy
Restoring and Recovering a Database
Performing Piecemeal Backup and Restore Operations
Restoring the master Database
Module 4:
Managing Security
Overview of SQL Server Security
Protecting the Server Scope
Protecting the Database Scope
Managing Keys and Certificates in SQL Server
Creating Logins and Assigning Server-Scope Permissions
Creating and Managing Users
Using a Certificate to Protect Data
Module 5:
Monitoring SQL Server
Viewing Current Activity
Using System Monitor
Using SQL Server Profiler
Using DDL Triggers
Using Event Notifications
Monitoring SQL Server Performance
Tracing SQL Server Activity
Implementing DDL Triggers
Module 6:
Transferring Data
Overview of Data Transfer
Introduction to SQL Server Integration Services
Using SQL Server Integration Services
Features of SQL Server Integration Services
Creating an SSIS Package
Deploying an SSIS Package
Using SSIS to Extract Data, Perform Lookups, Sort, and Split Data
Module 7:
Automating Administrative Tasks
Automating Administrative Tasks
Configuring the SQL Server Agent
Creating Jobs and Operators
Creating Alerts
Managing Multiple Servers
Managing SQL Server Agent Security
Configuring SQL Server Agent
Creating Operators and Jobs
Creating Alerts
Module 8:
Implementing Replication
Overview of Replication
Implementing Replication
Configuring Replication in Some Common Scenarios
Creating a Publication
Creating a Subscription
Implementing HTTP Merge Replication
Module 9:
Maintaining High Availability
Introduction to High Availability
Implementing Server Clustering
Implementing Database Mirroring
Implementing Log Shipping
Implementing Peer-to-Peer Replication
Configuring Database Mirroring to Support Failover
Implementing Distributed High Availability
培训师介绍
本课程名称: SQL Server 2005管理员培训
查看更多:职业素养公开课