Administering Microsoft SQL Server 2012 Part 2

The Complete Oracle SQL Certification Course

Microsoft SQL for Beginners

SQL - MySQL for Data Analytics and Business Intelligence

This Jump Start helps current and aspiring data professionals understand the process of administering SQL Server 2012 databases. It helps you prepare for Exam 70-462, a component of the MCSA: SQL Server certification, and it is the prerequisite for the Implementing a Data Warehouse with SQL Server Jump Start course. These SQL Server 2012 training videosJump Start focuses on security, data management, and disaster recovery/high availability, along with their implications for the configuration of the enterprise. The courseIt includes demos on storage design and capacity configuration, security configuration, optimization of the instance, and automation.

Instructors | Rich Currey - Microsoft Certified Trainer; George Squillace - Microsoft Certified Trainer

Associated Exam(s) | 70-462: Administering Microsoft SQL Server 2012 Databases
Related Certification | MCSA: SQL Server
Associated Course(s) | 10775: Administering Microsoft SQL Server 2012 Databases
Install and Configure SQL Server

This module discusses issues and the major decisions involved in installing and initially configuring SQL Server. The information provided will help you to avoid making mistakes that are difficult to reverse and could require reinstallation.
Maintain Instances and Databases

In this module you will learn about some of the frequently used instance-level and database-level options. Implementing the primary automation features of jobs and alerts is discussed and demonstrated thoroughly.
Performance Optimization and Troubleshooting

SQL Servers operate in a dynamic environment; conditions change moment by moment. This module discusses and demonstrates primary diagnostic and performance enhancement tools such as the Profiler, the Database Engine Tuning Advisor, the Management Data Warehouse, and Catalog and Dynamic Management Views.
Manage Data

Protection and stewardship of data is one of the database administrator’s first orders of business. In this module you’ll gain an understanding of tasks and strategies that are related to backup and restore operations and investigating database integrity with DBCC commands. Maintenance of indexes, which are vitally important to the performance of queries, will also be discussed and demonstrated.
Implement Security

“When in doubt, it’s my fault” is what the DBA must live by, and this is definitely true regarding the stewardship of security. Instance, database, and object security strategies are examined as well as the implementation of logins and server roles, user and database roles, and leveraging schema objects.
High Availability Options

Some of the planet’s heaviest database workloads sit on SQL Server, and the loss of availability could be catastrophic. SQL Server offers a number of high availability technologies that can be used alone, or in some cases, together. The high availability technologies of failover clustering, replication, log shipping, database mirroring, and AlwaysOn are examined and compared.
Learn

Explore the process of administering SQL Server 2012 databases.

Video source via: MVA
----------------------------------------------------