STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online!

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
Live Online Training (Instructor-Led)
Duration : 5 Days (10 Day for 4 Hours/Day)
Fee : USD 1,400 (1-on-1)†



April

8 Hours/Day
4 Hours/Day
13-17
20-24
27-01
13-22
20-29
27-06
May

8 Hours/Day
4 Hours/Day
11-15
25-29
11-20
25-03
June

8 Hours/Day
4 Hours/Day
08-12
08-17
WeekEnd- 18-Apr 19-Apr 25-Apr 26-Apr
Fly-Me-a-Trainer
Duration : 5 Days
Fee : On Request
Client's Location
As per mutual convenience
Classroom Training*
Duration : 5 Days
Fee : Sydney : USD 3,000 London : USD 3,200 Dubai : USD 2,700 India : USD 1,700
April
13-22 (Birmingham) (Venue)
13-17 (Brisbane) (Venue)
13-17 (London) (Venue)
13-17 (Manchester) (Venue)
13-17 (Melbourne) (Venue)
13-17 (Sydney) (Venue)
20-29 (Bangalore) (Venue)
27-06 (Chennai) (Venue)
May
11-20 (Birmingham) (Venue)
11-15 (Brisbane) (Venue)
11-15 (London) (Venue)
11-15 (Manchester) (Venue)
11-15 (Melbourne) (Venue)
11-15 (Sydney) (Venue)
25-03 (Chennai) (Venue)
June
08-17 (Birmingham) (Venue)
08-12 (Brisbane) (Venue)
08-12 (London) (Venue)
08-12 (Manchester) (Venue)
08-12 (Melbourne) (Venue)
08-12 (Sydney) (Venue)
WeekEnd- 18-Apr 19-Apr 25-Apr 26-Apr Dubai (Venue)

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:

 

)