Administering Microsoft SQL Server 2012
Learning at home
Summary
- This course is an apprenticeship
Overview
Administering Microsoft SQL Server 2012 Exam 70-462 Training Course
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.
This training course covers: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 Adminstering 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
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
Requirements
Entry Requirements
Our Administering Microsoft SQL Server 2012 course is openly available to anyone wishing to learn more about Microsoft SQL Server 2012 and has a keen interest in the subject, plus an intention to progress a career.
- Learners will need sufficient numeracy and literacy
- Students should have access to a computer and the internet throughout your study period.
- Learners should have netoworking skills in order to progress throughout the course.
- You should be fully committed to your studies.
Questions and answers
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.