Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

MS SQL Server 2012 Administration Training

8 Reviews

Srinivasa Nagar, Bangalore

Course ID: 17824

Srinivasa Nagar, Bangalore

Students Interested 0 (Seats Left 0)

8 Reviews

About the Course

MSSQL Server 2012 DBA

Topics Covered

MSSQL Server 2012 DBA
Lesson 1: Introduction to SQL Server 2012 and its Toolset
Introduction to the SQL Server Platform
Working with SQL Server Tools
Configuring SQL Server Services
Lab : Introduction to SQL Server and its Toolset
Lesson 2: Preparing Systems for SQL Server 2012
Overview of SQL Server Architecture
Planning Server Resource Requirements
Pre-installation Testing for SQL Server
Lab : Preparing Systems for SQL Server

Lesson 3: Installing and Configuring SQL Server 2012
Preparing to Install SQL Server
Installing SQL Server
Upgrading and Automating Installation
Lab : Installing and Configuring SQL Server

Lesson 4: Working with Databases
Overview of SQL Server Databases
Working with Files and File groups
Moving Database Files
Lab : Working with Databases
Lesson 5: Understanding SQL Server 2012 Recovery Models
Backup Strategies
Understanding SQL Server Transaction Logging
Planning a SQL Server Backup Strategy
Lab : Understanding SQL Server Recovery Models

Lesson 6: Backup of SQL Server 2012 Databases
Backing up Databases and Transaction Logs
Managing Database Backups
Working with Backup Options
Lab : Backup of SQL Server Databases

Lesson 7: Restoring SQL Server 2012 Databases
Understanding the Restore Process
Restoring Databases
Working with Point-in-time recovery
Restoring System Databases and Individual Files
Lab : Restoring SQL Server 2012 Databases

Lesson 8: Importing and Exporting Data
Transferring Data To/From SQL Server
Importing & Exporting Table Data
Inserting Data in Bulk
Lab : Importing and Exporting Data
Lesson 9: Authenticating and Authorizing Users
Authenticating Connections to SQL Server
Authorizing Logins to Access Databases
Authorization Across Servers
Lab : Authenticating and Authorizing Users

Lesson 10: Assigning Server and Database Roles
Working with Server Roles
Working with Fixed Database Roles
Creating User-defined Database Roles
Lab : Assigning Server and Database Roles

Lesson 11: Authorizing Users to Access Resources
Authorizing User Access to Objects
Authorizing Users to Execute Code
Configuring Permissions at the Schema Level
Lab : Authorizing Users to Access Resources

Lesson 12: Auditing SQL Server Environments
Options for Auditing Data Access in SQL
Implementing SQL Server Audit
Managing SQL Server Audit
Lab : Auditing SQL Server Environments

Lesson 13: Automating SQL Server 2012 Management
Automating SQL Server Management
Working with SQL Server Agent
Managing SQL Server Agent Jobs
Lab : Automating SQL Server Management

Lesson 14: Configuring Security for SQL Server Agent
Understanding SQL Server Agent Security
Configuring Credentials
Configuring Proxy Accounts
Lab : Configuring Security for SQL Server Agent

Lesson 15: Monitoring SQL Server 2012 with Alerts and Notifications
Configuration of Database Mail
Monitoring SQL Server Errors
Configuring Operators, Alerts and Notifications
Lab : Monitoring SQL Agent Jobs with Alerts and Notifications

Lesson 16: Performing Ongoing Database Maintenance
Ensuring Database Integrity
Maintaining Indexes
Automating Routine Database Maintenance
Lab : Performing Ongoing Database Maintenance
Lesson 17: Tracing Access to SQL Server 2012
Capturing Activity using SQL Server Profiler
Improving Performance with the Database Engine Tuning Advisor
Working with Tracing Options
Lab : Tracing Access to SQL Server 2012

Lesson 18: Monitoring SQL Server 2012
Monitoring Activity
Capturing and Managing Performance Data
Analyzing Collected Performance Data
Lab : Monitoring SQL Server 2012

Lesson 19: Managing Multiple Servers
Working with Multiple Servers
Virtualizing SQL Server
Deploying and Upgrading Data-Tier Applications
Lab : Managing Multiple Servers

Lesson 20: Troubleshooting Common SQL Server 2012 Administrative Issues
SQL Server Troubleshooting Methodology
Resolving Service-related Issues
Resolving Concurrency Issues
Resolving Login and Connectivity Issues
Lab : Troubleshooting Common Issues

Who should attend

Any Individual Interested in SQL DBA


We will Start from the Basic

What you need to bring

We will provide the requried stuff

Key Takeaways

MSSQL Server 2012 DBA Certificate

Date and Time

Not decided yet.

About the Trainer

5 Avg Rating

15 Reviews

1 Students

10 Courses

More than four year of experience in SQL server domain starting from development to DBA and training. Worked on numerous projects related to deployment and maintains of SQL server 7.0/2000/2005/2008 on Windows 2000/2003/2008 platform.

Student Feedback


Average Rating




Santosh S Joshi

The training offered was of high quality and exceeded our expectations. The cost factor made the return on investment very high. The professionalism displayed by the resources was really appreciable. The training instructor was highly experienced and gave practical examples which helped a lot. We would be planning more training sessions with Ahana in the future.


Ganga Nagaiah

I am very proud to be trained at Ahana.I was not in a position to decide on my future career path. Ahana gave me lots exposure in Sybase. I am very grateful to all the staff at Ahana. They provided excellent training during the course duration and mentored me after finishing my course as well. Also we were able to utilize labs at all time.



I am delighted to attend the Sybase DBA training in Ahana Systems and Solutions.I never expected such a fulfilling training experience with unlimited Lab facility and very highly experienced faculty. All the doubts and confusions were cleared.The knowledge i gained cant be defined but i learned more than my specific course such as soft skills,tips to clear interviews, real-time exposure and mainly how to grow to next levels.


Prashanth Kumar

Now anybody looking out for Sybase training in India can blindly approach this place to cater to their technical needs, as this place is not only for money, unlike some other places, but its a place where people believe "KNOWLEDGE IS POWER".Also, This bunch of people at "AHANA" are truly enthusiastic towards their goal and they are working with a vision and have potential to reach their goal and I wish Mr.Umashankar and his team "Good Luck".


Sathiya Priya R.V

I am extremely pleased with the methodology of the training. The transition from the basic to the advanced level was taken care in a very diligent manner that befits a very good training organization.


Vivek Singh

My couple weeks training with Ahana was quite fruitful. The sybase training techniques paid a lot of emphasis on relating theory and lab to real life production scenarios in corporate world backed with Ahana's training faculty's superior knowledge of the sybase ASE product.


Sridhar N

Hats off to the team that has put together this programme!! The Ahana team has actually managed to build a priceless storehouse. As an Oracle9i and Sybase DBA student here, I have thoroughly enjoyed my learning. I also believe that the courses that I have done at Ahana makes me a better person in any Software Organization.


Gourav Kumar

It has been a great learning experience for me at Ahana. They make things look very easy and learning great fun. The classes are highly regressive with focus on practical requirements of the IT industry. They discuss each and every aspect of the subject in core and demonstrate it practically in the Labs. All in all it is a BETTER GOOD INSTITUTE and I express my best wishes in all their future endeavors.


Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for IT Courses Post your requirement now


Submit your enquiry for MS SQL Server 2012 Administration Training

Please enter valid question or comment

Please select a category

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Ahana Systems

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, 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 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