
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