Microsoft 70-462: Administering SQL Server 2012 Databases
Course
Online
This certification will take your skills to the next level!
-
Type
Course
-
Level
Intermediate
-
Methodology
Online
-
Duration
Flexible
-
Start date
Different dates available
-
Online campus
Yes
-
Delivery of study materials
Yes
-
Support service
Yes
-
Virtual classes
Yes
"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"
Facilities
Location
Start date
Start date
About this course
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
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 6 years
Subjects
- Access
- Audit
- Server
- Database
- SQL
- Database training
- Installation
- Install
- Javascript training
- HTML
- Writing
- Networking
- Windows
- Office IT
- Proxy
- Ms Office
Course programme
Module 1
- Introduction to SQL Server 2012
- SQL Server
- SQL Server Tools
- Management Studio Demo
- Data Tools
- Exam Scenarios
- Module Review
- Installing SQL Server
- SQL Architecture
- Hardware Requirements
- Software Requirements
- Installation Process
- Troubleshooting Installation
- Upgrading and Unattended Installations
- Configuration Demo
- Exam Scenarios
- Module Review
- Backup and Restore a Database
- Database Architecture
- Database Backup
- Restoration Process
- Restoring System Database
- Backup and Recovery Dem0
- Exam Scenarios
- Module Review
- Tracing Access to SQL Server
- Auditing Option
- Introduction to SQL Audit
- Audit Objects and Implementation
- Extended Events
- Tracing Activity Demo
- Exam Scenarios
- Module Review
- Importing and Exporting Data
- Introduction to Data Transfer
- ETL Tools
- Improving Data Transfer
- Copying Database Methods
- Transferring Data Demo
- Exam Scenarios
- Module Review
- SQL Server Security
- Security and Authentication
- Server and Database Roles
- Permissions
- Securing SQL Server Demo
- Exam Scenarios
- Module Review
- Automating SQL Server
- SQL Server Agent
- Database Mail
- Operators, Alerts and Jobs
- Database Configuration Demo
- Exam Scenarios
- Module Review
- 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
- Maintaining SQL Server
- Checking Database Integrity
- Indexing
- Ongoing Maintenance
- Managing and Maintaining Demo
- Exam Scenarios
- Module Review
- Troubleshooting SQL Server
- Service Issues
- Connectivity Issues
- Locking Issues
- Troubleshooting Demo
- Exam Scenarios
- Module Review
- Program Review
Microsoft 70-462: Administering SQL Server 2012 Databases