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 70-462 Administering SQL Server 2012 Databases

Video Description

This training course was created specifically for those individuals (Database Professionals) who install, maintain and configure as their primary job function. Any participants setting up database systems and/or responsible for efficient system operation, regular database back ups stored effectively, and securing data from unauthorised access is also a candidate for this training course on SQL 2012.

Table of Contents

  1. Administering Microsoft SQL Server 2012 Databases
    1. Course Introduction 00:00:55
    2. Course Modules 00:01:00
  2. Module 1
    1. Introduction to SQL Server 2012 00:00:18
    2. SQL Server Part1 00:01:50
    3. SQL Server Part2 00:05:19
    4. SQL Server Part3 00:05:51
    5. SQL Server Part4 00:05:20
    6. SQL Server Tools Part1 00:01:03
    7. SQL Server Tools Part2 00:05:32
    8. SQL Server Tools Part3 00:03:05
    9. Management Studio Demo Part1 00:05:35
    10. Management Studio Demo Part2 00:03:57
    11. Management Studio Demo Part3 00:05:50
    12. Data Tools Part1 00:05:27
    13. Data Tools Part2 00:03:42
    14. Exam Scenarios 1 00:02:44
    15. Module 1 Review 00:01:49
  3. Module 2
    1. Installing SQL Server 00:00:17
    2. SQL Architecture 00:01:04
    3. Hardware Requirements Part1 00:07:15
    4. Hardware Requirements Part2 00:03:23
    5. Software Requirements Part1 00:03:17
    6. Software Requirements Part2 00:01:07
    7. Installation Process 00:01:33
    8. Troubleshooting Installation 00:02:17
    9. Upgrading and Unattended Installations Part1 00:00:08
    10. Upgrading and Unattended Installations Part2 00:05:02
    11. Configuration Demo Part1 00:07:13
    12. Configuration Demo Part2 00:02:05
    13. Exam Scenarios 2 00:02:55
    14. Module 2 Review 00:01:05
  4. Module 3
    1. Backup and Restore a Database 00:00:14
    2. Database Architecture Part1 00:00:12
    3. Database Architecture Part2 00:07:18
    4. Database Architecture Part3 00:01:15
    5. Database Backup Part1 00:00:16
    6. Database Backup Part2 00:06:44
    7. Database Backup Part3 00:03:51
    8. Restoration Process Part1 00:00:17
    9. Restoration Process Part2 00:06:42
    10. Restoring System Database Part1 00:00:06
    11. Restoring System Database Part2 00:02:11
    12. Backup and Recovery Demo Part1 00:07:36
    13. Backup and Recovery Demo Part2 00:05:12
    14. Exam Scenarios 3 00:04:33
    15. Module 3 Review 00:02:04
  5. Module 4
    1. Tracing Access to SQL Server 00:00:20
    2. Auditing Options Part1 00:00:16
    3. Auditing Options Part2 00:07:37
    4. Introduction to SQL Audit Part1 00:00:10
    5. Introduction to SQL Audit Part2 00:02:01
    6. Audit Objects and Implementation 00:04:42
    7. Extended Events Part1 00:00:05
    8. Extended Events Part2 00:00:38
    9. Tracing Activity Demo Part1 00:08:16
    10. Tracing Activity Demo Part2 00:06:53
    11. Tracing Activity Demo Part3 00:04:10
    12. Tracing Activity Demo Part4 00:04:54
    13. Exam Scenarios 4 00:03:02
    14. Module 4 Review 00:01:03
  6. Module 5
    1. Importing and Exporting Data 00:00:16
    2. Introduction to Data Transfer Part1 00:00:08
    3. Introduction to Data Transfer Part2 00:01:14
    4. ETL Tools 00:06:05
    5. Improving Data Transfer Part1 00:01:46
    6. Improving Data Transfer Part2 00:00:47
    7. Improving Data Transfer Part3 00:00:58
    8. Improving Data Transfer Part4 00:03:50
    9. Copying Database Methods Part1 00:03:04
    10. Copying Database Methods Part2 00:00:42
    11. Transferring Data Demo Part1 00:04:36
    12. Transferring Data Demo Part2 00:04:24
    13. Exam Scenarios 5 00:02:18
    14. Module 5 Review 00:01:07
  7. Module 6
    1. SQL Server Security 00:00:09
    2. Security and Authentication 00:08:06
    3. Server and Database Roles 00:04:04
    4. Permissions Part1 00:03:36
    5. Permissions Part2 00:07:47
    6. Securing SQL Server Demo Part1 00:07:53
    7. Securing SQL Server Demo Part2 00:05:49
    8. Exam Scenarios 6 00:02:33
    9. Module 6 Review 00:01:26
  8. Module 7
    1. Automating SQL Server 00:00:10
    2. SQL Server Agent 00:04:04
    3. Database Mail 00:04:17
    4. Operators, Alerts and Jobs 00:08:19
    5. Database Configuration Demo Part1 00:03:09
    6. Database Configuration Demo Part2 00:07:20
    7. Database Configuration Demo Part3 00:06:21
    8. Database Configuration Demo Part4 00:03:04
    9. Exam Scenarios 7 00:02:43
    10. Module 7 Review 00:01:28
  9. Module 8
    1. Monitoring SQL Server 00:00:23
    2. Dynamic Management Views and Functions 00:01:12
    3. Profiler Trace 00:01:14
    4. Database Tuning Advisor 00:01:27
    5. Activity and Performance Monitor 00:02:30
    6. Data Collection 00:03:53
    7. Monitoring Demo Part1 00:04:00
    8. Monitoring Demo Part2 00:06:03
    9. Monitoring Demo Part3 00:04:38
    10. Monitoring Demo Part4 00:04:16
    11. Monitoring Demo Part5 00:04:51
    12. Monitoring Demo Part6 00:03:57
    13. Monitoring Demo Part7 00:02:58
    14. Exam Scenarios 8 00:03:53
    15. Module 8 Review 00:01:42
  10. Module 9
    1. Maintaining SQL Server 00:00:12
    2. Checking Database Integrity 00:04:15
    3. Indexing Part1 00:06:10
    4. Indexing Part2 00:05:28
    5. Indexing Part3 00:01:48
    6. Ongoing Maintenance 00:03:42
    7. Managing and Maintaining Demo Part1 00:05:50
    8. Managing and Maintaining Demo Part2 00:07:18
    9. Managing and Maintaining Demo Part3 00:06:10
    10. Exam Scenarios 9 00:01:52
    11. Module 9 Review 00:00:57
  11. Module 10
    1. Troubleshooting SQL Server 00:00:11
    2. Service Issues 00:01:00
    3. Connectivity Issues 00:01:08
    4. Locking Issues 00:04:53
    5. Troubleshooting Demo Part1 00:03:09
    6. Troubleshooting Demo Part2 00:07:38
    7. Exam Scenarios 10 00:02:32
    8. Module 10 Review 00:00:53
    9. Program Review 00:01:51