Description

This training will provide you with the knowledge necessary to install, configure and administer SQL Server 2012. You will also learn backup and restore operations as well as server monitoring. This course covers all the topics necessary to prepare for the Microsoft 70-462 exam.

Who is this training for ?

For whom ?

Database administrators, operations managers, system administrators and engineers.

Prerequisites

Training objectives

Install and configure SQL server 2012/2014Monitor and track server activity

Plan and implement a backup strategy

Plan and implement a backup strategy

Enter an educational objective here

Training program

• Basics and installation of SQL Server 2012/2014
  • Introduction to SQL Server administration.
  • Administrative tools and tasks.
  • Plan an installation.
  • Configuration of the database.
  • Practical work Getting started with SQL Server Management Studio.
  • Installation and configuration of SQL Server 2012/2014.
• Storage and databases
  • How SQL Server stores data? Storing system and user databases.
  • Buffer pool extension.
  • Works practices Create a database.
• Backing up and restoring a SQL Server database
  • How to set up a backup? The different options.
  • Backup and reliability.
  • The restoration process.
  • Advanced restore operations.
  • Hands-on Perform a database backup and restore.
  • Restore database transaction log backups.
• Data transfer
  • Importing and exporting data.
  • Tools and techniques for transferring data.
  • Copying or moving a database.
  • Practical work Example of data transfer.
• Monitor and track server activity
  • The activity monitor.
  • The performance analyzer.
  • Tracing the activity of the SQL Server workload.
  • Troubleshooting.
  • Optimizing database performance.
  • Hands-on Using the performance analyzer.
  • Example of database troubleshooting.
• Security management
  • Basic security concepts in the SQL Server security architecture.
  • Security at the server and database level.
  • Permissions .
  • Data access audit.
  • Data encryption.
  • Practical work Set up security and audit.
  • Example of data encryption.
• Server maintenance and task automation
  • The importance of data integrity.
  • Organize maintenance.
  • Automate management tasks.
  • Practical work rnCreate a task and automate it.
• Alerts and notifications
  • Overview of alerts and notifications.
  • Check SQL Server errors.
  • Hands-on Implement notifications and alerts.