SQL Server 2008: Database Administration
Module 1: Installing and Configuring SQL Server
- Preparing to Install SQL Server
- Installing SQL Server
- Configuring a SQL Server Installation
Module 2: Managing Databases and Files
- Planning Databases
- Creating Databases
- Using Policy-Based Management
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 Databases and Disaster Recovery
Module 4: Managing Security
- Overview of SQL Server Security
- Protecting the Server Scope
- Protecting the Database Scope
- Protecting the Server Scope
- Auditing Security
Module 5: Transferring Data
- Overview of Data Transfer
- Introduction to SQL Server Integration Services
Module 6: 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
Module 7: Implementing Replication
- Overview of Replication
- Managing Publications and Subscriptions
- Configuring Replication in Some Common Scenarios
Module 8: Maintaining High Availability
- Introduction to High Availability
- Implementing Log Shipping
- Implementing Database Mirroring
- Implementing Server Clustering
- Using Distributed High Availability Solutions
Module 9: Monitoring SQL Server
- Viewing Current Activity
- Using SQL Server Profiler
- Monitoring with DDL Triggers
- Using Event Notifications
Module 10: Troubleshooting and Performance Tuning
- Troubleshooting SQL Server
- Performance Tuning in SQL Server
- Using Resource Governor
- Using Data Collector
Contact Us:
Ahana Systems & Solutions (P) Ltd.
105/22, Ist floor, 50 Feet Road
Hanumanth Nagar, Near Nirmala Store Bus Stop
Banashankari, Bangalore – 560050
Call Us
+91 80 26675891 (INDIA)
+91 80 65462066 (INDIA)
+44 20 7993 8018 (UK)
+1 408 416 3150 (US)
9686113314 (M)
E-Mail Us
Email: contact@ahana.co.in
Web : http://www.ahana.co.in |
