Administering Microsoft SQL Server 2012/2014 Databases (Course & Lab)

Availability: Continuous

Length: 39 Hours

Department: Information Technology
Semester: Continuous
Duration: 39 Hours

Department: Information Technology
Semester: Continuous
Method: Online
Duration: 39 Hours

Prepare for the Microsoft MCSA 70-462 certification exam with the Administering Microsoft SQL Server 2012/2014 Databases course and lab. The lab can be mapped to any course, textbook, or training, therefore, adding value and hands-on components to training. The course and lab provide complete coverage of the MCSA 70-462 exam objectives and will help you master the skills required for installing SQL server, implementing migration strategies, configuring SQL server components, managing SQL server, managing and configuring databases, collecting and analyzing troubleshooting data, restoring databases, implementing and maintaining indexes, managing database security, troubleshooting security, and implementing replication.

  • Introduction

  • Planning and Installing SQL Server

  • Implementing a Migration Strategy

  • Configuring SQL Server Components

  • Managing SQL Server Agent

  • Managing and Configuring Databases

  • Configuring SQL Server Instances

  • Managing SQL Server Instances

  • Identifying Concurrency Problems and Troubleshooting Data

  • Auditing SQL Server Instances

  • Backing Up and Restoring Databases

  • Implementing and Maintaining Indexes

  • Exporting and Importing Data

  • Implementing Security

  • Clustering and AlwaysOn

  • Implementing Replication

  • High School Diploma or Equivalent

  • Age must be 18 years or above

  • English Proficiency

  • SQL Server Developer

  • SQL Database Administrator

  • SQL Server Database Integrator

  • SQl Server Database Administrator

  • Senior SQl Server Database Administrator