SQL Server: Installing and Configuring SQL Server 2016

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.

4|Reviews (111)
Pluralsight Teams₹4,166.75 per user/month, billed annually
₹50,004
CompleteBilled Monthly
₹2,370/mo

Why choose Core Tech?

check
3,900+ Courses
check
Software Development
check
IT Operations
check
Product & UX
check
Business Skills
verifiedGet this course for free with the Coursera Plus subscription.
✓ Compare courses before making a decision
Check Latest Price →
Price may vary. Check latest price on provider site.

Course Insight

Suitable for beginner learners. This course serves as an entry point into Information Technology, building foundational knowledge before moving on to advanced frameworks or specialized paths.

Beginner FriendlySelf-Paced Learning

SKILLS TO
MASTER

Information Technology Basics
Fundamental principles and concepts
Practical ApplicationTrending
Real-world project implementation
Best Practices
Industry standard workflows and guidelines
Problem Solving
Core Concepts
Implementation
Workflow Integration
Optimization
Careers:Relevant for professionals pursuing roles within Information Technology.

Quick Facts

Below sections are verified from last major sync. For real-time updates and today's latest lectures, Check official page here.

What You’ll Learn

  • Course Overview : 1min.
  • Introduction : 16mins.
  • Pre-installation Tasks for the Operating System : 21mins.
  • Pre-installation Tasks for SQL Server 2016 : 27mins.
  • Installing SQL Server 2016 : 15mins.
  • Post-installation Tasks for SQL Server 2016 : 20mins.
  • Automating Common Maintenance Tasks : 19mins.
See side-by-side differences in what you’ll learn

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.

See how this course compares with alternatives

FAQs

Top Alternatives

Highly-rated courses worth your attention

Installing and Configuring System Center 2016 - Operations Manager (SCOM)
⭐ 4.0· 4 Hrs
Intermediate
CORE TECH
₹10,563/yr|₹1,254/mo
SQL Server: Improving Storage Subsystem Performance
⭐ 4.0· 2 - Hrs 13 minutes
Intermediate
CORE TECH
₹10,563/yr|₹1,254/mo
Installing and Configuring IIS Servers
⭐ 4.0· 1 Hrs 42 minutes
Intermediate
CORE TECH
₹10,563/yr|₹1,254/mo
Installing and Configuring Windows 10/11
⭐ 4.0· 1 Hrs 42 minutes
Intermediate
CORE TECH
₹10,563/yr|₹1,254/mo
Implementing and Securing Windows Server 2016 Core Networking
⭐ 4.0· 2 Hrs 43 minutes
Intermediate
CORE TECH
₹10,563/yr|₹1,254/mo
Project Server 2013 Installation
⭐ 4.0· 2 - Hrs 22 minutes
Intermediate
CORE TECH
₹10,563/yr|₹1,254/mo
SQL Server: Installing and Configuring SQL Server 2016
⭐ 4(111+ learners)