SQL Server 2016 Core, Part 2 of 3: Install and Configure

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.

Each LearnNowOnline training course is made up of Modules (typically an hour in length). Within each module there are Topics (typically 15-30 minutes each) and Subtopics (typically 2-5 minutes each). There is a Post Exam for each Module that must be passed with a score of 70% or higher to successfully and fully complete the course.

Prerequisites

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

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.

Video Runtime

137 Minutes

Time to complete

246 Minutes

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)