Brian Alderman

Senior Technical Instructor

  • 2

    Courses
  • 21 Years
    Experience
Start 7-Day FREE trial

In our Administering Microsoft SQL Server 2012 course, you will gain the knowledge and skills necessary to maintain a Microsoft SQL Server 2012 database. In particular, this course will teach you how to use SQL Server 2012 tools and features to maintain databases.

This course is preparation for success on Exam 70-462, and will help you gain your MCSA: SQL Server certification.

Exam Number: 70-462

1

SQL Server 2012 Introduction

42 minutes

2

SQL Server Architectures and Server Resource Requirements

43 minutes

3

Installing and Configuring SQL Server 2012

43 minutes

4

Working with Databases

67 minutes

5

Understanding SQL Server 2012 Recovery Models

44 minutes

6

Backup of SQL Server 2012 Databases

57 minutes

7

Restoring a SQL Server 2012 Database

43 minutes

8

Importing and Exporting Data in SQL Server 2012

36 minutes

9

Authenticating and Authorizing Users

46 minutes

10

Assigning Server and Database Roles

67 minutes

11

Auditing SQL Server Environments

71 minutes

12

Monitoring SQL Server 2012 with Alerts and Notifications

65 minutes

13

Automating Routine Database Maintenance for SQL Server 2012

49 minutes

14

Monitoring SQL Server 2012

48 minutes

15

Managing Multiple Servers

28 minutes

16

Troubleshooting Common SQL Server 2012 Administrative Issues

28 minutes