MCSA Administering Microsoft SQL Server 2012/2014 Databases Video Course

70-462: MCSA Administering Microsoft SQL Server 2012/2014 Databases

Your Microsoft 70-462 exam is just around the corner, right? So, it's high time to find an effective preparation tool! Our training course is what you really need! This is a series of videos led by the experienced IT instructors who will provide you with a detailed overview of the 70-462 certification test. Ace your Microsoft 70-462 at the first attempt and obtain the MCSA Administering Microsoft SQL Server 2012/2014 Databases credential with ease.

# of Students
477
# of Lectures
108
Course Length
11 h
Course Rating
4.5
Price $32.99
Today $29.99

Curriculum for 70-462 Video Course

Introduction

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

Student Feedback

5 Stars
4 Stars
3 Stars
2 Stars
1 Star
4.5
Rating: 4.5
Overall Rating: Good.

Similar Courses

Only Registered Members can View Training Courses

Please fill out your email address below in order to view Training Courses. Registration is Free and Easy, You Simply need to provide an email address.

  • Trusted by 1.2M IT Certification Candidates Every Month
  • Hundreds Hours of Videos
  • Instant download After Registration

Already Member? Click here to Login

A confirmation link will be sent to this email address to verify your login

1200+ IT Certification Exams available: Get a free sample of any exam right now!
Try Free Demo

Try Free Demo

  • ABA
  • ACAMS
  • ACFE
  • ACI
  • ACSM
  • Adobe
  • AHIMA
  • AHIP
  • AHLEI
  • AICPA
  • AIWMI
  • Alfresco
  • AMA
  • Amazon
  • AndroidATC
  • APBM
  • API
  • APICS
  • Apple
  • Arista
  • Aruba
  • ASIS
  • ASQ
  • Atlassian
  • Autodesk
  • Avaya
  • Axis Communications
  • BACB
  • BCS
  • BICSI
  • Blockchain
  • Blue Coat
  • Blue Prism
  • Brocade
  • C++ Institute
  • CA Technologies
  • Checkpoint
  • CIMA
  • Cisco
  • Citrix
  • CIW
  • Cloudera
  • CompTIA
  • CSA
  • CWNP
  • CyberArc
  • Dell
  • DMI
  • DSCI
  • ECCouncil
  • EMC
  • Esri
  • Exin
  • Extreme Networks
  • F5
  • FileMaker
  • FINRA
  • Fortinet
  • GAQM
  • GARP
  • Genesys
  • GIAC
  • Google
  • Guidance Software
  • H3C
  • HFMA
  • HIPAA
  • Hitachi
  • HP
  • HRCI
  • Huawei
  • IAPP
  • IBM
  • IFPUG
  • IIA
  • IIBA
  • Informatica
  • Isaca
  • iSAQB
  • ISC
  • iSQI
  • ISTQB
  • ITIL
  • Juniper
  • Linux Foundation
  • Logical Operations
  • LPI
  • Magento
  • Marketo
  • McAfee
  • Microsoft
  • Mulesoft
  • NACVA
  • NCMA
  • Network Appliance
  • NI
  • Nokia
  • Novell
  • Nuage Networks
  • OMG
  • Palo Alto Networks
  • Pegasystems
  • PEOPLECERT
  • PMI
  • PRINCE2
  • Python Institute
  • QlikView
  • RedHat
  • Riverbed
  • RSA
  • Salesforce
  • SANS
  • SAP
  • SAS Institute
  • Scrum
  • SDI
  • ServiceNow
  • Six Sigma
  • SNIA
  • SOA
  • Software Certifications
  • SolarWinds
  • Splunk
  • SpringSource
  • Symantec
  • The Open Group
  • Tibco
  • VCE
  • Veeam
  • Veritas
  • Vmedu
  • VMware
  • WatchGuard
  • WorldatWork
  • Zend
Next Step
Next Step

Try Free Demo

  • Microsoft
Next Step
Next Step

Summer Sale! Get 25% Discount on All Your Purchases!

Passguide Products

Enter Your Email Address to Receive Your 25%
OFF
Discount Code Plus... Our Exclusive Weekly Deals

* We value your privacy. We will not rent or sell your email address