A Quick Glance

  • black-arrow

    Understand core administrations tasks of SQL Server 2014

  • black-arrow

    Get the required technical skills to administer database using SQL Server 2014

  • black-arrow

    The course is developed by highly experienced Microsoft Certified Trainers

  • black-arrow

    Become a database administrator and handle database like a pro

  • black-arrow

    Pentagon Training offers this course at an affordable price

  • black-arrow

    Gain the certification and accomplish your career goals

Every business whether large or small makes use of a database to handle their data. The problem arises when the amount of data is gigantic and maintaining such large piles of data is quite difficult. Companies make use of various database management systems like Oracle Database and MySQL etc.

Nowadays SQL Server is being used due to its various excellent features for efficient management of data. SQL Server contains all the features required to manage relational database management system. It is easy to deploy a database, but it is hard to administer and maintain it. There are various reasons to use SQL Server like it provides excellent performance, security, data restoration and recovery, etc. Today most widely used DBMS across the world is Microsoft SQL Server.

With the increase of data, the demand for database administrators has also increased. Database administrators are responsible for design, deploy, administer and maintain databases in an organisation. In Pentagon Training’s Administering Microsoft SQL Server 2014 Databases (M20462) course delegates will understand about various SQL Server tools and features for maintaining a database.

 

Who should take this course

The intended audience for Administering Microsoft SQL Server 2014 databases course is database administrators, database developers and those delegates who maintain databases.

Delegates whose primary area of responsibility is to handle and maintain SQL Server databases can take this course.

Delegates who develop applications that provide content from SQL Server database.

Other delegates who work in a database environment where database play a significant role in their work can enrol in this course.

More

Prerequisites

The delegate should have knowledge of Microsoft Windows Operating system and its core functions.

Knowledge of Transact-SQL programming and Database management system can be beneficial.

Experience in database designing can also be beneficial.

More

What Will You Learn

  • Understand core administration tasks and tools of SQL server for handling databases
  • Install and configure SQL Server
  • Learn to configure SQL Server databases and manage its storage.
  • Plan and install the backup strategy as well as learn to restore databases from backups
  • Import and export data
  • Track and trace SQL Server activity
  • Secure SQL Server and manage its security
  • Maintain the existing database
  • With the help of SQL Server Agent jobs automate maintenance of SQL Server
  • Configure other features of database like mail, alerts and notifications
More

What's included

  Course Overview

In Administering Microsoft SQL Server 2014 Databases (M20462), course learn how to configure and maintain database management system at the enterprise level. Learn about SQL Profiler, SQL Server Agent, and high availability and appropriately manage data. Also understand core administration tasks like restoring databases from a backup, securing the database, maintaining existing databases and configure SQL Server 2014. Become a database administrator and perform well at the job.

More

  Course Content

Introduction to SQL Server 2014 database administration

In this topic understand about Microsoft SQL Server platform and its components. Editions and versions of SQL Server 2014 and other tasks performed by SQL Server database.

  • Database Administration Overview
  • Introduction to SQL Server Platform
  • Database Management Tools
  • Database Management Techniques

Install and configure SQL Server 2014

In this module understand about resource requirements for SQL Server 2014 and how to fix it.

  • SQL Server installation planning
  • Install SQL Server 2014
  • Post installation configuration

Working with Database and Storage

In this module, know how data is stored in the database, how to develop the database, how to manage and move the databases. Get an understanding of other tasks like managing and storing temp DB database. Learn to use fast storage devices to extend SQL Server bullet pool caches.

  • 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

In this module how to plan a backup strategy for various parts of the database like logs, data, etc.

  • Understand SQL Server Recovery Models
  • Plan Backup strategy
  • Backup Databases and Transaction Logs
  • Use Backup options
  • Ensure Backup Reliability

Restore SQL Server 2014 Databases

In this module learn how to restore user and system databases and methods to implement recovery.

  • Know restore process
  • Restore databases
  • Advanced restore scenarios
  • Work with point in time recovery

Import and Export data

In this module understand about SQL Server explore tools and techniques to efficiently import and export data to and from SQL Server.

  • Introduction to Transferring Data
  • Import and Export Table Data
  • Copy or Move a Database

Monitor SQL Server 2014

In this module understand in detail how to use standard SQL Server tools like views (DMF’s and DVM’s), Activity Monitor, Dynamic management functions and performance monitor.

  • Introduction to Monitoring SQL Server
  • Dynamic management functions and views
  • Performance monitor

Tracing SQL Server 2014

In this module learn to use SQL Profiler and SQL Trace stored procedures for information capture. Also, learn methods to troubleshoot and enhance SQL Server performance for managing workloads.

  • Tracing SQL Server Security
  • Using Traces

Manage SQL Server Security

In this topic understand major concepts of SQL Server Security Architecture and learn to manage security at server and database level.

  • Introduction to SQL Server Security
  • Manage Server level security
  • Manage Database Level Principle
  • Manage Database Permissions

Auditing Data Access and Encrypting Data

This module describes present options for doing auditing in SQL Server, learn to use and manage SQL Server audit feature and implement encryption.

  • Audit Data Access in SQL Server
  • Perform SQL Server Audit

Performing Ongoing Database Maintenance

Understand common database tasks for maintenance that Database Administrator must perform. Also, understand how to automate these database tasks using maintenance plans.

  • Overview of Database Integrity
  • Maintain database indexes
  • Database Maintenance Routine Automation

Automate SQL Server 2014 Management

In this module learn to implement multiple server jobs, automating tasks and configuring security context using SQL Server Agent.

  • 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

It covers configuration of database mail, alerts and notifications.

  • Monitor SQL Server Errors
  • Configure Database Mail
  • Set operators, Alerts and Notifications
More


Administering Microsoft SQL Server 2014 Databases (M20462) Enquiry

 

Enquire Now


----- OR -------

Reach us at +44 1344 961530 or info@pentagonit.co.uk for more information.

About Reading

Located in Berkshire, Reading is a large and historically significant town. It was an important center of trade as well as religion in the medieval period. The Reading Abbey, still has its  12th century abbey gateway and significant ruins intact. Due to the English Civil War the town was damaged severely, causing a significant loss in trade. Reading also played an important role in the Revolution of 1688. It is where the revolution's only significant military action was took place. The Great Western Railway , the brewing business, baking and seed growing all happened in 19th century. Now,Reading boasts of being a  major commercial centre, that involves information technology and insurance. Reading   has, despite its nearness to London, a net inward traveler flow.

 

Reading came up as a settlement way  back in the 8th century. It had become the largest town in Berkshire by 1525 and had a population of around 5000 in the early 17th Century. It was in the 18th century that major iron works in the town came up and the city saw the growth of the brewing business for which Reading is known till date. It was in the 19th century that Reading saw the growth of manufacturing business also.

Economy

Reading is a vital commercial centre in the Thames Valley and Southern England. It is home to the headquarters of many British companies and UK offices of foreign multinationals. It is also a  major retail centre. Daily Reading has an inflow of 30,000 commuters as compared to 24,000 departures. Large companies such as  Microsoft and Oracle  have their headquarters in Reading. Other businesses in Reading are Prudential, PepsiCo and Wrigley. In 2007, an independent poll placed Reading 16th in a league table of best performing retail centres in the UK.

Culture

Reading is known for its Reading Beer Festival which was first held in 1994 and is now known to be one of the largest beer festivals in the UK. It takes place at King's Meadow for the five days immediately preceding the May Day bank holiday every year.  Reading Pride also takes place at Reading, an annual LGBTA festival in Kings Meadow.

 

Museums

The Museum of Reading  contains galleries that showcase the history of Reading . The museum is also home to the excavations of Calleva Atrebatum. It also houses a full-size replica of the Bayeux Tapestry, an art collection, and galleries relating to Huntley and Palmers.

Located in East Reading, The Museum of English Rural Life,is dedicated to the changing face of rural England. It also has collections of public value. It is not only owned but also managed by the University of Reading. The Ure Museum of Greek Archaeology, the Cole Musum of Zoology and the Harris Botanic Gardens are also under the same management. All these museums can be found on the university's Whiteknights Campus.

There is also a small Riverside Museum at Blake's Lock which tells one about Reading's two rivers, the Thames and the Kennet. The Museum of Berkshire Aviation  houses a collection of aircraft and other aviation accessories.

 

 

More