Microsoft Official Curriculum

20462: Administering Microsoft SQL Server Databases

Instructor: Jeff Jones
Duration: 22 Hours and 56 Minutes

This Microsoft Official Curriculum (MOC) video course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014.  It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform. The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job. The secondary audience for this course is individuals who develop applications that deliver content from SQL Server databases.

Love this course? Please tell your friends.
Loading the player . . .

Microsoft Official Training On Video –
with Online Labs and Official Courseware!

TBD
Coming Soon!

Includes 6 Months Streaming Video Access, 6 Months Online Lab

Access and Microsoft Official Courseware (choice of digital or printed)

Eligible for Microsoft Software Assurance (SA) Vouchers

About This Course
Introduction to 20462C 3:24
Course Outline 5:25
14:20
5:19
Module 1: Introduction to SQL Server 2014 Database Administration
1:23
0:57
2:43
3:7
2:33
1:18
13:52
1:41
13:57
Lab: Using SQL Server Administrative Tools
Module 2: Considerations for SQL Server Installation
1:20
1:20
4:23
2:43
8:55
4:44
5:45
9:21
0:57
3:37
19:27
6:49
0:49
3:45
1:41
14:9
2:27
Lab: Using SQL Server Administrative Tools
Module 3: Module Introduction
2:39
1:36
How Data Is Stored in SQL Server 10:0
7:29
7:45
1:3
6:20
4:34
10:14
1:45
5:27
12:33
9:3
5:51
9:14
1:20
6:3
Detaching and Attaching Databases Demo 6:23
1:30
5:51
5:52
6:27
Lab: Using SQL Server Administrative Tools
Module 4: Planning and Implementing a Backup Strategy
1:42
1:19
Overview of SQL Server Transaction Logs 4:11
8:45
6:8
5:44
5:42
7:21
6:36
2:47
7:34
3:52
5:41
2:28
2:26
2:28
4:33
1:7
2:31
7:12
Performing Database Backups 2:28
3:39
1:31
11:3
1:8
4:17
3:56
Encrypting Backups 2:51
6:11
1:24
3:23
6:32
6:6
Lab: Using SQL Server Administrative Tools
Module 5: Restoring SQL Server 2014 Databases
1:55
1:10
3:24
4:14
3:24
5:15
0:39
7:14
3:21
3:23
10:28
2:34
6:11
1:50
5:45
12:21
5:8
8:29
1:19
2:20
2:1
6:27
1:19
7:41
Lab: Using SQL Server Administrative Tools
Module 6: Importing and Exporting Data
1:38
1:13
4:47
7:28
7:50
3:0
1:25
3:2
11:6
4:38
9:59
5:45
4:6
4:1
3:36
1:31
11:31
2:41
10:37
3:41
6:1
Lab: Using SQL Server Administrative Tools
Module 7: Monitoring SQL Server 2014
1:21
1:12
9:3
9:12
5:13
13:59
2:35
5:20
4:52
10:26
1:19
3:5
3:9
1:42
15:11
Lab: Using SQL Server Administrative Tools
Module 8: Tracing SQL Server Activity
1:1
1:37
3:16
6:59
12:3
3:58
11:27
2:2
5:14
16:22
1:49
4:54
3:26
6:44
Lab: Using SQL Server Administrative Tools
Module 9: Managing SQL Server Security
1:11
0:49
4:14
6:38
7:20
1:33
4:3
2:30
5:16
4:55
2:58
13:13
2:9
5:2
3:18
3:58
11:14
6:6
6:15
4:27
7:52
2:2
4:31
4:48
7:22
8:53
6:26
9:11
Lab: Using SQL Server Administrative Tools
Module 10: Auditing Data Access and Encrypting Data
1:5
1:50
1:58
2:13
2:17
4:21
9:57
2:21
2:49
10:52
5:5
7:22
12:56
1:46
4:18
5:41
2:21
10:2
4:30
Lab: Using SQL Server Administrative Tools
Module 11: Performing Ongoing Database Maintenance
1:34
1:52
13:29
11:34
1:59
5:17
8:8
5:4
6:49
3:44
11:59
1:10
3:38
13:32
Lab: Using SQL Server Administrative Tools
Module 12: Automating SQL Server 2014 Management
2:20
0:48
4:30
0:52
7:44
21:27
1:40
5:15
5:34
1:1
4:17
6:17
7:30
1:25
7:18
12:15
Lab: Using SQL Server Administrative Tools
Module 13: Monitoring SQL Server 2014 with Notifications and Alerts
1:18
0:46
6:4
5:1
1:6
8:21
9:54
1:27
2:51
9:17
7:33
4:2
10:44
Lab: Using SQL Server Administrative Tools

You must purchase this course in order to watch this video.
Already purchased? Please login

About This Course

Loading the player . . .


Introduction to 20462C

Loading the player . . .


Course Outline

Loading the player . . .


How Data Is Stored in SQL Server

Loading the player . . .


Detaching and Attaching Databases Demo

Loading the player . . .


Overview of SQL Server Transaction Logs

Loading the player . . .


Performing Database Backups

Loading the player . . .


Encrypting Backups

Loading the player . . .