Administering Topics Microsoft SQL Server 2012

Overview

Administering Microsoft SQL Server 2012 Exam 70-462 Training

Key Topics

• Audit SQL Server instances
• Back up databases
• Configure additional SQL Server components, Instances and Services
• Deploying a SQL Server
• Implementing strategies, column stores and High-Availability and Disaster Recovery solutions
• Importing/exporting
• Install SQL Server and related services.
• Maintenance
• Management, configuration, permissions, alerts, logins and roles.
• Optimization
• Installation Planning
• Restoring
• Troubleshooting

The participant in the SQL 2012 Administering 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

Description

Module 1

• Introduction to SQL Server 2012
• SQL Server
• SQL Server Tools
• Management Studio Demo
• Data Tools
• Exam Scenarios
• Module Review

Module 2

• Installing SQL Server
• SQL Architecture
• Hardware Requirements
• Software Requirements
• Installation Process
• Troubleshooting Installation
• Upgrading and Unattended Installations
• Configuration Demo
• Exam Scenarios
• Module Review

Module 3

• Backup and Restore a Database
• Database Architecture
• Database Backup
• Restoration Process
• Restoring System Database
• Backup and Recovery Demo
• Exam Scenarios
• Module Review

Module 4

• Tracing Access to SQL Server
• Auditing Options
• Introduction to SQL Audit
• Audit Objects and Implementation
• Extended Events
• Tracing Activity Demo
• Exam Scenarios
• Module Review

Module 5

• Importing and Exporting Data
• Introduction to Data Transfer
• ETL Tools
• Improving Data Transfer
• Copying Database Methods
• Transferring Data Demo
• Exam Scenarios
• Module Review

Module 6

• SQL Server Security
• Security and Authentication
• Server and Database Roles
• Permissions
• Securing SQL Server Demo
• Exam Scenarios
• Module Review

Module 7

• Automating SQL Server
• SQL Server Agent
• Database Mail
• Operators, Alerts and Jobs
• Database Configuration Demo
• Exam Scenarios
• Module Review

Module 8

• Monitoring SQL Server
• Dynamic Management Views and Functions
• Profiler Trace
• Database Tuning Advisor
• Activity and Performance Monitor
• Data Collection
• Monitoring Demo
• Exam Scenarios
• Module Review

Module 9

• Maintaining SQL Server
• Checking Database Integrity
• Indexing
• Ongoing Maintenance
• Managing and Maintaining Demo
• Exam Scenarios
• Module Review

Module 10

• Troubleshooting SQL Server
• Service Issues
• Connectivity Issues
• Locking Issues
• Troubleshooting Demo
• Exam Scenarios
• Module Review
• Program Review