Administering Microsoft SQL Server Databases (M20462)

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

Book Now

Administering Microsoft SQL Server 2014 Databases (M20462)

Overview 1

Outlines 2

FAQs 3

What's Included 4

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: