SQL Server: Installing and Configuring SQL Server 2016 from Pluralsight

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.

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.

What's inside

Syllabus

Course Overview

Introduction

Pre-installation Tasks for the Operating System

Pre-installation Tasks for SQL Server 2016

Installing SQL Server 2016

Post-installation Tasks for SQL Server 2016

Automating Common Maintenance Tasks

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Strengthens an existing foundation for intermediate learners

Explores a relevant topic in industry

Develops core skills

Builds a strong foundation for beginners

Disadvantages of older software

Some prerequisites are required

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in SQL Server: Installing and Configuring SQL Server 2016 with these activities:

Configure network concepts

Show steps

By reviewing network configuration skills prior to taking this course, you will be better equipped to succeed.

Browse courses on Networking

Show steps

Review OSI model and TCP/IP
Practice basic network commands

Review SQL basics

Show steps

Review of SQL basics will help you to understand the advanced concepts covered in the course.

Show steps

Review basic SQL syntax
Practice writing simple SQL queries

Follow Microsoft tutorials on installing SQL Server

Show steps

Following Microsoft's tutorials will provide you with a step-by-step guide to installing SQL Server.

Show steps

Locate the Microsoft tutorials on installing SQL Server
Follow the instructions in the tutorials

Four other activities

Expand to see all activities and additional details

Show all seven activities

Practice installing SQL Server on a virtual machine

Show steps

Hands-on practice will help you to solidify your understanding of the installation process.

Show steps

Set up a virtual machine
Install SQL Server on the virtual machine

Create a step-by-step guide to installing SQL Server

Show steps

Creating a step-by-step guide will help you to solidify your understanding of the installation process and provide a valuable resource for future reference.

Show steps

Document the steps involved in installing SQL Server
Create a step-by-step guide

Attend a workshop on SQL Server installation

Show steps

Attending a workshop will provide you with an opportunity to learn from experts and ask questions.

Show steps

Find a workshop on SQL Server installation
Attend the workshop

Participate in a SQL Server installation competition

Show steps

Participating in a competition will motivate you to learn the material and test your skills.

Show steps

Find a SQL Server installation competition
Practice for the competition
Participate in the competition

Career center

Learners who complete SQL Server: Installing and Configuring SQL Server 2016 will develop knowledge and skills that may be useful to these careers:

Database Administrator

A Database Administrator (DBA) is responsible for the overall maintenance, performance, and security of a database system. They ensure that the database is running smoothly and efficiently, and that data is backed up and protected. This course can help you prepare for a career as a DBA by providing you with a solid foundation in SQL Server installation and configuration. You will learn how to choose the right hardware and software for your database, how to install and configure SQL Server, and how to keep your database up-to-date and secure. This knowledge will be essential for success in this role.

See salaries and explore the career path for Database Administrator

Data Analyst

A Data Analyst is responsible for collecting, cleaning, and analyzing data to help businesses make better decisions. They use their skills in data analysis, statistics, and programming to identify trends and patterns in data, and to develop insights that can help businesses improve their operations. This course can help you prepare for a career as a Data Analyst by providing you with a solid foundation in SQL Server. You will learn how to use SQL Server to query and analyze data, and how to create reports and visualizations that can help businesses understand their data. This knowledge will be essential for success in this role.

See salaries and explore the career path for Data Analyst

Software Engineer

A Software Engineer is responsible for designing, developing, and maintaining software applications. They use their skills in programming, mathematics, and engineering to create software that meets the needs of users. This course can help you prepare for a career as a Software Engineer by providing you with a solid foundation in SQL Server. You will learn how to use SQL Server to store and manage data, and how to develop applications that interact with SQL Server. This knowledge will be essential for success in this role.

See salaries and explore the career path for Software Engineer

Systems Analyst

A Systems Analyst is responsible for analyzing and designing business systems. They work with businesses to understand their needs and to develop systems that meet those needs. This course can help you prepare for a career as a Systems Analyst by providing you with a solid foundation in SQL Server. You will learn how to use SQL Server to store and manage data, and how to develop applications that interact with SQL Server. This knowledge will be essential for success in this role.

See salaries and explore the career path for Systems Analyst

Business Analyst

A Business Analyst is responsible for understanding the business needs of an organization and developing solutions that meet those needs. They work with stakeholders to define requirements, analyze data, and develop recommendations. This course can help you prepare for a career as a Business Analyst by providing you with a solid foundation in SQL Server. You will learn how to use SQL Server to query and analyze data, and how to create reports and visualizations that can help businesses understand their data. This knowledge will be essential for success in this role.

See salaries and explore the career path for Business Analyst

Database Developer

A Database Developer is responsible for designing and developing databases. They work with businesses to understand their needs and to develop databases that meet those needs. This course can help you prepare for a career as a Database Developer by providing you with a solid foundation in SQL Server. You will learn how to use SQL Server to create and manage databases, and how to develop applications that interact with SQL Server. This knowledge will be essential for success in this role.

See salaries and explore the career path for Database Developer

ETL Developer

An ETL Developer is responsible for designing and developing Extract, Transform, and Load (ETL) processes. ETL processes are used to extract data from multiple sources, transform the data into a consistent format, and load the data into a target database. This course can help you prepare for a career as an ETL Developer by providing you with a solid foundation in SQL Server. You will learn how to use SQL Server to extract, transform, and load data, and how to develop ETL processes that are efficient and reliable. This knowledge will be essential for success in this role.

See salaries and explore the career path for ETL Developer

Data Warehouse Engineer

A Data Warehouse Engineer is responsible for designing and developing data warehouses. Data warehouses are used to store and manage large amounts of data for business intelligence and analytics. This course can help you prepare for a career as a Data Warehouse Engineer by providing you with a solid foundation in SQL Server. You will learn how to use SQL Server to create and manage data warehouses, and how to develop data warehouse solutions that are scalable and efficient. This knowledge will be essential for success in this role.

See salaries and explore the career path for Data Warehouse Engineer

Data Scientist

A Data Scientist is responsible for using data to solve business problems. They use their skills in data science, machine learning, and statistics to analyze data and develop models that can predict future outcomes. This course can help you prepare for a career as a Data Scientist by providing you with a solid foundation in SQL Server. You will learn how to use SQL Server to query and analyze data, and how to create reports and visualizations that can help businesses understand their data. This knowledge will be essential for success in this role.

See salaries and explore the career path for Data Scientist

IT Manager

An IT Manager is responsible for overseeing the IT infrastructure of an organization. They work with other IT professionals to ensure that the IT infrastructure is running smoothly and efficiently. This course can help you prepare for a career as an IT Manager by providing you with a solid foundation in SQL Server. You will learn how to use SQL Server to store and manage data, and how to develop applications that interact with SQL Server. This knowledge will be essential for success in this role.

See salaries and explore the career path for IT Manager

Network Administrator

A Network Administrator is responsible for overseeing the network infrastructure of an organization. They work with other IT professionals to ensure that the network is running smoothly and efficiently. This course may be useful in preparing you for a career as a Network Administrator by providing you with a solid foundation in SQL Server. You will learn how to use SQL Server to store and manage data, and how to develop applications that interact with SQL Server. This knowledge may be useful in managing network systems and services.

See salaries and explore the career path for Network Administrator

Project Manager

A Project Manager is responsible for planning, coordinating, and executing projects. They work with stakeholders to define project goals, develop project plans, and track project progress. This course may be useful in preparing you for a career as a Project Manager by providing you with a solid foundation in SQL Server. You will learn how to use SQL Server to store and manage data, and how to develop applications that interact with SQL Server. This knowledge may be useful in managing project data and tracking project progress.

See salaries and explore the career path for Project Manager

Quality Assurance Analyst

A Quality Assurance Analyst is responsible for testing and verifying the quality of software applications. They work with developers to identify and fix defects in software applications. This course may be useful in preparing you for a career as a Quality Assurance Analyst by providing you with a solid foundation in SQL Server. You will learn how to use SQL Server to store and manage data, and how to develop applications that interact with SQL Server. This knowledge may be useful in testing and verifying the quality of software applications that interact with SQL Server.

See salaries and explore the career path for Quality Assurance Analyst

Technical Writer

A Technical Writer is responsible for writing technical documentation for software applications and other technical products. They work with engineers and other technical professionals to create documentation that is clear, concise, and accurate. This course may be useful in preparing you for a career as a Technical Writer by providing you with a solid foundation in SQL Server. You will learn how to use SQL Server to store and manage data, and how to develop applications that interact with SQL Server. This knowledge may be useful in writing technical documentation for software applications that interact with SQL Server.

See salaries and explore the career path for Technical Writer

Web Developer

A Web Developer is responsible for designing and developing websites and web applications. They work with designers and other developers to create websites that are visually appealing, functional, and easy to use. This course may be useful in preparing you for a career as a Web Developer by providing you with a solid foundation in SQL Server. You will learn how to use SQL Server to store and manage data, and how to develop applications that interact with SQL Server. This knowledge may be useful in developing data-driven websites and web applications.

See salaries and explore the career path for Web Developer