Microsoft 70-462: Administering SQL Server 2012 Databases

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

Adding to its data management system Microsoft has come up with a new Server, Microsoft SQL Server 2012 which familiarizes us with the construction and usage of databases in SQL Server platform. This course is the successor of Microsoft SQL Server 2012, a step higher into the administration of the data system. It is an excellent platform for students to build database systems, ensure effective operation of the systems apart from storing, and securing data from any kind of unauthorized access. The course intends to target all data professionals including data analysts and other aspiring professionals who wants to get ready for exam 70-462, also known as Administering Microsoft SQL Server 2012 Databases.

Towards the end of this course our participants will have a thorough knowledge on maintaining various databases including the instances, trouble shooting and optimizing apart from data management and contriving high availability and security.

This course is that is the basis for all other SQL Server-related disciplines—Database Development, Database Administration, and Business Intelligence. The main idea of this course is to make our students cognize SQL Server 2012 databases administration. You will be comprehending a lot about the various issues and other decisions that are part of SQL Server installation and configuration.