MCSA: SQL Server 2014 Infocenter Training Institute

    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?

    Didn't find what you were looking for ?

    or