| 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 |
|
|||||||||
| ms.tgt_pltfrm | ||||||||||
| ms.topic | article | |||||||||
| f1_keywords |
|
|||||||||
| helpviewer_keywords |
|
|||||||||
| ms.assetid | d2bade70-07cf-4d94-b5d2-88aecb538ed1 | |||||||||
| caps.latest.revision | 22 | |||||||||
| author | BYHAM | |||||||||
| ms.author | rickbyh | |||||||||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx_md]
The [!INCLUDEssManStudioFull] tutorial introduces you to the integrated environment for managing your [!INCLUDEssNoVersion] infrastructure. [!INCLUDEssManStudioFull] presents a graphical interface for configuring, monitoring, and administering instances of [!INCLUDEssNoVersion]. It also allows you to deploy, monitor, and upgrade the data-tier components used by your applications, such as databases. [!INCLUDEssManStudioFull] also provides [!INCLUDEtsql], MDX, DMX, and XML language editors for editing and debugging scripts.
This tutorial will help you understand the presentation of information in [!INCLUDEssManStudio] and how to take advantage of the features. Note that this tutorial uses the free [!INCLUDEssManStudio] downloaded from the download center.
The best way to get acquainted with [!INCLUDEssManStudio] is through hands-on practice. This tutorial will teach you how to manage the components of [!INCLUDEssManStudio] 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
In this lesson you will learn how to use the components of [!INCLUDEssManStudio], how to reconfigure the environment layout, and how to restore the default layout.
Lesson 2: Writing Transact-SQL
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
In this lesson you will learn how to use templates, and organize scripts into solutions and projects.
This tutorial is intended for experienced database administrators and database developers who are not familiar with [!INCLUDEvsprvs], but who are who are familiar with database concepts and the [!INCLUDEtsql] language.
Your system must have the following installed to use this tutorial:
-
[!INCLUDEssCurrent] or a later version with the [!INCLUDEssSampleDBobject] 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.
-
Install the latest version of SQL Server Management Studio from the download center.
-
Internet Explorer 9.0 or later.