Full Vendor Map
Click on any vendor logo to review a full list of available courses
What People Are Saying
-
"Thank you so much for helping me with my Microsoft and Cisco certification training.
The Practice Labs are incredible. Having access to a 'live', 'hands-on' virtual environment has really helped me pass my Microsoft certifications.
The learning content is well structured and the two years access means I can achieve multiple certifications without having to rush. Thanks"
Jake Main 30/08/2012
-
"From the moment my work colleagues and I were shown the course demonstration I knew this was for us.
We find that it works really well to go to the Practice Labs at the end of each learning session. The immediate and practical reinforcement of the ideas presented makes learning and retention much easier.
Happy to refer others to your products."
Michael Campbell 06/01/2013
-
"We went with the catalogue offer. It gave us access to many certifications from different venders. This choice meant that people in our team always had learning options that coincided with the changing work responsibilities. Your access charges were reasonable and this meant that more people in the team had access to training and IT certifications. Thanks"
Heather Bayes 10/10/2012
Microsoft 70-462: Administering SQL Server 2012 Databases (MS_70-462)
Your Own Virtual Machine
Real Experience in a Virtual Environment
* Multiple Paths Available
Microsoft
Cisco
CompTIA
Other
Microsoft 70-462: Administering SQL Server 2012 Databases (MS_70-462)
Course 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
Language:
EnglishType of Course:
Self Paced