Availability: Continuous
Length: 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
