Administering Microsoft SQL Server 2014 Databases (M20462)

  • Know about the basic administration jobs and learn how to handle them using SQL Server 2014

  • Learn to administer a SQL Server 2014 database

  • Training program delivered by certified professionals

Key Points About Administering Microsoft SQL Server 2014 Databases (M20462)

237 Learners Recommended

Duration: 5 Days*

Accredited: Yes

Book Now

Administering Microsoft SQL Server 2014 Databases (M20462)

Course Overview

The Administering Microsoft SQL Server 2014 Databases (M20462) course provides fundamental knowledge required to configure and maintain database management system in an organisation. It goes on to elaborate about the SQL Profiler, SQL Server Agent etc. Also, the core concepts of database including restoring databases from a backup, securing the database, maintaining existing databases and configuring SQL Server 2014 are taught in this course.

Course Outline

  • Introduction to SQL Server 2014 Database Administration
    • Database Administration Overview
    • Introduction to SQL Server Platform
    • Database Management Tools
    • Database Management Techniques
  • Install and Configure SQL Server 2014
    • SQL Server installation planning
    • Install SQL Server 2014
    • Post-installation configuration
  • Working with Database and Storage
    • Introduction to Data Storage with SQL Server
    • Manage storage for system databases
    • Manage storage for user databases
    • Move databases files
    • Configure buffer pool extension
  • Plan and Implement a Backup Strategy
    • Understand SQL Server Recovery Models
    • Plan Backup strategy
    • Backup Databases and Transaction Logs
    • Use Backup options
    • Ensure Backup Reliability
  • Restore SQL Server 2014 Databases
    • Know restore process
    • Restore databases
    • Advanced restore scenarios
    • Work with point in time recovery
  • Import and Export data
    • Introduction to Transferring Data
    • Import and Export Table Data
    • Copy or Move a Database
  • Monitor SQL Server 2014
    • Introduction to Monitoring SQL Server
    • Dynamic management functions and views
    • Performance monitor
  • Tracing SQL Server 2014
    • Tracing SQL Server Security
    • Using Traces
  • Manage SQL Server Security
    • Introduction to SQL Server Security
    • Manage Server level security
    • Manage Database Level Principle
    • Manage Database Permissions
  • Auditing Data Access and Encrypting Data
    • Audit Data Access in SQL Server
    • Perform SQL Server Audit
  • Performing Ongoing Database Maintenance
    • Overview of Database Integrity
    • Maintain database indexes
    • Database Maintenance Routine Automation
  • Automate SQL Server 2014 Management
    • SQL Server Management Automation
    • Perform and manage SQL Server Agent jobs
    • Manage Job Step Security Contexts
    • Manage Jobs on Multiple Servers
  • Monitor SQL Server 2014 by using Alerts and Notifications
    • Monitor SQL Server Errors
    • Configure Database Mail
    • Set operators, Alerts, and Notifications
  • The delegate must have knowledge of Windows Operating system and its core functions.
  • Knowledge of T-SQL and Database operations is also required.
  • Experience in database designing can also be beneficial.

Anyone responsible for administering and maintaining databases can take the course. Apart from these, it is highly beneficial for:

  • Database Administrators
  • Database Developers
  • Application Developers

The Administering Microsoft SQL Server 2014 Databases (M20462) Cost in United Kingdom Starts from £3735.00

Please see our Microsoft SQL Server Training courses available in United Kingdom

  • Key Learning Points
  • Tutor Support
  • Certification
telephone

Get More Information

Still have questions? We’re happy to help.

calendar

Dates & Prices

Choose a Location

Choose a Month

Learn from the comfort of your home or office

Join discussions via computer or mobile device

Interact with subject matter experts

40 Hours (on average)

90 Days Access

Certificate upon completion

Schedule and location of your choice

Save on travel costs

Monitor employee development

Key points about this course

237 Learners Recommended

Duration: 5 Days*

Accredited: Yes

Add additional features

Official Exam - £ 329.00

Personal career coach and career services

Your online (Administering Microsoft SQL Server 2014 Databases (M20462)) package

Upon purchase you will receive a password via the email you used to purchase the course.

You will then be able to login to our online learning platform with your email and password.

You will have access to the platform for 90 days to complete your course.

Course Onsite Enquiry

Administering Microsoft SQL Server 2014 Databases (M20462)

Complete the steps below to receive a quote or more information

Your details

How many employees need training test?

When would you like to take the course test?

How many employees need training?

Prev

Discover how we are doing

Our goal is to always provide training of the highest quality for your organisation.

We aim for customer satisfaction across all areas, including price, quality, and learning support. We always use the feedback from clients to continually improve and ensure we surpass expectation. Have a look at our customer reviews that showcase the standard we offer.

97% price

Response Rate

99% price

Positive Rating

Steps For Success

Leading Path To Success

works