Learning SQL Server 2017

1h 21mBeginner2018-01-09

Authors

Adam Wilbert

Data Visualization Expert

Course details

Microsoft SQL Server can be an intimidating system. In this course, instructor Adam Wilbert provides a quick overview of how SQL Server works—which can go a long way to making you feel more comfortable as you start exploring its powerful capabilities. Adam goes over the most important features of SQL Server 2017, helping to familiarize you with how the server operates. He introduces the main working environment—SQL Server Management Studio—and walks through how to start creating tables and manipulating data.

Learning objectives
Reviewing the different editions of SQL Server
Configuring and starting the server
Touring the SQL Server Management Studio (SSMS) interface
Creating a new database on the server
Creating a data table
Joining tables together with keys
Writing Transact-SQL commands

Skills covered

SQL ServerDatabase AdministrationDatabase ManagementLearningMicrosoft

Concepts

0. Introduction

01 - Welcome
02 - What you should know

1. Getting Started

03 - What is SQL Server
04 - Understand the editions of SQL Server
05 - Installing SQL Server

2. Working with the Server

06 - Configure and start the server
07 - Log in to the server
08 - Locate SQL Server documentation

3. SQL Server Management Studio (SSMS)

09 - Tour the SSMS interface
10 - Install a sample database
11 - Create a new database on the server
12 - Understand SQL data types
13 - Create a data table
14 - Join tables together with keys

4. Write Transact-SQL Commands

15 - Create a SELECT statement
16 - Use functions to calculate values
17 - Write an UPDATE statement
18 - Add data with an INSERT statement
19 - Create a view of the data

Conclusion

20 - Next steps