SQL Server: Installing and Configuring SQL Server 2016

Pluralsight
Course Summary
Learn how to correctly install and configure SQL Server 2016, including configuration of Windows and storage for stability and performance, and post-installation updates, configuration, and database maintenance.
-
+
Course Description
How do you configure Windows correctly for running SQL Server 2016? How do you choose a RAID level for the SQL Server storage? Which installation options should you choose for SQL Server, and how do you keep SQL Server up-to-date after installing it? This course, SQL Server: Installing and Configuring SQL Server 2016, answers all these questions and more. The course begins by explaining why it is so important to install SQL Server 2016 correctly and then explains how to configure Windows for stability and performance. It then describes and shows the SQL Server 2016 installation process, including which options to choose or not, along with common configuration mistakes to avoid. After that it explains how to keep your SQL Server 2016 instance up-to-date with Service Packs and Cumulative Updates, as well as post-installation configuration tasks. Finally it explains how to configure Database Mail and SQL Server Agent Alerts so that you are notified of critical errors when they occur. When you're finished with this course, you'll be better prepared to install SQL Server for the first time.
-
+
Course Syllabus
Course Overview- 1m 37s
—Course Overview 1m 37sIntroduction- 16m 25s
—Introduction and Correct Installation 3m 20s
—Main SQL Server 2016 Editions and License Limits 5m 29s
—Correct Configuration and Proper Maintenance 3m 26s
—Course Objectives 2m 17s
—Course Structure and Module Summary 1m 51sPre-installation Tasks for the Operating System- 21m 1sPre-installation Tasks for SQL Server 2016- 27m 44sInstalling SQL Server 2016- 15m 12sPost-installation Tasks for SQL Server 2016- 20m 8sAutomating Common Maintenance Tasks- 19m 20s