Information Technology Basics
Fundamental principles and concepts
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.
Data+Become a specialist with access to over 1,400 data science courses.
₹734/mo
Data+Become a specialist with access to over 1,400 data science courses.
₹514
Why choose Security+?
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
Practical ApplicationTrending
Real-world project implementationBest Practices
Industry standard workflows and guidelinesCareers: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
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 curriculum compares with alternatives
Outcomes
- 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 learning outcomes
FAQs
Top Alternatives
Highly-rated courses worth your attention
