SQL Server - Easy Install & Configure a Developer Instance
4.0 (2 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,569 students enrolled

SQL Server - Easy Install & Configure a Developer Instance

How to install and configure a SQL Server Developer's Database with Sample Data
4.0 (2 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,569 students enrolled
Created by Brian Tallon
Last updated 11/2018
English
English [Auto-generated]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 31 mins on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Students will have a fully functional SQL Server instance with a practice database installed.
Requirements
  • A basic knowledge of installing Windows software is helpful. Administrator access to a Windows PC or Server is required.
Description

There are plenty of SQL Server development and management courses here at Udemy and throughout the Internet.  But almost all have one thing in common.  They assume that you already have an instance of SQL Server installed and configured with data loaded to practice on. 

But where do you start if you aren't exactly sure how to get this environment set up?   Why right here.  This short course takes you through a step-by-step download, install and setup of a developer's version of SQL Server 2017.  And best of all, you'll see how to get the software for free!

And that's not all!  Once we have SQL Server set up, we'll install the most useful SQL Server tool, SQL Server Management Studio.  Once we have complete access to SQL Server, we'll find and install a full sample database complete with thousands of rows of sample data for you to practice on.

This is a beginner course that helps you prepare an environment for many other great courses!

Who this course is for:
  • Beginner SQL Server users who want to install their own instance of SQL Server before taking other courses.
Course content
Expand all 9 lectures 31:11
+ Introduction
1 lecture 02:36

An introduction to the course, the instructor and a brief understanding of what we'll learn and why.

Preview 02:36
+ Preparing For Installation
3 lectures 09:02

In this lecture, we'll cover the versions and software that we'll use and the technical prerequisites required.  We'll also discuss an optional tool.

Preview 04:26

A discussion on Hyper-V, a tool that I find useful when installing any software for both practice and production use.

Preview 02:53

We'll find the Microsoft website to download SQL Server and assure we are using the correct version.

Preview 01:43
+ The Installs
3 lectures 11:16

This lecture takes us through the SQL Server installation.  Follow along each step of the way.

Let's Install SQL Server
04:20

The most important tool you'll use after the installation, SQL Server Management Studio, will be downloaded.

SQL Server Management Studio Download
02:15

We will walk through the SSMS installation together and get connected to our recent SQL Server installation.

SQL Server Management Studio Install
04:41
+ Loading Sample Data
1 lecture 07:05

In this section, we'll find, download and install the Wide World Importers sample database.

Wide World Importers
07:05
+ Course Wrap Up
1 lecture 01:12

Final wrap up.

Wrap Up
01:12
Find the AdventurWorks Sample Database, download it, and restore it using the same procedure we used to load the Wide World Importers Database
Find and Load AdventureWorks Sample Database
1 question