Microsoft 70-462: Administering SQL Server 2012 Databases

About this course

This training course was created specifically for those individuals (Database Professionals) who install, maintain and configure as their primary job function. Any participants setting up database systems and/or responsible for efficient system operation, regular database back ups stored effectively, and securing data from unauthorised access is also a candidate for this training course on SQL 2012. Below is a partial list of job functions associated to this training course: Audit SQL Server instancesBack up databasesConfigure additional SQL Server components, Instances and ServicesDeploying a SQL ServerImplementing strategies, columnstores and High-Availability and Disaster Recovery solutionsImporting/exportingInstall SQL Server and related services.MaintenanceManagement, configuration, permissions, alerts, logins and roles.OptimizationInstallation PlanningRestoringTroubleshooting The SQL 2012 Administering Databases course prepares you for the Microsoft Exam 70-462 - As the participant in the SQL 2012 Adminstering course will learn: Installation PlanningInstalling SQL Server and related servicesImplementation of a migration strategyHow to configure additional SQL Server componentsManaging the SQL Server AgentDatabase management and configurationHow to configure SQL Server instancesImplementing a SQL Server clustered instanceSQL Server instances managementHow to properly Identify and resolve concurrency problemsThe collection of and how to analyze troubleshooting dataAuditing SQL Server instancesConfigure and maintain a back up strategyDatabase restorationImplementing and maintaining indexesImporting and exporting dataManaging logins and server rolesManaging database per