Administering Microsoft SQL Server 2014 Databases

Overview


This module will teach students how to maintain a MS SQL Server 2014 database. After completing this module, students will be able to explain core database administration tasks, restore databases from backups, carry out ongoing database maintenance and set up and configure SQL Server 2014.

This course prepares you for Exam 70-462. Download Course Contents
Schedule & Prices
Course Details Schedule
Classroom Training*
Duration : 5 Days
Fee :  London: £4,500, Dubai : $2,610 , India : $1,796


December
15-19 (Dubai)
16-20 (Bangalore)
16-20 (London)
23-27 (Chennai)
January
07-11 (London)
13-17 (Delhi)
13-17 (Dubai)
13-17 (London)
19-23 (Dubai)
20-24 (Bangalore)
20-24 (London)
27-31 (Chennai)
February
10-14 (Delhi)
10-14 (london)
16-20 (Dubai)
17-21 (Bangalore)
17-21 (london)
March
09-13 (Delhi)
09-13 (london)
Instructor-Led Online Training
Duration : 5 Days
Fee :  $2,330


December
15-19
16-20
23-27
January
07-11
13-17
19-23
20-24
27-31
February
10-14
16-20
17-21
March
09-13
Fly-Me-a-Trainer
Duration : 5 Days
Fee : On Request
Client's Location
As per mutual convenience

Enquire Now




Input symbols

Course Prerequisites

  • Some experience with database design
  • Working knowledge of Transact-SQL
  • Working knowledge of relational databases
  • Knowledge of the MS Windows operating system


Upon Completion of this Course, you will accomplish following:-

  • Describe common database administration tasks
  • Perform post-installation configuration tasks
  • Configure the buffer pool extension
  • Perform copy-only, compressed, and encrypted backups
  • Use Performance Monitor to monitor SQL Server
  • Manage database-level security principals
  • Implement SQL Server audit
  • Manage SQL Server audit
  • Configure Database Mail
  • Generate Database Tuning Recommendations
  • Monitor SQL Server errors
  • Manage Server-Level Security
  • Manage Database-Level Security
  • Use captured traces to test, troubleshoot, and optimize database performance

Give an edge to your career with Microsoft certification training courses. Students can join the classes for 20462: Administering Microsoft SQL Server 2014 Databases Training & Certification Course at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.

Recommended Courses and Certification: