Microsoft 70-462: Administering SQL Server 2012 Databases

£495.00

Description

Description

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 unauthorized 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 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 SQL 2012 Administering Databases course prepares you for the Microsoft Exam 70-462 – 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

Syllabus:

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 Dem0
  • Exam Scenarios
  • Module Review

Module 4

  • Tracing Access to SQL Server
  • Auditing Option
  • 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

Course Delivery:    Online