MSSQL Server 2008: Database Administration
Our Course Catalouge
-
Storage
- NetApp Admin
- Oracle
- Sybase
- MySQL
- MS SQL
- Group Policy Mgmt
- Network Infra Mgmt
- Active Directory
- Power Shell
- W2K8 Hyper V
- Linux Admin
- Perl Programming
- Shell Scripting
- VMWARE ESX Admin
- VMWARE View Admin
- Citrix Presentation Server
- Xen Server Admin
- Cloud Computing
- ClearCase Admin
- Microsoft Sharepoint
- Symantec Backup Exec
- Websphere
Databases
Windows Related
UNIX Related
Scripting
Virtualisation, Cloud and Thin Client Technology
Version Control
Collaboration and Info Management
Data Retention and Management
Middleware and Web
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
Email: contact@ahana.co.in
Call us on
(+91)80 26675891 (India)
(+44)20 7993 8018 (UK)
(+1) 408 416 3150 (US)
Chat With Us
Quick Enquiry
News & Highlights
- 150+ individuals completed trainging with us in 2010
- We completed 20+ corporate trainings in 2010
- Around 95% of the attendees provided excellent rating in the feedback
Click here for a snippet of feedback database - More than 90% of the freshers have secured a job in IT Infrastructure field with in 6 months of completing some key courses with us




