---
title: "Tutorial: SQL Server Management Studio (SSMS) | Microsoft Docs"
ms.custom: ""
ms.date: "08/30/2017"
ms.prod: "sql-non-specified"
ms.prod_service: "sql-tools"
ms.service: ""
ms.component: "ssms-tutorial"
ms.reviewer: ""
ms.suite: "sql"
ms.technology: 
  - "tools-ssms"
ms.tgt_pltfrm: ""
ms.topic: "article"
f1_keywords: 
  - "sql13.tutorialstart.ssms.f1"
helpviewer_keywords: 
  - "projects [SQL Server Management Studio], tutorials"
  - "templates [SQL Server], SQL Server Management Studio"
  - "source controls [SQL Server Management Studio], tutorials"
  - "Help [SQL Server], SQL Server Management Studio"
  - "tutorials [SQL Server Management Studio]"
  - "Transact-SQL tutorials"
  - "solutions [SQL Server Management Studio], tutorials"
  - "SQL Server Management Studio [SQL Server], tutorials"
  - "scripts [SQL Server], SQL Server Management Studio"
ms.assetid: d2bade70-07cf-4d94-b5d2-88aecb538ed1
caps.latest.revision: 22
author: "stevestein"
ms.author: "sstein"
manager: "craigg"
ms.workload: "Active"
---
# Tutorial: SQL Server Management Studio
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]

The SQL Server Management Studio (SSMS) tutorial introduces you to the integrated environment for managing your [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] infrastructure. [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] presents a graphical interface for configuring, monitoring, and administering instances of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]. It also allows you to deploy, monitor, and upgrade the data-tier components used by your applications, such as databases. [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] also provides [!INCLUDE[tsql](../../includes/tsql-md.md)], MDX, DMX, and XML language editors for editing and debugging scripts.  
  
## What You Will Learn  
This tutorial will help you understand the presentation of information in SSMS and how to take advantage of its features.
  
The best way to get acquainted with SSMS is through hands-on practice. This tutorial will teach you how to manage the components of SSMS and how to find the features that you use regularly.  
  
This tutorial is divided into three lessons:  
  
[Lesson 1: Basic Navigation in SQL Server Management Studio](lesson-1-basic-navigation-in-sql-server-management-studio.md)  
In this lesson you will learn how to use the components of [!INCLUDE[ssManStudio](../../includes/ssmanstudio-md.md)], how to reconfigure the environment layout, and how to restore the default layout.  
  
[Lesson 2: Writing Transact-SQL](lesson-2-writing-transact-sql.md)  
In this lesson, you will learn how to open Query Editor, how to manage code, and how to use other features of Query Editor.  
  
[Lesson 3: Working with Templates, Solutions, and Script Projects](lesson-3-working-with-templates-solutions-and-script-projects.md)  
In this lesson you will learn how to use templates, and organize scripts into solutions and projects.  
  
## Requirements  
This tutorial is intended for experienced database administrators and database developers who are not familiar with [!INCLUDE[vsprvs](../../includes/vsprvs-md.md)], but who are familiar with database concepts and [!INCLUDE[tsql](../../includes/tsql-md.md)].  
  
You must have the following installed to use this tutorial:  

  
-   Install the latest version of [SQL Server Management Studio (SSMS)](../download-sql-server-management-studio-ssms.md).  
-   SQL Server 2016 or a later version with the AdventureWorks sample database. To install the AdventureWorks sample database, see [AdventureWorks2014](https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks2014) and install the AdventureWorks2014 (OLTP) database.  

  
## See Also  
[Database Engine Tutorials](../../relational-databases/database-engine-tutorials.md)