Microsoft 70-462: Administering SQL Server 2012 Database

Lesson 1: Identifying the SQL Server Platform

1. Overview
2. DataStorage-Part 1
3. DataStorage-Part 2

Lesson 2: Deploying SQL Server

1. Install-Part 1
2. Install-Part 2

Lesson 3: Configuring SQL Server

1. Configuring-Part 1
2. Configuring-Part 2
3. Changing Memory-Part 1
4. Changing Memory-Part 2
5. Email-Part 1
6. Email-Part 2

Lesson 4: Managing Databases in SQL Server 2012

1. User Databases-Part 1
2. User Databases-Part 2
3. User Databases-Part 3
4. User Databases-Part 4
5. User Databases-Part 5

Lesson 5: Managing SQL Server Security

1. Setting Security-Part 1
2. Setting Security-Part 2
3. Server Roles-Part 1
4. Server Roles-Part 2
5. Setting Permissions-Part 1
6. Setting Permissions-Part 2

Lesson 6: Implementing Advanced Security Settings

1. Querying Data From Multiple Tables-Part 1
2. Querying Data From Multiple Tables-Part 2
3. Querying Data From Multiple Tables-Part 3
4. Querying Data From Multiple Tables-Part 4
5. Querying Data From Multiple Tables-Part 5

Lesson 7: Applying Encryption and Compression

1. Encrypting And Compressing-Part 1
2. Encrypting And Compressing-Part 2
3. Encrypting And Compressing-Part 3

Lesson 8: Working with Indexes and Log Files

1. Functions-Part 1
2. Functions-Part 2
3. Functions-Part 3
4. Functions-Part 4
5. Functions-Part 5
6. Functions-Part 6

Lesson 9: Working with Backup and Restore

1. Managing Backups-Part 1
2. Managing Backups-Part 2
3. Managing Backups-Part 3
4. Managing Backups-Part 4
5. Managing Backups-Part 5
6. Managing Backups-Part 6
7. Managing Backups-Part 7

Lesson 10: Implementing High Availability

1. Stored Procedures-Part 1
2. Stored Procedures-Part 2
3. Stored Procedures-Part 3
4. Stored Procedures-Part 4

Lesson 11: Optimizing Server Performance

1. Managing SQL Performance-Part 1
2. Managing SQL Performance-Part 2
3. Managing SQL Performance-Part 3
4. Managing SQL Performance-Part 4
5. Managing SQL Performance-Part 5
6. Managing SQL Performance-Part 6
7. Managing SQL Performance-Part 7

Lesson 12: Troubleshooting Issues and Recovering Databases

1. Set Operators-Part 1
2. Set Operators-Part 2
3. Set Operators-Part 3
4. Set Operators-Part 4
5. Set Operators-Part 5

Lesson 13: Performing Advanced Database Management Tasks

1. Managing Database Infrastructures-Part 1
2. Managing Database Infrastructures-Part 2
3. Managing Database Infrastructures-Part 3