loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for MSSQL Server 2012 DBA Online/Onsite Training.

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

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

Connect With Ahana Systems & Solutions

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com 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 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

Share

course photo

MSSQL Server 2012 DBA Online/Onsite Training.

Banashankari 1st Stage, Bangalore

No Reviews Yet
0 Interested

About the Course


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

Topics Covered

Introduction to SQL Server 2012 and its Toolset
Introduction to the SQL Server Platform
Working with SQL Server Tools
Configuring SQL Server Services

Who should attend

Any one.

Pre-requisites

Engineering.

What you need to bring

NIL

Key Takeaways

MSSQL DBA
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer


C. K. Chidananda Murthy brings with him a rich experience of 14 years in the training field.
Associated with AHANA SYSTEMS AND SOLUTIONS since 2008 as a Technical Trainer.
Seats Left-

Students Interested 0

Course Id: 18364