Lynda – Installing and Administering Microsoft SQL Server 2016-0daytown

Lynda – Installing and Administering Microsoft SQL Server 2016

Size: 342 MB | Duration: 2h 36m | Video: AVC (.mp4) 1280×720 15&30fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Intermediate | Language: English
SQL Server is the database used with Azure and many on-premises environments and is quickly becoming a very popular RDBMS. Get an overview of installing, administering, and managing SQL Server 2016 in this course with SQL Server expert Gerry O’Brien. Learn how to install the database and tools, configure different instances, optimize performance, and secure your database with user roles and logins. Gerry also covers administrative duties such as backup and restoration, database migration, and high-availability options, including database replication, log shipping, and always-on availability. This course is also ideal for anybody preparing for the Administering a SQL Database Infrastructure (70-764) exam, one of two exams necessary to earn an MCSA: SQL 2016 Database Administration certification.

Topics include:

* Installation and configuration considerations
* Data storage strategies
* Configuring database instances
* Performance considerations
* Security considerations
* Managing roles and users
* Managing data
* High-availability options