Why is this exam popular?

SQL Server 2012 is a powerful platform that is widely used in the enterprise and cloud. Many critical systems are based on it. Exam 70-462 is part of a series of certifications that can make you a master of this platform.

What are the eligibility requirements to take the 70-462 exam?

There are no eligibility requirements to take up this course. Register at the Microsoft website and select your exam to schedule with Pearson VUE.

Who should take this exam?

This exam is targeted at database professionals whose primary duties involve installation, configuration, and maintenance tasks.

How do I enroll for the Online training?

You can enroll for the training online. Payments can be made using any of the following options and receipt of the same will be issued to the candidate automatically via email. Visa debit/credit card American express and Diners club card Master Card, or Through PayPal

What will I get along with this training?

You will have access to the online e-learning and practice tests along with the training.

Can I cancel my enrollment? Do I get a refund?

Yes, you can cancel your enrollment. We provide you complete refund after deducting the administration fee. To know more please go through our Refund Policy.

Do you provide any course completion certificate?

Yes, we offer course completion certificate after you successfully complete the training program.

Where and how can I access the e-learning content? Are there any limitations?

Once you register with us for a course by paying the course fee, you can have 24/7 access to the e-learning content on our website. An automated course purchase confirmation mail from our side will guide you through the process.

I am not able to access the online course. Whom should I contact for a solution?

Please raise a request via our Help and Support portal to have your issue resolved.

Do you provide money back guarantee for the training programs?

Yes. We do offer a money-back guarantee for many of our training programs. You can refer to the Refund Policy and raise refund requests via our Help and Support portal.

Administering MS SQL server 2012 Databases Certification Training by Certified Experts

World’s #1 Online Bootcamp

Course Overview

Watch INTRO VIDEO

Key Features

Training for Administering SQL Server 2012 Databases Exam 70-462
15 Hrs of High Quality e-Learning Content
Topics include SQL server security
Maintaining & monitoring SQL server
Covers troubleshooting SQL server
Exam Tips and Techniques

Training Options

Self-Paced Learning

$ 149

Lifetime access to high-quality self-paced e-learning content curated by industry experts
24x7 learner assistance and support

Corporate Training

Customized to your team's needs

Blended learning delivery model (self-paced eLearning and/or instructor-led options)
Flexible pricing options
Enterprise grade Learning Management System (LMS)
Enterprise dashboards for individuals and teams
24x7 learner assistance and support

Course Curriculum

Course Content

Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
Preview
- Lesson 00 - Course Overview
  06:19Preview
  - 0.1 Course Overview
    00:47
  - 0.2 Table of Contents
    00:43
  - 0.3 Objectives
    00:26
  - 0.4 Course Overview
    00:46
  - 0.5 Course Overview (contd.)
    00:55
  - 0.6 Value of Administering SQL Server 2012 for Professionals
    00:47
  - 0.7 Value of Administering SQL Server 2012 for Organizations
    00:38
  - 0.8 Lessons Covered
    00:11
  - 0.9 Exam Pattern
    00:24
  - 0.10 Administering SQL Server 2012 Certification
    00:14
  - 0.11 Sources of Information
    00:14
  - 0.12 Conclusion
    00:14
- Lesson 01 - SQL Server Tools and Installation
  35:18Preview
  - 1.1 SQL Server Tools and Installation
    00:22
  - 1.2 Objectives
    00:38
  - 1.3 SQL Server 2012 Components and Their Uses
    00:09
  - 1.4 SQL Server 2012 Components
    02:33
  - 1.5 Database Engine
    00:50
  - 1.6 Integration Services
    00:54
  - 1.7 Reporting Services
    01:12
  - 1.8 Analysis Services
    00:38
  - 1.9 Planning SQL Server Installation
    00:21
  - 1.10 Installation Requirements
    02:45
  - 1.11 32-Bit vs. 64-Bit Architecture
    02:14
  - 1.12 Scaling
    01:04
  - 1.13 Planning Storage
    03:09
  - 1.14 SQL Server Instances
    01:45
  - 1.15 Installing SQL Server 2012
    00:15
  - 1.16 Steps to Install SQL Server 2012
    02:41
  - 1.17 Steps to Install SQL Server 2012 (contd.)
    01:28
  - 1.18 Security Considerations
    01:54
  - 1.19 Installing SQL Server 2012
    00:12
  - 1.20 Installing SQL Server 2012 Demo 01
    07:11
  - 1.21 Exploring the Installed Components
    00:06
  - 1.22 Exploring the Installed Components Demo2
    01:32
  - 1.23 Quiz
  - 1.24 Summary
    00:42
  - 1.25 Summary (contd.)
    00:42
  - 1.26 Conclusion
    00:01
- Lesson 02 - Managing the Database Server
  26:40Preview
  - 2.1 Managing the Database Server
    00:26
  - 2.2 Objectives
    00:24
  - 2.3 Server Properties and sp configure
    00:12
  - 2.4 Server Properties
    00:55
  - 2.5 Using sp configure
    01:04
  - 2.6 RECONFIGURE Command
    01:26
  - 2.7 Viewing Server Properties and Using sp configure
    00:12
  - 2.8 Viewing Server Properties and Using sp configure Demo 01
    02:15
  - 2.9 Advanced Options
    00:50
  - 2.10 Default Values of sp configure
    00:45
  - 2.11 Enabling Advanced Options, and Viewing and Modifying Them
    00:06
  - 2.12 Enabling Advanced Options, and Viewing and Modifying Them Demo 02
    01:40
  - 2.13 CPU and Memory Architectures
    00:10
  - 2.14 Constraints in Processor Switching
    02:07
  - 2.15 Affinity Masks in SQL Server
    01:12
  - 2.16 Calculating CPU Affinity
    00:58
  - 2.17 SQL Server 2012 Enhancements
    00:54
  - 2.18 Memory Properties
    01:29
  - 2.19 Working with CPU Affinity and Memory Configurations
    00:08
  - 2.20 Working with CPU Affinity and Memory Configurations Demo 03
    03:06
  - 2.21 Configuring Database Mail
    00:09
  - 2.22 Database Mail
    00:45
  - 2.23 Setting up Database Mail
    01:13
  - 2.24 Sending a Mail
    00:42
  - 2.25 Set up Database Mail
    00:05
  - 2.26 Set up Database Mail Demo 04
    02:36
  - 2.27 Quiz
  - 2.28 Summary
    00:42
  - 2.29 Conclusion
    00:09
- Lesson 03 - Managing Databases
  34:10Preview
  - 3.1 Managing Databases
    00:20
  - 3.2 Objectives
    00:30
  - 3.3 Understanding Databases
    00:10
  - 3.4 Database Structure
    01:48
  - 3.5 Types of Databases
    00:52
  - 3.6 Contained Databases
    02:22
  - 3.7 Creating User and Contained Databases
    00:09
  - 3.8 Creating User and Contained Databases Demo 01
    02:36
  - 3.9 System Databases
    00:10
  - 3.10 System Database
    01:24
  - 3.11 Master Database
    00:49
  - 3.12 Model Database
    01:01
  - 3.13 TempDB Database
    01:08
  - 3.14 MSDB Database
    00:59
  - 3.15 Database Options
    00:10
  - 3.16 Auto Close
    01:43
  - 3.17 Auto Shrink
    01:06
  - 3.18 File Space
    01:01
  - 3.19 Moving between Filegroups
    01:19
  - 3.20 Looking at Auto Close and Auto Shrink, and Checking Disk Space of a Database
    00:07
  - 3.21 Looking at Auto Close and Auto Shrink, and Checking Disk Space of a Database Demo 02
    02:44
  - 3.22 Moving between File Groups
    00:07
  - 3.23 Moving between File Groups Demo 03
    05:02
  - 3.24 Recovery Models
    00:10
  - 3.25 Recovery Models
    00:46
  - 3.26 Simple
    01:47
  - 3.27 Full
    01:13
  - 3.28 Bulk Logged
    01:07
  - 3.29 Changing Recovery Model
    00:05
  - 3.30 Changing Recovery Model Demo 04
    00:24
  - 3.31 Quiz
  - 3.32 Summary
    00:53
  - 3.33 Conclusion
    00:08
- Lesson 04 - SQL Server Security
  35:40Preview
  - 4.1 SQL Server Security
    00:20
  - 4.2 Objectives
    00:23
  - 4.3 Security Model and Types of Accounts in SQL Server
    00:08
  - 4.4 Security Layers
    01:15
  - 4.5 Windows Accounts
    01:44
  - 4.6 SQL Server Accounts
    02:26
  - 4.7 Login Accounts
    01:07
  - 4.8 Using Accounts in SQL Server
    00:14
  - 4.9 Using Accounts in SQL Server Demo 01
    04:55
  - 4.10 Server Roles
    00:07
  - 4.11 Rights
    00:51
  - 4.12 Server Roles
    01:29
  - 4.13 Fixed Server Roles
    03:02
  - 4.14 Custom Server Roles
    01:30
  - 4.15 Managing Server Roles
    00:12
  - 4.16 Managing Server Roles Demo 02
    02:24
  - 4.17 Managing Permissions
    00:12
  - 4.18 GRANT
    01:01
  - 4.19 WITH GRANT
    01:06
  - 4.20 DENY
    00:54
  - 4.21 Using GRANT and DENY
    00:11
  - 4.22 Using GRANT and DENY Demo 03
    03:08
  - 4.23 Database Roles and Permissions
    00:15
  - 4.24 Database Roles
    00:23
  - 4.25 Fixed Database Roles
    01:42
  - 4.26 Custom Database Roles
    00:25
  - 4.27 Using Database Roles
    00:06
  - 4.28 Using Database Roles Demo 04
    03:19
  - 4.29 Quiz
  - 4.30 Summary
    00:42
  - 4.31 Conclusion
    00:09
- Lesson 05 - Advanced Security in SQL Server
  42:52Preview
  - 5.1 Advanced Security in SQL Server
    00:19
  - 5.2 Objectives
    00:22
  - 5.3 Working with Digital Certificates
    00:12
  - 5.4 Digital Certificates
    02:18
  - 5.5 Private and Public Keys
    02:28
  - 5.6 Keys in SQL Server
    01:08
  - 5.7 Certificate Based Logins
    00:37
  - 5.8 Certificate Based Logins (contd.)
    00:38
  - 5.9 Creating Certificate Based Logins
    00:08
  - 5.10 Creating Certificate Based Logins Demo 01
    04:14
  - 5.11 Auditing and Policies
    00:07
  - 5.12 SQL Server Auditing
    01:33
  - 5.13 Audit Specifications
    01:14
  - 5.14 Audit Reports
    01:02
  - 5.15 Creating and Viewing Audits
    00:14
  - 5.16 Creating and Viewing Audits Demo 2
    05:35
  - 5.17 Policy Based Management
    00:15
  - 5.18 Policy
    00:55
  - 5.19 Advantages of Policy
    01:03
  - 5.20 Components of Policy
    00:58
  - 5.21 Setting up Policy Based Management
    00:08
  - 5.22 Setting up Policy Based Management Demo 3
    05:24
  - 5.23 Encryption and Compression
    00:13
  - 5.24 Encryption in SQL Server
    00:26
  - 5.25 Transparent Data Encryption
    01:30
  - 5.26 Column Level Encryption
    01:09
  - 5.27 Compression
    00:49
  - 5.28 Using TDE and Compression
    00:09
  - 5.29 Using TDE and Compression Demo 4
    06:58
  - 5.30 Quiz
  - 5.31 Summary
    00:36
  - 5.32 Conclusion
    00:10
- Lesson 06 - Working with Indexes and Files
  39:43Preview
  - 6.1 Working with Indexes and Files
    00:21
  - 6.2 Objectives
    00:20
  - 6.3 Understanding Indexes
    00:15
  - 6.4 Indexes
    03:14
  - 6.5 Index Types
    01:48
  - 6.6 Other Index Types
    01:04
  - 6.7 Adding an Index to a Table
    00:06
  - 6.8 Adding an Index to a Table Demo 01
    01:47
  - 6.9 Introduction to Full Text Indexing
    00:12
  - 6.10 Need for Full Text Indexing
    01:28
  - 6.11 Full Text Indexing
    02:58
  - 6.12 Full Text Search
    04:17
  - 6.13 Setting up FTI and Querying Using FTS
    00:08
  - 6.14 Setting up FTI and Querying Using FTS Demo 02
    04:18
  - 6.15 New Index Types in SQL Server 2012
    00:11
  - 6.16 Column Store Index
    02:01
  - 6.17 FILESTREAM
    00:56
  - 6.18 FILETABLE
    00:59
  - 6.19 Using a Column Store Index
    00:05
  - 6.20 Using a Column Store Index Demo 03
    01:44
  - 6.21 Setting up New iFilters for FTI
    00:08
  - 6.22 Setting up New iFilters for FTI Demo 04
    02:20
  - 6.23 Setting up a New FILETABLE
    00:08
  - 6.24 Setting up a New FILETABLE Demo 05
    07:52
  - 6.25 Quiz
  - 6.26 Summary
    00:52
  - 6.27 Conclusion
    00:11
- Lesson 07 - Maintaining Reliability of SQL Server Installations
  25:53Preview
  - 7.1 Maintaining Reliability of SQL Server Installations
    00:25
  - 7.2 Objectives
    00:20
  - 7.3 Detaching and Attaching Databases
    00:09
  - 7.4 Detaching a Database
    01:53
  - 7.5 Attaching a Database
    00:46
  - 7.6 Detach and Attach a Database
    00:06
  - 7.7 Detach and Attach a Database Demo 01
    01:29
  - 7.8 Database Backup and Restoration
    00:13
  - 7.9 Backups
    02:31
  - 7.10 Backup Strategies
    01:20
  - 7.11 Restore
    00:41
  - 7.12 Scheduling Backups
    00:45
  - 7.13 Backup, Restore, and Scheduling of Backup
    00:09
  - 7.14 Backup, Restore, and Scheduling of Backup Demo 02
    02:26
  - 7.15 High Availability
    00:10
  - 7.16 What Is High Availability
    00:54
  - 7.17 Clustering
    02:07
  - 7.18 Replication
    02:15
  - 7.19 Mirroring
    00:40
  - 7.20 AlwaysOn
    00:48
  - 7.21 Set up an SQL Server Cluster
    00:05
  - 7.22 Set up an SQL Server Cluster Demo 03
    04:49
  - 7.23 Quiz
  - 7.24 Summary
    00:42
  - 7.25 Conclusion
    00:10
- Lesson 08 - Optimizing Servers
  20:02Preview
  - 8.1 Optimizing Servers
    00:20
  - 8.2 Objectives
    00:18
  - 8.3 Benchmarking Server Performance
    00:09
  - 8.4 System Benchmarks
    01:01
  - 8.5 Resource Governor
    00:56
  - 8.6 PerfMon
    01:01
  - 8.7 Using Resource Governor and PerfMon
    00:09
  - 8.8 Using Resource Governor and PerfMon Demo 01
    04:16
  - 8.9 DMVs and SQL Profiler
    00:09
  - 8.10 Dynamic Management View (DMV)
    01:11
  - 8.11 SQL Profiler
    01:17
  - 8.12 Using DMVs
    00:07
  - 8.13 Using DMVs Demo 02
    02:58
  - 8.14 Using SQL Profiler
    00:07
  - 8.15 Using SQL Profiler Demo 03
    00:07
  - 8.16 Optimizing Indexes
    00:10
  - 8.17 Index Statistics
    00:57
  - 8.18 Fragmentation of Indexes
    01:09
  - 8.19 View Index Statistics
    00:05
  - 8.20 View Index Statistics Demo 04
    02:19
  - 8.21 View and Rebuild Index to Reduce Fragmentation
    00:05
  - 8.22 View and Rebuild Index to Reduce Fragmentation Demo 05
    00:27
  - 8.23 Quiz
  - 8.24 Summary
    00:35
  - 8.25 Conclusion
    00:09
- Lesson 09 - Troubleshooting Errors in SQL Server
  21:02Preview
  - 9.1 Troubleshooting Errors in SQL Server
    00:22
  - 9.2 Objectives
    00:20
  - 9.3 SQL Server Errors and Handling Issues
    00:07
  - 9.4 SQL Server Errors
    00:50
  - 9.5 Database Console Commands
    00:53
  - 9.6 DBCC Error Handling
    00:57
  - 9.7 Using DBCC
    00:11
  - 9.8 Using DBCC Demo 01
    01:57
  - 9.9 Traces
    00:07
  - 9.10 Trace Flags
    02:01
  - 9.11 Using Trace Flags
    00:05
  - 9.12 Using Trace Flags Demo 02
    02:03
  - 9.13 Extended Events
    00:08
  - 9.14 What Are Extended Events
    00:25
  - 9.15 Use XEvents
    00:06
  - 9.16 Use XEvents Demo 03
    02:46
  - 9.17 Database Recovery
    00:07
  - 9.18 Database Failure
    01:12
  - 9.19 Recovering a Database without a Backup
    00:08
  - 9.20 Recovering a Database without a Backup Demo 04
    05:33
  - 9.21 Quiz
  - 9.22 Summary
    00:34
  - 9.23 Conclusion
    00:10
- Lesson 10 - Advanced Server Management
  36:44Preview
  - 10.1 Advanced Server Management
    00:20
  - 10.2 Objectives
    00:19
  - 10.3 Virtualization and SQL Server
    00:07
  - 10.4 What Is Virtualization
    02:15
  - 10.5 SQL Server and Virtualization
    01:20
  - 10.6 Running SQL Server in a Virtual Environment
    00:09
  - 10.7 Running SQL Server in a Virtual Environment Demo 01
    01:40
  - 10.8 Updating SQL Server
    00:07
  - 10.9 Updates Management
    02:12
  - 10.10 Patch Deployment
    02:06
  - 10.11 Updating SQL Server 2012
    00:06
  - 10.12 Updating SQL Server 2012 Demo 02
    06:07
  - 10.13 Data Tier Applications
    00:12
  - 10.14 Client Application Connections
    01:58
  - 10.15 Data Tier Applications
    01:58
  - 10.16 Deployment Process
    02:09
  - 10.17 Deploy Structure to Different Databases Using DTA
    00:08
  - 10.18 Deploy Structure to Different Databases Using DTA Demo 03
    04:51
  - 10.19 Sync Changes Made to Main Database Using DTA
    00:08
  - 10.20 Sync Changes Made to Main Database Using DTA Demo 04
    03:33
  - 10.21 Export Data and Structure to a New Server Using DTA
    00:10
  - 10.22 Export Data and Structure to a New Server Using DTA Demo 05
    03:52
  - 10.23 Quiz
  - 10.24 Summary
    00:51
  - 10.25 Conclusion
    00:06

Exam & Certification

Why is this exam popular?
SQL Server 2012 is a powerful platform that is widely used in the enterprise and cloud. Many critical systems are based on it. Exam 70-462 is part of a series of certifications that can make you a master of this platform.
What are the eligibility requirements to take the 70-462 exam?
There are no eligibility requirements to take up this course. Register at the Microsoft website and select your exam to schedule with Pearson VUE.
Who should take this exam?
This exam is targeted at database professionals whose primary duties involve installation, configuration, and maintenance tasks.

Reviews

Richard Ellis
This is definitely an interesting course for getting a hang of how to administer SQL server
Mohit Singh
Good course, handy and easy to follow content
Altaf Hussain
This course offered by Simplilearn is quite interesting and useful for everyone who is looking for developing skills on SQL server

prevNext

Why Online Bootcamp

Develop skills for real career growthCutting-edge curriculum designed in guidance with industry and academia to develop job-ready skills
Learn from experts active in their field, not out-of-touch trainersLeading practitioners who bring current best practices and case studies to sessions that fit into your work schedule.
Learn by working on real-world problemsCapstone projects involving real world data sets with virtual labs for hands-on learning
Structured guidance ensuring learning never stops24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts

FAQs

How do I enroll for the Online training?
You can enroll for the training online. Payments can be made using any of the following options and receipt of the same will be issued to the candidate automatically via email.
1. Visa debit/credit card
2. American express and Diners club card
3. Master Card, or
4. Through PayPal
What will I get along with this training?
You will have access to the online e-learning and practice tests along with the training.
Can I cancel my enrollment? Do I get a refund?
Yes, you can cancel your enrollment. We provide you complete refund after deducting the administration fee. To know more please go through our Refund Policy.
Do you provide any course completion certificate?
Yes, we offer course completion certificate after you successfully complete the training program.
Where and how can I access the e-learning content? Are there any limitations?
Once you register with us for a course by paying the course fee, you can have 24/7 access to the e-learning content on our website. An automated course purchase confirmation mail from our side will guide you through the process.
I am not able to access the online course. Whom should I contact for a solution?
Please raise a request via our Help and Support portal to have your issue resolved.
Do you provide money back guarantee for the training programs?
Yes. We do offer a money-back guarantee for many of our training programs. You can refer to the Refund Policy and raise refund requests via our Help and Support portal.
Do you provide any course completion certificate?
Yes, we offer course completion certificate after you successfully complete the training program.
I want to know more about the training program. Whom do I contact?
Please join our Live Chat for instant support, call us, or Request a Call Back to have your query resolved.

Disclaimer
PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.

Administering MS SQL server 2012 Databases Certification Training

World’s #1 Online Bootcamp

Course Overview

Key Features

Training Options

Self-Paced Learning

Corporate Training

Course Curriculum

Course Content

Administering Microsoft SQL Server 2012 Databases (Exam 70-462)

Lesson 00 - Course Overview

0.1 Course Overview

0.2 Table of Contents

0.3 Objectives

0.4 Course Overview

0.5 Course Overview (contd.)

0.6 Value of Administering SQL Server 2012 for Professionals

0.7 Value of Administering SQL Server 2012 for Organizations

0.8 Lessons Covered

0.9 Exam Pattern

0.10 Administering SQL Server 2012 Certification

0.11 Sources of Information

0.12 Conclusion

Lesson 01 - SQL Server Tools and Installation

1.1 SQL Server Tools and Installation

1.2 Objectives

1.3 SQL Server 2012 Components and Their Uses

1.4 SQL Server 2012 Components

1.5 Database Engine

1.6 Integration Services

1.7 Reporting Services

1.8 Analysis Services

1.9 Planning SQL Server Installation

1.10 Installation Requirements

1.11 32-Bit vs. 64-Bit Architecture

1.12 Scaling

1.13 Planning Storage

1.14 SQL Server Instances

1.15 Installing SQL Server 2012

1.16 Steps to Install SQL Server 2012

1.17 Steps to Install SQL Server 2012 (contd.)

1.18 Security Considerations

1.19 Installing SQL Server 2012

1.20 Installing SQL Server 2012 Demo 01

1.21 Exploring the Installed Components

1.22 Exploring the Installed Components Demo2

1.23 Quiz

1.24 Summary

1.25 Summary (contd.)

1.26 Conclusion

Lesson 02 - Managing the Database Server

2.1 Managing the Database Server

2.2 Objectives

2.3 Server Properties and sp configure

2.4 Server Properties

2.5 Using sp configure

2.6 RECONFIGURE Command

2.7 Viewing Server Properties and Using sp configure

2.8 Viewing Server Properties and Using sp configure Demo 01

2.9 Advanced Options

2.10 Default Values of sp configure

2.11 Enabling Advanced Options, and Viewing and Modifying Them

2.12 Enabling Advanced Options, and Viewing and Modifying Them Demo 02

2.13 CPU and Memory Architectures

2.14 Constraints in Processor Switching

2.15 Affinity Masks in SQL Server

2.16 Calculating CPU Affinity

2.17 SQL Server 2012 Enhancements

2.18 Memory Properties

2.19 Working with CPU Affinity and Memory Configurations

2.20 Working with CPU Affinity and Memory Configurations Demo 03

2.21 Configuring Database Mail

2.22 Database Mail

2.23 Setting up Database Mail

2.24 Sending a Mail

2.25 Set up Database Mail

2.26 Set up Database Mail Demo 04

2.27 Quiz

2.28 Summary

2.29 Conclusion