Course details

This track is intended for IT Professionals who administer and maintain SQL Server 2014 databases. It focuses on the essential skills and knowledge to run and maintain the next wave of advanced database and information solutions.

General Objectives

  • SQL Server 2014 product features and tools
  • Maintaining a database
  • Installing and configuring SQL Server 2014
  • Managing databasefiles
  • Backing up and restoring databases
  • Managing security

Skills Earned

  • How to use Microsoft SQL Server 2014 Management Studio
  • How to retrieve and filter data
  • How to group and summarize data by using Transact-SQL
  • How to display data from multiple tables
  • How to modify data in tables
  • How to install and configure SQL Server 2014
  • How to secure a database
  • How recover data after its loss
  • How to backup and restore databases
  • How to create and manage users
  • How to configure database mails, alerts and notifications

Target Audience

  • Database Administrators
  • System Administrators
Updated on 08 November, 2015

About Infocenter Training Institute

infocenter IT workshops are carefully designed to assist all IT personnel who are expected to jump right into projects implementation within a limited time frame in order to prepare and upgrade their skills. These workshops are a deep dive into the “HOW TO” scenarios, designed based on our experienced trainers. Real life examples are implemented into most of the hands-on training in a way that minimizes the gap between what is learned and what is required. This type of hands on training is mandatory to summarize the big picture of every product.

See all Infocenter Training Institute courses
Are you from Infocenter Training Institute ? Claim your course!
Courses you can instantly connect with... Do an online course on MCSA starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or