---
title: "Tutorial: SQL Server Management Studio | Microsoft Docs"
ms.custom: ""
ms.date: "06/02/2016"
ms.prod: "sql-server-2016"
ms.reviewer: ""
ms.suite: ""
ms.technology: 
  - "database-engine"
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: "BYHAM"
ms.author: "rickbyh"
manager: "jhubbard"
---
# Tutorial: SQL Server Management Studio
[!INCLUDE[tsql-appliesto-ss2008-asdb-xxxx-xxx_md](../../includes/tsql-appliesto-ss2008-asdb-xxxx-xxx-md.md)]

The [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] 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 [!INCLUDE[ssManStudio](../../includes/ssmanstudio-md.md)] and how to take advantage of the features. Note that this tutorial uses the free [!INCLUDE[ssManStudio](../../includes/ssmanstudio-md.md)] downloaded from the download center.  
  
The best way to get acquainted with [!INCLUDE[ssManStudio](../../includes/ssmanstudio-md.md)] is through hands-on practice. This tutorial will teach you how to manage the components of [!INCLUDE[ssManStudio](../../includes/ssmanstudio-md.md)] 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](../../tools/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](../../tools/sql-server-management-studio/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 the other new features of Query Editor.  
  
[Lesson 3: Working with Templates, Solutions, and Script Projects](../../tools/sql-server-management-studio/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 who are familiar with database concepts and the [!INCLUDE[tsql](../../includes/tsql-md.md)] language.  
  
Your system must have the following installed to use this tutorial:  
  
-   [!INCLUDE[ssCurrent](../../includes/sscurrent-md.md)] or a later version with the [!INCLUDE[ssSampleDBobject](../../includes/sssampledbobject-md.md)] sample databases. To enhance security, the sample databases are not installed by default. To install the sample databases, see [Installing SQL Server Samples and Sample Databases](http://sqlserversamples.codeplex.com).  
  
-   Install the latest version of [SQL Server Management Studio](https://msdn.microsoft.com/library/mt238290.aspx) from the download center.  
  
-   Internet Explorer 9.0 or later.  
  
## See Also  
[Database Engine Tutorials](../../relational-databases/database-engine-tutorials.md)