About this course

COURSE OVERVIEW

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 backups stored effectively, and securing data from unauthorized access is also a candidate for this training course on SQL.

COURSE CONTENTS

As the participant in the SQL 2012 Administering course will learn:

• Installation Planning
• Installing SQL Server and related services
• Implementation of a migration strategy
• How to configure additional SQL Server components
• Managing the SQL Server Agent
• Database management and configuration
• How to configure SQL Server instances
• Implementing a SQL Server clustered instance
• SQL Server instances management
• How to properly Identify and resolve concurrency problems
• The collection of and how to analyze troubleshooting data
• Auditing SQL Server instances
• Configure and maintain a back up strategy
• Database restoration
• Implementing and maintaining indexes
• Importing and exporting data
• Managing logins and server roles
• Managing database permissions
• Managing users and database roles
• Troubleshooting security
• Implementing AlwaysOn, database mirroring and replication

PROGRESSION

After this course you will be able to enroll to other NIIT courses such as

• OS AND NETWORKING
• IT SECURITY
• MOBILE APPS DEVELOPMENT

MODULES

To receive complete course outline sign in HERE and we will get back to you shortly!