面议
课程内容：课程大纲
课程模块 | 课程内容 | 实验内容 |
| Module 1 Installing and Configuring SQL Server | l Preparing to Install SQL Server l Installing SQL Server 2005 l Managing a SQL Server 2005 Installation | l Performing an Installation l Managing SQL Server |
| Module 2: Managing Databases and Files | l Planning Databases l Creating Databases l Managing Databases | l Creating a Database l Monitoring and Managing Filegroup Usage l Viewing Database metadata |
| Module 3: Disaster Recovery
| l Planning a Backup Strategy l Backing Up User Databases l Restoring User Databases l Performing online Restore Operations l Recovering Data from Database Snapshots l System Database and Disaster Recovery | l Implementing a Backup Strategy l Restoring and Recovering a Database l Performing Piecemeal Backup and Restore Operations l Restoring the master Database |
| Module 4: Managing Security
| l Overview of SQL Server Security l Protecting the Server Scope l Protecting the Database Scope l Managing Keys and Certificates in SQL Server | l Creating Logins and Assigning Server-Scope Permissions l Creating and Managing Users l Using a Certificate to Protect Data |
| Module 5: Monitoring SQL Server
| l Viewing Current Activity l Using System Monitor l Using SQL Server Profiler l Using DDL Triggers l Using Event Notifications | l Monitoring SQL Server Performance l Tracing SQL Server Activity l Implementing DDL Triggers
|
| Module 6: Transferring Data
| l Overview of Data Transfer l Introduction to SQL Server Integration Services l Using SQL Server Integration Services l Features of SQL Server Integration Services | l Creating an SSIS Package l Deploying an SSIS Package l Using SSIS to Extract Data, Perform Lookups, Sort, and Split Data
|
| Module 7: Automating Administrative Tasks
| l Automating Administrative Tasks l Configuring the SQL Server Agent l Creating Jobs and Operators l Creating alerts l Managing Multiple Servers l Managing SQL Server Agent Security | l Configuring SQL Server Agent l Creating Operators and Jobs l Creating alerts |
| Module 8: Implementing Replication | l Overview of Replication l Implementing Replication l Configuring Replication in Some Common Scenarios | l Creating a Publication l Creating a Subscription l Implementing HTTP Merge Replication
|
| Module 9: Maintaining High Availability | l Introduction to High Availability l Implementing Server Clustering l Implementing Database Mirroring l Implementing Log Shipping l Implementing Peer-to-Peer Replication | l Configuring Database Mirroring to Support Failover l Implementing Distributed High Availability
|