lesson-1-creating-database-objects.md

title	Lesson 1: Creating Database Objects | Microsoft Docs
ms.custom
ms.date	06/13/2017
ms.prod	sql-server-2014
ms.reviewer
ms.technology	t-sql
ms.topic	conceptual
ms.assetid	9fb8656b-0e4e-4ada-b404-4db4d3eea995
author	VanMSFT
ms.author	vanto
manager	craigg

Lesson 1: Creating Database Objects

This lesson shows you how to create a database, create a table in the database, and then access and change the data in the table. Because this lesson is an introduction to using [!INCLUDEtsql], it does not use or describe the many options that are available for these statements.

[!INCLUDEtsql] statements can be written and submitted to the [!INCLUDEssDE] in the following ways:

• By using [!INCLUDEssManStudioFull]. This tutorial assumes that you are using [!INCLUDEssManStudio], but you can also use [!INCLUDEssManStudio] Express, which is available as a free download from the Microsoft Download Center.

• By using the sqlcmd utility.

• By connecting from an application that you create.

The code executes on the [!INCLUDEssDE] in the same way and with the same permissions, regardless of how you submit the code statements.

To run [!INCLUDEtsql] statements in [!INCLUDEssManStudio], open [!INCLUDEssManStudio] and connect to an instance of the [!INCLUDEssDEnoversion].

This lesson contains the following topics:

• Creating a Database (Tutorial)

• Creating a Table (Tutorial)

• Inserting and Updating Data in a Table (Tutorial)

• Reading the Data in a Table (Tutorial)

• Summary: Creating Database Objects

Next Task in Lesson

Creating a Database (Tutorial)