MSSQL Server DBA Weekend batch in Bangalore
Location : karnataka >> bangalore
Posted on : Mar 28,2012
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
[ Please mention viewfreeads.com when contacting ]
Person : Ahana Systems
Phone : 080-26675891
Mobile : 9686113314
Address : Ahana Systems & Solutions (P) Ltd.
105/22, Ist floor, 50 Feet Road
Hanumanth Nagar, Near Nirmala Store Bus Stop
Banashankari, Bangalore – 560050
Website : http://www.ahana.co.in
Related Ads