Learn your way! Get started

SQL Server 2016 Core, Part 2: Install and Configure

with expert Don Kiely


Watch trailer


Course at a glance

Included in these subscriptions:

  • Dev & IT Pro Video
  • Dev & IT Pro Power Pack

Release date 9/12/2017
Level Beginner
Runtime 2h 17m
Closed captioning N/A
Transcript N/A
eBooks / courseware N/A
Hands-on labs N/A
Sample code Included
Exams Included


Enterprise Solutions

Need reporting, custom learning tracks, or SCORM? Learn More



Course description

Modern versions of SQL Server are very easy products to install—the setup program walks you through all of the necessary steps to installing the features you need. There are a number of decisions you’ll have to make along the way, which can seem a bit overwhelming, particularly if you’re new to SQL Server. The good news is that Microsoft carefully considered most of the default settings so that they’ll work in many scenarios. And for most installation options, you can change the setting later, even after using the server in production for a while. But in order to ensure that you are able to perform a successful installation with a resulting server that will serve your needs, you should do some careful planning and preparation long before you start up the SQL Server installation program. In this course, you'll learn about the basic hardware and software requirements for a successful installation, and learn about some of the decisions you'll need to make about security and instances of SQL Server. Then we'll explore some of the issues involved in upgrading an existing instance of and older version of SQL Server. You'll see a tool from Microsoft that makes the process way easier, because it identifies issues that you might face during the update process. Then we'll run through an entire installation of SQL Server, as I explore the process and some of the options and decisions you'll face along the way. Then we'll wrap up by looking at how you can configure SQL Server after installation, so that it perfectly suits your needs with the features it needs.

Prerequisites

This course does not require any prior experience with Microsoft SQL Server or with database programming.

Learning Paths

This course is part of the following LearnNowOnline SuccessPaths™:
SQL Server Core

Meet the expert

Don Kiely Don Kiely is a featured instructor on many of our SQL Server and Visual Studio courses. He is a nationally recognized author, instructor, and consultant specializing in Microsoft technologies. Don has many years of teaching experience, is the author or co-author of several programming books, and has spoken at many industry conferences and user groups. In addition, Don is a consultant for a variety of companies that develop distributed applications for public and private organizations.


Course outline



Installation

Preparing to Install (21:24)
  • Introduction (01:14)
  • Hardware and Software Requirements (03:41)
  • Other Considerations (02:09)
  • Setting up the Service Accounts (05:05)
  • Multiple Instances (03:09)
  • Multiple Instance Scenarios (02:54)
  • Using Named Instances (00:59)
  • Instance Components (01:51)
  • Summary (00:17)
Upgrading (15:42)
  • Introduction (00:22)
  • Upgrading an Earlier Version (06:27)
  • Data Migration Assistant (01:11)
  • Demo: Getting Ready to Upgrade (01:33)
  • Demo: Data Migration Assistant (05:00)
  • Summary (01:08)
Installation (19:03)
  • Introduction (00:42)
  • SQL Server Installation (02:59)
  • Demo: Planning Installation (04:11)
  • Demo: New Installation (04:36)
  • Demo: Updates and Install Rules (05:56)
  • Summary (00:36)
Customizing Installation (26:18)
  • Introduction (00:19)
  • Demo: Feature Selection (04:46)
  • Demo: Instance and Server Configuration (05:54)
  • Demo: Startup and Collation (03:30)
  • Demo: Database Engine Configuration (06:12)
  • Demo: Database Engine Configuration Continued (05:17)
  • Summary (00:17)
Performing Installation (03:40)
  • Introduction (00:24)
  • Demo: Ready to Install (01:31)
  • Demo: Installation (01:11)
  • Summary (00:32)

Server Configuration

Install SSMS and SSDT (13:20)
  • Introduction (00:55)
  • Demo: Install SSMS (03:55)
  • Demo: Install SSDT (03:17)
  • Demo: Using SSMS and SSDT (04:52)
  • Summary (00:19)
Configure the Server (09:54)
  • Introduction (00:20)
  • SQL Server Configuration Manager (00:35)
  • Demo: SQL Server Configuration Manager (03:47)
  • Demo: Protocols and Native Client (04:37)
  • Summary (00:33)
More Server Config (28:28)
  • Introduction (00:49)
  • Demo: Underlying Code (05:05)
  • Demo: Server Properties (02:28)
  • Demo: Memory Properties (03:52)
  • Processors Properties (01:42)
  • Security Properties (03:00)
  • Demo: Connections Properties (03:30)
  • Demo: Database Settings Properties (02:55)
  • Demo: Advanced Properties (04:13)
  • Summary (00:51)