Materi training ini membahas tentang pengetahuan dan teknik-teknik untuk melakukan maintenance, konfigurasi dan administrasi database Microsoft SQL Server 2008. Dalam modul ini dipelajari bagaimana caranya menggunakan fitur-fitur dan tools di SQL Server 2008 yang berhubungan dengan aktivitas sebagai database administrator

Durasi : 5 hari

• Installing and Configuring SQL Server
  • SQL Server Installation
  • SQL Server Configuration

• Managing Databases and Files
  • Planning Databases
  • Creating Databases
  • Policy-Based Management

• Disaster Recovery
  • Planning a Backup Strategy
  • Backing Up User Databases
  • Restoring User Databases
  • Performing Online Restore Operations
  • Recovering Database Snapshots Data
  • System Databases and Disaster Recovery

• Managing Security
  • Overview of SQL Server Security
  • Protecting the Server Scope
  • Protecting the Database Scope
  • Protecting the Server Scope
  • Auditing Security

• Transferring Data
  • Overview of Data Transfer
  • Introduction to SQL Server Integration Services

• Automating Administrative Tasks
  • Automating Administrative Tasks in SQL Server
  • Using SQL Server Agent
  • Creating Maintenance Plans
  • Implementing Alerts
  • Managing Multiple Servers
  • Managing SQL Server Agent security

• Implementing Replication 
  • Overview of Replication
  • Managing Publications and Subscriptions
  • Configuring Replication

• Maintaining High Availability
  • Introduction to High Availability
  • Implementing Log Shipping
  • Implementing Database Mirroring
  • Implementing Server Clustering
  • Distributed High Availability Solutions

• Monitoring SQL Server
  • Viewing Current Activity
  • Using SQL Server Profiler
  • Monitoring with DDL Triggers
  • Using Event Notifications

• Troubleshooting and Performance Tuning
  • Troubleshooting SQL Server
  • Performance Tuning in SQL Server
  • Using Resource Governor
  • Using Data Collector