Administering Microsoft SQL Server 2012 Part 1
Channel: Databases A2Z
Date: 2017-12-19

Social Network for Developers ☞ https://morioh.com
Developers Chat Channel ☞ https://discord.gg/KAe3AnN
Learn to code for free and get a developer job ☞ https://codequs.com/ 
Playlists Video Tutorial ☞ http://dev.edupioneer.net/f086e182ab 

Aiodex’s Referral Program  will give you 20% -80% commission from their transaction fee for 7 years. The value will be calculated starting from the date the member you invite sign up ☞ http://vrl.to/c4099b4d9f
Next Generation Shorten Platform: Optimal choice to make a profit and analyze traffic sources on the network. Shorten URLs and Earn Big Money ☞ https://viralroll.com/ 
Get Free 15 Geek ☞  https://geekcash.org/ 

The Complete SQL Bootcamp ☞ http://deal.codetrick.net/p/HJH7nHmre
SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL☞ http://deal.codetrick.net/p/ByFsBFzYZ
The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert ☞ http://deal.codetrick.net/p/r1dP1euzZ-

The Complete Oracle SQL Certification Course
☞ http://deal.codetrick.net/p/SJVtrUlbl

Microsoft SQL for Beginners
☞ http://deal.codetrick.net/p/B1IOnjlbe

SQL - MySQL for Data Analytics and Business Intelligence
☞ http://deal.codetrick.net/p/SJTQlR66W

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
----------------------------------------------------
Website: https://goo.gl/qAJxMe
Playlist: https://goo.gl/hnwbLS
Fanpage: https://goo.gl/HpLFJG
Twitter: https://goo.gl/t7NhrT