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

BITTS International Career College > Administering Microsoft SQL Server 2012/2014 Databases (Course & Lab)
Information Technology
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.

students at BITTS

Administering Microsoft SQL Server certification is designed for professionals who perform installation, maintenance, and configuration of databases. 

Quick Application Form

Entry requirements

  • High School Diploma or Equivalent
  • Age must be 18 years or above
  • English Proficiency

Course structure and modules

  • 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

Career opportunities

  • SQL Server Developer
  • SQL Database Administrator
  • SQL Server Database Integrator
  • SQl Server Database Administrator
  • Senior SQl Server Database Administrator