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

No Reviews Yet

Koramangala 6th Block, Bangalore

Course ID: 18447

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 a popular database related technology in the IT Market.

Topics Covered

Course Title : SQL Server 2012 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
? Using SQL Server Profiler
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: New features of SQL Server 2012
? AlwaysOn
? Contained Databases
? ColumnStore Indexes
? T-SQL Enhancements
? ShowPlan Enhancements
? Indirect checkpoints

Who should attend

All Working and Non Working people can attend for this Programme

Pre-requisites

Knowledge on Database Concepts

What you need to bring

Laptop,Pen and Notebook

Key Takeaways

Gain the knowledge on SQL Server Database

Reviews

No reviews currently Be the First to Review

Discussions (1)

Do you cover certification?

By Surender

Write an answer
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