Development
Databases
Microsoft 70-462
Microsoft SQL Server 2012 Certification Training Exam 70-462
4.3 (602 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6,445 students enrolled

Microsoft SQL Server 2012 Certification Training Exam 70-462

Study For The Microsoft 70-462 Exam - Administering Microsoft SQL Server 2012 Databases
4.3 (602 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6,445 students enrolled
Created by Infinite Skills
Last updated 9/2013
English
English [Auto]
Preview this course
Microsoft SQL Server 2012 Certification Training Exam 70-462
Current price: $34.99 Original price: $49.99 Discount: 30% off
5 hours left at this price!
Buy now
30-Day Money-Back Guarantee
This course includes
  • 12 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • To Study And Pass The Microsoft 70-462 Exam and Gain Certification For MCSA or MCSE
Course content
Expand all 109 lectures 11:45:09
+ – Installation And Configuration
21 lectures 02:46:55
0201 Growing And Shrinking Databases
Preview 09:49
0202 Monitoring Database Growth
07:35
0203 Designing Database Storage
10:23
0204 Configure An SQL Server Standby Server - Part 1
13:52
0205 Configure An SQL Server Standby Server - Part 2
07:06
0206 Changing Service Accounts
13:12
0207 Testing Database Connectivity
10:08
0208 Installing SQL Server Database Engine - Part 1
11:37
0209 Installing SQL Server Database Engine - Part 2
11:35
0210 Installing SQL Server Database Engine - Part 3
08:52
0211 Installing SQL Server Database Engine - Part 4
05:00
0212 Installing SQL Server Integration Services
07:02
0213 Enabling And Disabling Features
07:21
0214 Moving Databases Via Detach/Attach
07:46
0215 Migrating Logins
06:30
0216 Creating A Full Text Index
05:13
0217 Configuring FILESTREAM
01:29
0218 Configuring FILETABLE
01:33
0219 Create And Manage SQL Agent Jobs - Part 1
09:22
0220 Create And Manage SQL Agent Jobs - Part 2
04:30
0221 Setup Multi-Server Jobs
07:00
+ – Maintain Instances And Databases
28 lectures 03:13:05
0301 Using Multiple Files And Filegroups
07:57
0302 Recovery Models
06:07
0303 Adding New Filegroups
02:24
0304 Moving Tables Between Filegroups
06:05
0305 Enabling Contained Databases
04:57
0306 Data Compression
10:20
0307 Configuring TDE
06:51
0308 Setting Up Table Partitioning - Part 1
09:15
0309 Setting Up Table Partitioning - Part 2
10:20
0310 Managing Log File Growth - Part 1
08:32
0311 Managing Log File Growth - Part 2
02:13
0312 DBCC CHECKDB
09:10
0313 Installing Default And Named Instances - Part 1
07:48
0314 Installing Default And Named Instances - Part 2
05:42
0315 CPU Affinity
05:26
0316 Instance Level Settings - Part 1
09:13
0317 Instance Level Settings - Part 2
09:02
0318 Instance Level Settings - Part 3
10:51
0319 Memory Settings
05:17
0320 Database Mail
08:40
0321 Fillfactor
06:44
0322 Installing A Clustered Instance - Part 1
07:58
0323 Installing A Clustered Instance - Part 2
08:38
0324 Installing A Clustered Instance - Part 3
09:19
0325 Installing A Clustered Instance - Part 4
01:48
0326 Multi-Instance Clustering
03:56
0327 Multi-Subnet Clustering
04:27
0328 Recover From A Failed Cluster Node
04:05
+ – Optimization And Troubleshooting
14 lectures 01:58:59
0401 Replication For Reporting - Part 1
08:22
0402 Replication For Reporting - Part 2
11:54
0403 Replication For Reporting - Part 3
12:23
0404 Replication For Reporting - Part 4
07:36
0405 Diagnosing Locking And Blocking - Part 1
08:52
0406 Diagnosing Locking And Blocking - Part 2
06:14
0407 Diagnosing Wait Stats
11:29
0408 Using SQL Profiler
10:15
0409 Using Performance Monitor - Part 1
07:33
0410 Using Performance Monitor - Part 2
05:29
0411 Using Extended Events
08:24
0412 Using SQL Server Auditing
08:14
0413 Using Data Collector
05:21
0414 Using Policy Based Management
06:53
+ – Manage Data
24 lectures 01:57:03
0501 Define Recovery Models
04:04
0502 Mirrored Backups
01:39
0503 Stripped Backups
02:39
0504 Restoring Full Backups
04:16
0505 Restoring Differential Backups
05:41
0506 Restoring Transaction Log Backups
04:15
0507 File Group Restores
04:11
0508 Testing Backups
02:32
0509 Restoring Master Database
05:23
0510 Restoring msdb Database
00:48
0511 Restoring model Database
00:32
0512 Restoring Databases Protected By TDE
03:49
0513 Restoring A Single Database Page
02:12
0514 Point In Time Restores
05:33
0515 Index Maintenance
10:22
0516 Identifying Index Fragmentation
04:34
0517 Identifying Unused Indexes
06:32
0518 Filtered Indexes
03:23
0519 Updating Statistics
03:38
0520 Full Text Indexes
15:09
0521 Column Store Indexes
07:51
0522 Import Export Wizard
05:54
0523 BCP
08:31
0524 Bulk Insert
03:35
+ – Implement Security
13 lectures 54:21
0601 Logins Vs. Users
02:57
0602 Creating Logins
05:54
0603 Fixed Server Roles
05:47
0604 User Defined Server Roles
04:11
0605 Certificate Logins
02:18
0606 Instance Level Permissions
03:15
0607 Database Level Permissions
05:13
0608 Fixed Database Roles
05:43
0609 User Defined Database Roles
02:49
0610 Application Roles
04:15
0611 Creating Database Users
06:06
0612 Managing Certificates
02:18
0613 Endpoint Security
03:35
+ – Implement High Availability
6 lectures 44:32
0701 Configure Database Mirroring
10:54
0702 Configure AlwaysOn Availability Groups - Part 1
10:33
0703 Configure AlwaysOn Availability Groups - Part 2
07:58
0704 Failing Over Database Mirroring
02:37
0705 Failing Over AlwaysOn Availability Groups
07:54
0706 Monitoring Database Mirroring
04:36
Requirements
  • A Desire To Learn
Description

This SQL Server 70-462 exam training course by Infinite Skills teaches you everything you need to know to pass the Administering Microsoft SQL Server 2012 Databases Server 2012 exam. It is required that you pass the 70-462 Exam in order to earn your MCSA and MCSE certifications from Microsoft.

The course takes you through each of the topics that you will have to master in order to pass the SQL Server 2012 70-462 exam. Throughout this tutorial video, you will learn how to install and configure the SQL Server, maintain instances and databases, optimize and troubleshoot, manage data, and implement security and high availability. Each topic is broken down into step-by-step lessons, allow you to quickly learn and retain the information more effectively.

Once you have completed this video based training course for the Microsoft SQL Server 70-462 exam, you will have a comprehensive understanding of how to Administer Databases with Microsoft SQL Server 2012. You will be fully prepared to write, and pass, your 70-462 exam and continue towards earning your MCSA and MCSE certifications.

How to take the Microsoft 70-462 Exam:

1. Find a test center near you to take the SQL Server 70-462 certification exam, their will provide details on test center locations and schedules. This exam is typically priced around $150 dollars.

2. Study the required material to pass the 70-462 examination. This course covers the material that is within the 70-462 certification exam, and will help put you in a great position to succeed in the exam

3. Pass your exam!

4) Take our Microsoft Windows Server 70-461 and 70-463 courses which will prepare you for the 70-461 and 70-463 exams. Upon passing the 70-461, 70-462, and 70-463 exams you will become a Microsoft Solutions Certified Associate in Microsoft SQL Server 2012.

5. Tell your friends how easy passing the Microsoft 70-462 exam was using Infinite Skills training courses

The information laid out above is given in good faith, we are not endorsing and third party company by offering a link to their site. You should always do your own research prior to making a purchase or using any service linked to via this website. Prices or details may alter and any information listed can not be guaranteed to be accurate. Note: While this course is comprehensive in regards to covering material on the exam, we do recommend using other aids to guide your study.

Who this course is for:
  • IT Professionals who wish to gain Microsoft Certification