"Microsoft SQL Server DBA Training in Bangalore" is no longer available

No Reviews Yet

Koramangala 6th Block, Bangalore

Course ID: 18328

Koramangala 6th Block, Bangalore

No Reviews Yet

Date and Time

Not decided yet.

Pradeep

MTech

About Pradeep

More than 10 years experience in to teachning field
No reviews currently Be the First to Review

About the Course

sql server DBA is an eminent technolgy in the IT Sector.

Topics Covered

Course Title : SQL Server 2008 DBA
Duration : 4 weeks / Approx. 45 hours of training
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

Who should attend

All are elgible for this Training

Pre-requisites

Knowledge on Database Basics


What you need to bring

Laptop, Pen and Book, some materials

Key Takeaways

Gain the knowledge and experience on this technology

Reviews

No reviews currently Be the First to Review

Discussions

Post your requirement and let us connect you with best possible matches for Corporate Training Post your requirement now

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more