Microsoft SQL Server 2012 Certification Training Exam 70-462

Study For The Microsoft 70-462 Exam - Administering Microsoft SQL Server 2012 Databases
4.3 (111 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
3,375 students enrolled
$50
Take This Course
  • Lectures 109
  • Contents Video: 12 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2013 English

Course 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.

What are the requirements?

  • A Desire To Learn

What am I going to get from this course?

  • To Study And Pass The Microsoft 70-462 Exam and Gain Certification For MCSA or MCSE

What is the target audience?

  • IT Professionals who wish to gain Microsoft Certification

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
0101 What Is Exam 70-462?
Preview
02:20
0102 What You Should Expect From The Videos
Preview
03:54
Section 2: Installation And Configuration
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
Section 3: Maintain Instances And Databases
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
Section 4: Optimization And Troubleshooting
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
Section 5: Manage Data
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
Section 6: Implement Security
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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Infinite Skills, High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

Ready to start learning?
Take This Course