MCSA SQL Server 2014 | infocenter Kuwait

Skip Navigation LinksHome > Training Center > Microsoft Courses > MCSA: SQL Server 2014

Call 1824636

MCSA: SQL Server 2014

Description

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

Details

Course Title Hrs
20461: Querying Microsoft SQL Server 40
20462: Administering Microsoft SQL Server Databases 40
20463: Implementing a Data Warehouse with Microsoft SQL Server 40

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