In Administering Microsoft SQL Server 2014 Databases (M20462), the delegates will get the knowledge and skills required to maintain a Microsoft SQL Server 2014. The course mainly focuses on teaching delegates how to use SQL Server 2014 features and tools for the maintenance of a SQL Server database.
It is intended for delegates who are interested in learning SQL Server 2012 or 2014. This course covers new features in SQL Server 2014 and also accomplish SQL Server data platform.
Learn skills required to manage Microsoft SQL Server 2014
Develop an understanding of core concepts of SQL Server Database Administration
Get trained by our highly experienced Microsoft Certified Trainers
More career opportunities at organization level
Work efficiently as a Database Administrator
Gain the certification and get a hike in salary
Maven training offers this course at an affordable price
Key Learning Points
What Will You Learn
In this Maven training Administering Microsoft SQL Server 2014 Databases (M20462) course, get the complete knowledge to handle Microsoft SQL Server 2012 or 2014. It focuses on central concepts of database administration like storage of data, backup and restoration, learn to import and export data, database security and maintenance as well as SQL Server Agent.
It also covers the latest features of Microsoft SQL Server 2014 and learn to implement these elements across SQL Server data platform. This course is taught by our Microsoft Certified Trainers that follow the Microsoft Curriculum. Administering Microsoft SQL Server 2014 Databases (M20462) course covers the whole skills and knowledge measured required at the workplace to got more exposure.
Introduction to SQL Server 2014 database administration
In this module get knowledge about Microsoft SQL Server platform. Also, understand about components. Editions and versions of SQL Server 2014 and other tasks that database administrator perform for SQL Server.
Install and configure SQL Server 2014
In this learn to assess resource requirements for SQL Server 2014 and how to fix it.
Working with Database and Storage
In this understand how data is stored in the database and how to develop the database. Other is how to manage and move the databases. Other tasks are like storing, managing the temp DB database and using fast storage devices to extend SQL Server bullet pool caches are also discussed in this module.
Plan and Implement a Backup Strategy
Restore SQL Server 2014 Databases
In this know how to restore user and system databases and ways to implement point in time recovery.
Import and Export data
In this delegates will explore tools and techniques so that delegate can import and export data to and from SQL Server.
Monitor SQL Server 2014
This module explains in brief how to use commonly used tools like Activity Monitor, Dynamic management functions and views (DMF’s and DVM’s) as well as a performance monitor.
Tracing SQL Server 2014
In this learn how to use SQL Profiler and SQL Trace store procedures for information capture about SQL Server. Also, learn how to troubleshoot and optimise SQL Server workloads.
Manage SQL Server Security
In this learn about core concepts on which SQL Server Security architecture is based and learn to manage security at server and database level.
Auditing Data Access and Encrypting Data
It describes present options for doing auditing in SQL Server, learns to use and manage SQL Server audit feature and to implement encryption.
Performing Ongoing Database Maintenance
It describes common database tasks for maintenance that Database Administrator must perform and also tell how to automate these tasks by making use of maintenance plans.
Automate SQL Server 2014 Management
In this module learn how to use SQL Server Agent to automate jobs, configure security contexts for jobs and ways to implement multi-server jobs.
Monitor SQL Server 2014 by using Alerts and Notifications
It covers configuration of database mail, alerts and notifications.
Administering Microsoft SQL Server 2014 Databases (M20462) Enquiry
Maven Training provides top-notch training at different venues across the world. We offer nearly 200 courses at 1000+ locations. Our learning programs are the blend of thorough understanding and application of skills.View All Locations