MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Microsoft SQL Server 2012 Certification Training Exam 70-462

Course Summary

Study For The Microsoft 70-462 Exam - Administering Microsoft SQL Server 2012 Databases


  • +

    Course Syllabus

    • Introduction
      • 0101 What Is Exam 70-462?
      • 0102 What You Should Expect From The Videos
    • Installation And Configuration
      • 0201 Growing And Shrinking Databases
      • 0202 Monitoring Database Growth
      • 0203 Designing Database Storage
      • 0204 Configure An SQL Server Standby Server - Part 1
      • 0205 Configure An SQL Server Standby Server - Part 2
      • 0206 Changing Service Accounts
      • 0207 Testing Database Connectivity
      • 0208 Installing SQL Server Database Engine - Part 1
      • 0209 Installing SQL Server Database Engine - Part 2
      • 0210 Installing SQL Server Database Engine - Part 3
      • 0211 Installing SQL Server Database Engine - Part 4
      • 0212 Installing SQL Server Integration Services
      • 0213 Enabling And Disabling Features
      • 0214 Moving Databases Via Detach/Attach
      • 0215 Migrating Logins
      • 0216 Creating A Full Text Index
      • 0217 Configuring FILESTREAM
      • 0218 Configuring FILETABLE
      • 0219 Create And Manage SQL Agent Jobs - Part 1
      • 0220 Create And Manage SQL Agent Jobs - Part 2
      • 0221 Setup Multi-Server Jobs
    • Maintain Instances And Databases
      • 0301 Using Multiple Files And Filegroups
      • 0302 Recovery Models
      • 0303 Adding New Filegroups
      • 0304 Moving Tables Between Filegroups
      • 0305 Enabling Contained Databases
      • 0306 Data Compression
      • 0307 Configuring TDE
      • 0308 Setting Up Table Partitioning - Part 1
      • 0309 Setting Up Table Partitioning - Part 2
      • 0310 Managing Log File Growth - Part 1
      • 0311 Managing Log File Growth - Part 2
      • 0312 DBCC CHECKDB
      • 0313 Installing Default And Named Instances - Part 1
      • 0314 Installing Default And Named Instances - Part 2
      • 0315 CPU Affinity
      • 0316 Instance Level Settings - Part 1
      • 0317 Instance Level Settings - Part 2
      • 0318 Instance Level Settings - Part 3
      • 0319 Memory Settings
      • 0320 Database Mail
      • 0321 Fillfactor
      • 0322 Installing A Clustered Instance - Part 1
      • 0323 Installing A Clustered Instance - Part 2
      • 0324 Installing A Clustered Instance - Part 3
      • 0325 Installing A Clustered Instance - Part 4
      • 0326 Multi-Instance Clustering
      • 0327 Multi-Subnet Clustering
      • 0328 Recover From A Failed Cluster Node
    • Optimization And Troubleshooting
      • 0401 Replication For Reporting - Part 1
      • 0402 Replication For Reporting - Part 2
      • 0403 Replication For Reporting - Part 3
      • 0404 Replication For Reporting - Part 4
      • 0405 Diagnosing Locking And Blocking - Part 1
      • 0406 Diagnosing Locking And Blocking - Part 2
      • 0407 Diagnosing Wait Stats
      • 0408 Using SQL Profiler
      • 0409 Using Performance Monitor - Part 1
      • 0410 Using Performance Monitor - Part 2
      • 0411 Using Extended Events
      • 0412 Using SQL Server Auditing
      • 0413 Using Data Collector
      • 0414 Using Policy Based Management
    • Manage Data
      • 0501 Define Recovery Models
      • 0502 Mirrored Backups
      • 0503 Stripped Backups
      • 0504 Restoring Full Backups
      • 0505 Restoring Differential Backups
      • 0506 Restoring Transaction Log Backups
      • 0507 File Group Restores
      • 0508 Testing Backups
      • 0509 Restoring Master Database
      • 0510 Restoring msdb Database
      • 0511 Restoring model Database
      • 0512 Restoring Databases Protected By TDE
      • 0513 Restoring A Single Database Page
      • 0514 Point In Time Restores
      • 0515 Index Maintenance
      • 0516 Identifying Index Fragmentation
      • 0517 Identifying Unused Indexes
      • 0518 Filtered Indexes
      • 0519 Updating Statistics
      • 0520 Full Text Indexes
      • 0521 Column Store Indexes
      • 0522 Import Export Wizard
      • 0523 BCP
      • 0524 Bulk Insert
    • Implement Security
      • 0601 Logins Vs. Users
      • 0602 Creating Logins
      • 0603 Fixed Server Roles
      • 0604 User Defined Server Roles
      • 0605 Certificate Logins
      • 0606 Instance Level Permissions
      • 0607 Database Level Permissions
      • 0608 Fixed Database Roles
      • 0609 User Defined Database Roles
      • 0610 Application Roles
      • 0611 Creating Database Users
      • 0612 Managing Certificates
      • 0613 Endpoint Security
    • Implement High Availability
      • 0701 Configure Database Mirroring
      • 0702 Configure AlwaysOn Availability Groups - Part 1
      • 0703 Configure AlwaysOn Availability Groups - Part 2
      • 0704 Failing Over Database Mirroring
      • 0705 Failing Over AlwaysOn Availability Groups
      • 0706 Monitoring Database Mirroring
    • Conclusion
      • Thank You


Course Fee:
USD 99

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top