O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft SQL Server 2012 Certification Training - Exam 70-462

Video Description

In this SQL Server 70-462 exam training course, expert author Denny Cherry 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. Denny Cherry 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.

Table of Contents

  1. Introduction
    1. What Is Exam 70-462? 00:02:20
    2. What You Should Expect From The Videos 00:03:54
  2. Installation And Configuration
    1. Growing And Shrinking Databases 00:09:50
    2. Monitoring Database Growth 00:07:36
    3. Designing Database Storage 00:10:24
    4. Configure An SQL Server Standby Server - Part 1 00:13:52
    5. Configure An SQL Server Standby Server - Part 2 00:07:06
    6. Changing Service Accounts 00:13:12
    7. Testing Database Connectivity 00:10:08
    8. Installing SQL Server Database Engine - Part 1 00:11:37
    9. Installing SQL Server Database Engine - Part 2 00:11:35
    10. Installing SQL Server Database Engine - Part 3 00:08:53
    11. Installing SQL Server Database Engine - Part 4 00:05:00
    12. Installing SQL Server Integration Services 00:07:03
    13. Enabling And Disabling Features 00:07:22
    14. Moving Databases Via Detach/Attach 00:07:46
    15. Migrating Logins 00:06:30
    16. Creating A Full Text Index 00:05:13
    17. Configuring FILESTREAM 00:01:29
    18. Configuring FILETABLE 00:01:34
    19. Create And Manage SQL Agent Jobs - Part 1 00:09:23
    20. Create And Manage SQL Agent Jobs - Part 2 00:04:31
    21. Setup Multi-Server Jobs 00:07:00
  3. Maintain Instances And Databases
    1. Using Multiple Files And Filegroups 00:07:57
    2. Recovery Models 00:06:07
    3. Adding New Filegroups 00:02:25
    4. Moving Tables Between Filegroups 00:06:05
    5. Enabling Contained Databases 00:04:58
    6. Data Compression 00:10:20
    7. Configuring TDE 00:06:52
    8. Setting Up Table Partitioning - Part 1 00:09:15
    9. Setting Up Table Partitioning - Part 2 00:10:20
    10. Managing Log File Growth - Part 1 00:08:32
    11. Managing Log File Growth - Part 2 00:02:14
    12. DBCC CHECKDB 00:09:10
    13. Installing Default And Named Instances - Part 1 00:07:49
    14. Installing Default And Named Instances - Part 2 00:05:42
    15. CPU Affinity 00:05:26
    16. Instance Level Settings - Part 1 00:09:13
    17. Instance Level Settings - Part 2 00:09:03
    18. Instance Level Settings - Part 3 00:10:52
    19. Memory Settings 00:05:18
    20. Database Mail 00:08:40
    21. Fillfactor 00:06:45
    22. Installing A Clustered Instance - Part 1 00:07:58
    23. Installing A Clustered Instance - Part 2 00:08:38
    24. Installing A Clustered Instance - Part 3 00:09:19
    25. Installing A Clustered Instance - Part 4 00:01:48
    26. Multi-Instance Clustering 00:03:57
    27. Multi-Subnet Clustering 00:04:28
    28. Recover From A Failed Cluster Node 00:04:05
  4. Optimization And Troubleshooting
    1. Replication For Reporting - Part 1 00:08:23
    2. Replication For Reporting - Part 2 00:11:54
    3. Replication For Reporting - Part 3 00:12:24
    4. Replication For Reporting - Part 4 00:07:36
    5. Diagnosing Locking And Blocking - Part 1 00:08:53
    6. Diagnosing Locking And Blocking - Part 2 00:06:15
    7. Diagnosing Wait Stats 00:11:29
    8. Using SQL Profiler 00:10:15
    9. Using Performance Monitor - Part 1 00:07:33
    10. Using Performance Monitor - Part 2 00:05:29
    11. Using Extended Events 00:08:25
    12. Using SQL Server Auditing 00:08:14
    13. Using Data Collector 00:05:22
    14. Using Policy Based Management 00:06:53
  5. Manage Data
    1. Define Recovery Models 00:04:05
    2. Mirrored Backups 00:01:39
    3. Stripped Backups 00:02:40
    4. Restoring Full Backups 00:04:17
    5. Restoring Differential Backups 00:05:41
    6. Restoring Transaction Log Backups 00:04:16
    7. File Group Restores 00:04:11
    8. Testing Backups 00:02:33
    9. Restoring Master Database 00:05:23
    10. Restoring msdb Database 00:00:49
    11. Restoring model Database 00:00:33
    12. Restoring Databases Protected By TDE 00:03:50
    13. Restoring A Single Database Page 00:02:12
    14. Point In Time Restores 00:05:33
    15. Index Maintenance 00:10:22
    16. Identifying Index Fragmentation 00:04:34
    17. Identifying Unused Indexes 00:06:33
    18. Filtered Indexes 00:03:24
    19. Updating Statistics 00:03:39
    20. Full Text Indexes 00:15:09
    21. Column Store Indexes 00:07:51
    22. Import Export Wizard 00:05:55
    23. BCP 00:08:32
    24. Bulk Insert 00:03:35
  6. Implement Security
    1. Logins Vs. Users 00:02:57
    2. Creating Logins 00:05:54
    3. Fixed Server Roles 00:05:48
    4. User Defined Server Roles 00:04:12
    5. Certificate Logins 00:02:18
    6. Instance Level Permissions 00:03:16
    7. Database Level Permissions 00:05:13
    8. Fixed Database Roles 00:05:43
    9. User Defined Database Roles 00:02:49
    10. Application Roles 00:04:15
    11. Creating Database Users 00:06:06
    12. Managing Certificates 00:02:19
    13. Endpoint Security 00:03:35
  7. Implement High Availability
    1. Configure Database Mirroring 00:10:54
    2. Configure AlwaysOn Availability Groups - Part 1 00:10:34
    3. Configure AlwaysOn Availability Groups - Part 2 00:07:59
    4. Failing Over Database Mirroring 00:02:38
    5. Failing Over AlwaysOn Availability Groups 00:07:54
    6. Monitoring Database Mirroring 00:04:37
  8. Conclusion
    1. About The Author 00:01:21
    2. Thank You 00:04:00